(PHP 5 >= 5.3.0, PHP 7)
mysqli_result::fetch_all -- mysqli_fetch_all — Fetches all result rows as an associative array, a numeric array, or both
Object oriented style
$resulttype= MYSQLI_NUM ] )
mysqli_fetch_all() fetches all result rows and returns the result set as an associative array, a numeric array, or both.
This optional parameter is a constant indicating what type of array
should be produced from the current row data. The possible values for
this parameter are the constants
Returns an array of associative or numeric arrays holding result rows.
Available only with mysqlnd.
As mysqli_fetch_all() returns all the rows as an array in a single step, it may consume more memory than some similar functions such as mysqli_fetch_array(), which only returns one row at a time from the result set. Further, if you need to iterate over the result set, you will need a looping construct that will further impact performance. For these reasons mysqli_fetch_all() should only be used in those situations where the fetched result set will be sent to another layer for processing.