PHP MySQLi mysqli_reap_async_query() - Retrieving Asynchronous Results

mysqli_reap_async_query()

The mysqli_reap_async_query() function returns the result set from an SQL query that was previously sent with the MYSQLI_ASYNC flag.

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();
}

// 1. Send the query asynchronously (PHP continues working without waiting for the database)
mysqli_query($connection, "SELECT * FROM mysqli_table", MYSQLI_ASYNC);

// ... Here, the PHP code could perform other intensive operations ...

// 2. Now we "reap" the results when we actually need them
// NOTE: The mysqli_reap_async_query() function waits for the asynchronous query 
// to complete its task on the server, then captures and returns a standard 
// result set, just as if we had used a classic mysqli_query().
$result = mysqli_reap_async_query($connection);

if ($result) {
    while ($row = mysqli_fetch_row($result)) {
        // $row[0] is table_id, $row[1] is fruit
        printf("ID: %s, Content: %s<br>", $row[0], $row[1]);
    }
    mysqli_free_result($result);
}

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: When you send an asynchronous query, PHP does not stop. But when you finally need that data, you call this function to retrieve it from the network buffer. It is typically used inside a loop in combination with mysqli_poll().

Retrieves a result object from a non-blocking query.

Allows PHP to process data only when it is actually available.

Essential for completing the asynchronous database communication cycle.