mysqli prepared statement num_rows returns 0 while query returns greater than 0 [duplicate]

by

When you execute a statement through mysqli, the results are not actually in PHP until you fetch them — the results are held by the DB engine. So the mysqli_stmt object has no way to know how many results there are immediately after execution.

Modify your code like so:

$stmt->execute();
$stmt->store_result(); // pull results into PHP memory

// now you can check $stmt->num_rows;

See the manual

This doesn’t apply to your particular example, but if your result set is large, $stmt->store_result() will consume a lot of memory. In this case, if all you care about is figuring out whether at least one result was returned, don’t store results; instead, just check whether the result metadata is not null:

$stmt->execute();
$hasResult = $stmt->result_metadata ? true : false;

See the manual

More Related Contents:

  1. Can I mix MySQL APIs in PHP?
  2. How to change mysql to mysqli?
  3. How to prevent duplicate usernames when people register?
  4. Best way to INSERT many values in mysqli?
  5. SELECT COUNT(*) AS count – How to use this count
  6. How to use mysqli prepared statements?
  7. MySQLi prepared statements error reporting [duplicate]
  8. mysqli last insert id
  9. mysqli: can it prepare multiple queries in one statement?
  10. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  11. How to call a MySQL stored procedure from within PHP code?
  12. MySQLi count(*) always returns 1
  13. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  14. Do I have to guard against SQL injection if I used a dropdown?
  15. Using Mysqli bind_param with date and time columns?
  16. Using MySQLi from another class in PHP
  17. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  18. Call to a member function execute() on boolean in [duplicate]
  19. Unknown database error in PHP but it exists in PHPMyAdmin
  20. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  21. Can I blindly replace all mysql_ functions with mysqli_?
  22. Using PHP to execute multiple MYSQL Queries
  23. Get number of rows matched by UPDATE query with PHP mysqli
  24. How to use mysqli_query() in PHP?
  25. How to run multiple insert query in SQL using PHP in one go?
  26. Using Prepared Statement, how I return the id of the inserted row?
  27. Strange problem with the length of the field gotten from database [duplicate]
  28. PHP prepared statements and transactions in a loop [duplicate]
  29. When should I close a database connection in PHP?
  30. Mysqli multiple row insert, simple multi insert query [duplicate]

Leave a Comment