Call to undefined function mysqli_result::num_rows()

by

From the manual, it seems that mysqli_result::num_rows isn’t a function, but rather a variable containing the number of rows.

It can be used like this:

$num_rows = $mysqli_result->num_rows;

The function equivalent is mysqli_num_rows($result), where you pass in the mysqli_result object, but that’s if you’re using the procedural style rather than object oriented style.

In your code, you should change your count() function in the utils_MysqlImprovedResult class to be like this (I’m assuming that’s the function where you’re getting the error message),

public function count()
{
    // Any other processing you want
    // ...
    return $this->_result->num_rows;
}

or alternatively if you want to mix OO and procedural styles (probably a bad idea),

public function count()
{
    // Any other processing you want
    // ...
    return mysqli_num_rows($this->_result);
}

More Related Contents:

  1. Save the data into a database and return another value from database using PHP
  2. inserting information and image in php and mysql
  3. mysqli or die, does it have to die?
  4. MySQL vs MySQLi when using PHP [closed]
  5. PHP error: “Cannot pass parameter 2 by reference”
  6. How to get count of rows in MySQL table using PHP?
  7. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  8. How to bind mysqli bind_param arguments dynamically in PHP?
  9. How can I enable the MySQLi extension in PHP 7?
  10. mysqli_stmt::bind_param(): Number of elements in type definition string doesn’t match number of bind variables
  11. Advantages Of MySQLi over MySQL [closed]
  12. check if the query results empty row mysqli [duplicate]
  13. Is mysql_real_escape_string() necessary when using prepared statements?
  14. Updating from MYSQL to MYSQLI [duplicate]
  15. mysqli_stmt::execute() expects exactly 0 parameters, 1 given
  16. Mysqli get_result alternative
  17. Using fetch_assoc on prepared statements
  18. Object of class mysqli_result could not be converted to string
  19. Single Value Mysqli [duplicate]
  20. How to prepare statement for update query? [duplicate]
  21. How can I bind an array of strings with a mysqli prepared statement?
  22. mysqli + xdebug breakpoint after closing statement result in many warnings
  23. mysqli_query(): Couldn’t fetch mysqli error [duplicate]
  24. Codeigniter: fatal error call to undefined function mysqli_init()
  25. PHP to MySQL SSL Connections
  26. mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]
  27. Using Prepared Statement, how I return the id of the inserted row?
  28. Is there any way to print the actual query that mysqli->execute() makes?
  29. When should I close a database connection in PHP?
  30. MySqli Commands out of sync; you can’t run this command now [duplicate]

Leave a Comment