Fatal error: Call to a Member Function num_rows() on a non-object

Question

I’m looking for the total number of lines of a query but keeps giving this error, I’ve tried to use the function Row(), rowCount() and even check if found any results to return and still not reached the solution

Fatal error: Call to a Member Function num_rows() on a non-object in C: wamp www topsamp-ci application models Servor_model.php on line 86

public function getVotosHoje($idServer){
    $data = date('Y-m-d');
    $select = array('id', 'data');
    $where = "idServidor = '$idServer' AND data = '$data'";
    $this->db->where($where);
    $this->db->select($select);
    $retorno = $this->db->get('votos')->result();
    if($retorno->num_rows() > 0){
        return $retorno->num_rows();
    } else{
        return false;
    }
}

Answer 1

You are wrong result() does not return a class with functions, it returns the data, therefore it does not have the function num_rows():

$retorno = $this->db->get('votos')->result();
if($retorno->num_rows() > 0){
    return $retorno->num_rows();
} else{
    return false;
}

It’s right to use it like this:

$total = $this->db->get('votos')->num_rows();

if($total > 0){
    return $total;
} else{
    return false;
}

Now if what you want is to take the records if it’s bigger than 0 then do so:

$retorno = $this->db->get('votos');

if($retorno->num_rows() > 0){ //Conta registros
    return $retorno->result(); //Retorna os registros
} else{
    return false; //Retorna false se tiver 0 registros
}