PHP Commands Out of Sync error

by

In mysqli::query If you use MYSQLI_USE_RESULT all subsequent calls will return error Commands out of sync unless you call mysqli_free_result()

When calling multiple stored procedures, you can run into the following error: “Commands out of sync; you can’t run this command now”.
This can happen even when using the close() function on the result object between calls.
To fix the problem, remember to call the next_result() function on the mysqli object after each stored procedure call. See example below:

<?php
// New Connection
$db = new mysqli('localhost','user','pass','database');

// Check for errors
if(mysqli_connect_errno()){
 echo mysqli_connect_error();
}

// 1st Query
$result = $db->query("call getUsers()");
if($result){
     // Cycle through results
    while ($row = $result->fetch_object()){
        $user_arr[] = $row;
    }
    // Free result set
    $result->close();
    $db->next_result();
}

// 2nd Query
$result = $db->query("call getGroups()");
if($result){
     // Cycle through results
    while ($row = $result->fetch_object()){
        $group_arr[] = $row;
    }
     // Free result set
     $result->close();
     $db->next_result();
}
else echo($db->error);

// Close connection
$db->close();
?>

I hope this will help

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. How to use mysqli prepared statements?
  6. MySQLi prepared statements error reporting [duplicate]
  7. mysqli last insert id
  8. mysqli: can it prepare multiple queries in one statement?
  9. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  10. How to call a MySQL stored procedure from within PHP code?
  11. MySQLi count(*) always returns 1
  12. Warning: mysqli_connect(): (HY000/2002): No such file or directory
  13. Do I have to guard against SQL injection if I used a dropdown?
  14. Using Mysqli bind_param with date and time columns?
  15. Using MySQLi from another class in PHP
  16. How do I display a MySQL error in PHP for a long query that depends on the user input? [duplicate]
  17. Call to a member function execute() on boolean in [duplicate]
  18. Mysql No connection could be made because the target machine actively refused it
  19. How to connect to MySQL database in PHP using mysqli extension?
  20. Unknown database error in PHP but it exists in PHPMyAdmin
  21. Fatal error: Uncaught exception ‘mysqli_sql_exception’ with message ‘No index used in query/prepared statement’
  22. Can I blindly replace all mysql_ functions with mysqli_?
  23. Using PHP to execute multiple MYSQL Queries
  24. Fatal error: Call to undefined method mysqli_stmt::fetch_array() [duplicate]
  25. How to run multiple insert query in SQL using PHP in one go?
  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. Which is fastest in PHP- MySQL or MySQLi?
  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