database query returning empty array

Question

Hello, I have an appointment function at the bank. If the query returns 1 or more rows, the function returns an object (or a class), but if the query does not return any rows, the return is:

Array
(
    [0] => 00000
    [1] => 
    [2] => 
)

The function that makes the query:

    public function selectDB($sql,$params=null,$class=null){
        $query=$this->connect()->prepare($sql);
        $query->execute($params);

        if(isset($class)){
            $rs = $query->fetchAll(PDO::FETCH_CLASS,$class) or die(print_r($query->errorInfo(), true));
        }else{
            $rs = $query->fetchAll(PDO::FETCH_OBJ) or die(print_r($query->errorInfo(), true));
        }

        return $rs;
    }

I would like some suggestion to make this function return only 0 if the query has no lines. Thanks in advance.

Answer 1

After a pause to breathe and think a little, I solved the problem by modifying the select function in this way:

public function selectDB($sql,$params=null,$class=null){
        $q = $this->connect();
        $stmt = $q->prepare($sql);
        $stmt->execute();
        $res = array();
        if (isset($class)) {
            foreach($stmt as $row) {
                $res[] = $this->arrayToObject($row, $class);
            }
        } else {
            foreach($stmt as $row) {
                $res[] = $row;
            }
        }
        return $res;
    }

Function arrayToObject:

private function arrayToObject(array $array, string $class_name){
        $r = new ReflectionClass($class_name);
        $object = $r->newInstanceWithoutConstructor();
        $list = $r->getProperties();
        foreach($list as $prop){
          $prop->setAccessible(true);
          if(isset($array[$prop->name]))
            $prop->setValue($object, $array[$prop->name]);
        } 
        return $object;
    }