Why does mysqli num_rows always return 0?

by

You need to call mysqli_stmt::store_result() prior to the num_rows lookup:

if($stmt = $mysqli->prepare("SELECT id, title, visible, parent_id FROM content WHERE parent_id = ? ORDER BY page_order ASC;")){  
    $stmt->bind_param('s', $data->id);  
    $stmt->execute();
    $stmt->store_result(); <-- This needs to be called here!
    $num_of_rows = $stmt->num_rows;  
    $stmt->bind_result($child_id, $child_title, $child_visible, $child_parent);  

    while($stmt->fetch()){
        //code
    }

    echo($num_of_rows);

    $stmt->close();
}

See the docs on mysqli_stmt::num_rows, it says it right near the top of the page (in the main description block).

More Related Contents:

  1. Object of class mysqli_result could not be converted to string
  2. mysqli_query() expects at least 2 parameters, 1 given
  3. SELECT COUNT(*) AS count – How to use this count
  4. Mysqli update throwing Call to a member function bind_param() error [duplicate]
  5. mysqli bind_param() expected to be a reference, value given
  6. Should I manually check for errors when calling “mysqli_stmt_prepare”?
  7. mysqli::mysqli(): (HY000/2002): Can’t connect to local MySQL server through socket ‘MySQL’ (2)
  8. How to install MySQLi on MacOS
  9. The mysqli extension is missing. Please check your PHP configuration
  10. What is the difference between MySQL, MySQLi and PDO? [closed]
  11. parameters in MySQLi
  12. Retrieving Multiple Result sets with stored procedure in php/mysqli
  13. Mysql No connection could be made because the target machine actively refused it
  14. How to connect to MySQL database in PHP using mysqli extension?
  15. How do I count query result rows?
  16. Bind Param with array of parameters
  17. How do you use IN clauses with mysqli prepared statements [duplicate]
  18. What to do with mysqli problems? Errors like mysqli_fetch_array(): Argument #1 must be of type mysqli_result and such
  19. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  20. How to fetch all in assoc array from a prepared statement?
  21. Fatal error: Call to undefined function mysqli_result()
  22. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  23. Why I am getting an error when using w3school tutorial? [duplicate]
  24. Using wildcards in prepared statement
  25. mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it
  26. How to remove the fatal error when fetching an assoc array
  27. Fatal error: Call to undefined method mysqli_stmt::get_result()
  28. PHP MySQLi Multiple Inserts
  29. Fatal error: Call to a member function prepare() on a non-object in
  30. Strange problem with the length of the field gotten from database [duplicate]

Leave a Comment