PHP MySQLi mysqli_more_results() - Checking for Additional Results

mysqli_more_results()

The mysqli_more_results() function checks if there are any more results available from a query executed with mysqli_multi_query() on the currently open connection.

EXAMPLE

<?php
$server = "localhost";
$username = "root";
$password = "";
$database = "mysqli_database";

$connection = mysqli_connect($server, $username, $password, $database);

if (mysqli_connect_errno()) {
    echo "Connection failed: " . mysqli_connect_error();
    exit();
}

// Combine two queries into one string, separated by a semicolon
$sql = "SELECT vegetable FROM mysqli_table ORDER BY vegetable ASC; ";
$sql .= "SELECT fruit FROM mysqli_table ORDER BY fruit ASC";

// Execute multiple queries at once
if (mysqli_multi_query($connection, $sql)) {
    do {
        // Process the current result set
        if ($result = mysqli_store_result($connection)) {
            while ($row = mysqli_fetch_row($result)) {
                printf("%s<br>", $row[0]);
            }
            mysqli_free_result($result);
        }
        
        // If more results are waiting in the background, print a separator line
        // NOTE: The mysqli_more_results() function returns true/false depending on whether the 
        // server has prepared the next packet of data for the next SQL command in the chain. Here 
        // we use it to draw a separator line exactly between the first and second result set.
        if (mysqli_more_results($connection)) {
            printf("------------<br>");
        }
        
    } while (mysqli_next_result($connection)); // Move to the next result
}

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This function is almost always used inside loops where we process multiple SQL commands at once (e.g., when requesting data from two different tables in a single call). It helps us determine when to prepare the next data set.

Returns TRUE if there is at least one more result set available.

Used in combination with mysqli_next_result().

Indispensable when performing complex batch processing.