How can PHP beginners effectively handle and process multiple resultsets from different SQL queries?

When handling multiple resultsets from different SQL queries in PHP, beginners can use the mysqli_multi_query function to execute multiple queries in a single call. After executing the queries, they can use mysqli_store_result to store each resultset and then fetch the rows from each resultset using functions like mysqli_fetch_assoc or mysqli_fetch_array. 

<?php
// Establish connection to the database
$mysqli = new mysqli("localhost", "username", "password", "database");

// Define multiple SQL queries to be executed
$sql = "SELECT * FROM table1; SELECT * FROM table2";

// Execute multiple queries in a single call
if ($mysqli->multi_query($sql)) {
    do {
        // Store the resultset
        if ($result = $mysqli->store_result()) {
            // Fetch rows from the resultset
            while ($row = $result->fetch_assoc()) {
                // Process the data
                print_r($row);
            }
            // Free the resultset
            $result->free();
        }
    } while ($mysqli->next_result());
}

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

Keywords

PHP SQL queries resultsets mysqli_next_result multi_query

Related Questions