The mysqli_store_result() Function

The mysqli_store_result() function transfers the complete result set from the last query executed via the mysqli_query() or mysqli_multi_query() function into local storage (memory).

Parameter	Type	Description
link	mysqli	A connection identifier returned by mysqli_connect().
mode	int	Optional. The mode of operation (MYSQLI_STORE_RESULT_COPY_DATA).

EXAMPLE

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

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

if (!$connection) {
    die("Connection failed: " . mysqli_connect_error());
}

// 1. Execute a regular query on the server
mysqli_query($connection, "SELECT * FROM users");

// 2. Transfer and store the entire result in PHP's local memory
// NOTE: mysqli_store_result() takes the row set that the MySQL server 
// has just prepared and stores it in the local buffer in a single chunk. Only after 
// this step will the mysqli_num_rows() function return the correct row count.
$result = mysqli_store_result($connection);

if ($result) {
    // 3. Retrieve and output the total number of locally stored rows
    $row_count = mysqli_num_rows($result);
    echo "Number of rows in the table: " . $row_count;

    // 4. Always free the local memory when finished
    mysqli_free_result($result);
}

mysqli_close($connection);
?>

RESULT

The result will be displayed here...

The function returns a result object or false if an error occurred.
The use of this function is mandatory after calling mysqli_multi_query() if we want to process the first result set.
Unlike mysqli_use_result(), this function immediately transfers all data from the server to the client.
When the results are no longer needed, we free the memory using mysqli_free_result().
It allows using the mysqli_data_seek() function to move freely through the rows.