CodeIgniter Forums
PHP Fatal error: Call to a member function num_rows() on boolean - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forum-5.html)
+--- Forum: General Help (https://forum.codeigniter.com/forum-24.html)
+--- Thread: PHP Fatal error: Call to a member function num_rows() on boolean (/thread-67747.html)



PHP Fatal error: Call to a member function num_rows() on boolean - mackavelli - 04-04-2017

PHP Code:
public function count_all_results($table ''$reset TRUE)
{
if (
$table !== '')
{
$this->_track_aliases($table);
$this->from($table);
}

$result = ($this->qb_distinct === TRUE)
$this->query($this->_count_string.$this->protect_identifiers('numrows')."\nFROM (\n".$this->_compile_select()."\n) CI_count_all_results")
$this->query($this->_compile_select($this->_count_string.$this->protect_identifiers('numrows')));

if (
$reset === TRUE)
{
$this->_reset_select();
}

if (
$result->num_rows() === 0// the error is on this line
{
return 
0;
}

$row $result->row();
return (int) 
$row->numrows;




// I have searched for a solution but nothing so far


RE: PHP Fatal error: Call to a member function num_rows() on boolean - koficypher - 04-04-2017

Reduce the number of equal to sign to two instead of 3.
change 
if ($result->num_rows() === 0

to:

if ($result->num_rows() == 0

Boolen 0 is false and 1 is true. 


 


RE: PHP Fatal error: Call to a member function num_rows() on boolean - Narf - 04-04-2017

(04-04-2017, 08:52 AM)koficypher Wrote: Reduce the number of equal to sign to two instead of 3.
change 
if ($result->num_rows() === 0

to:

if ($result->num_rows() == 0

Boolen 0 is false and 1 is true. 


 

This won't change anything.

It's not the num_rows() return value that's the problem.
It's that $result is not an object at all, meaning that the query errored.