PHP MySQLi mysqli_fetch_all() - Fetching All Data

mysqli_fetch_all()

The mysqli_fetch_all() function fetches all result rows and returns them as one large array.

EXAMPLE

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

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

$query = "SELECT fruit FROM mysqli_table";
$result = mysqli_query($connection, $query);

// Retrieve all rows at once as an associative array
// NOTE: Unlike the mysqli_fetch_assoc() function, which takes 
// only one row at a time (and requires a while loop), the 
// mysqli_fetch_all() function pulls ALL rows from the result 
// into a single multidimensional array at once.
$list = mysqli_fetch_all($result, MYSQLI_ASSOC);

echo "<pre>";
print_r($list); echo "<br>";
echo "</pre>";

mysqli_free_result($result);
mysqli_close($connection);
?>

RESULT

The result will be displayed here...

Practical use: This function is very convenient when you want to "grab" all the data at once and process it later in PHP. Instead of using a while loop, you get everything in a single step. Test it at home like this:

It returns the entire result set as a multidimensional array.

You can use the second parameter (e.g., MYSQLI_ASSOC) to get associative keys with column names.

Be careful with large amounts of data, as it can consume a lot of memory.