How can the error "Commands out of sync; you can't run this command now" be resolved when using mysqli_multi_query in PHP?

The error "Commands out of sync; you can't run this command now" occurs when using mysqli_multi_query in PHP because the result sets from the previous queries have not been fetched or stored. To resolve this issue, you need to ensure that all result sets are fetched and stored before executing the next query in the multi-query. 

<?php

// Connect to the database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Check connection
if ($mysqli->connect_error) {
    die("Connection failed: " . $mysqli->connect_error);
}

// Perform multiple queries
$query = "SELECT * FROM table1; SELECT * FROM table2";
if ($mysqli->multi_query($query)) {
    do {
        if ($result = $mysqli->store_result()) {
            while ($row = $result->fetch_assoc()) {
                // Process the result set
            }
            $result->free();
        }
    } while ($mysqli->next_result());
} else {
    echo "Error: " . $mysqli->error;
}

// Close the connection
$mysqli->close();

?>

Keywords

mysqli_multi_query PHP Commands out of sync error resolution MySQL.

Related Questions