How to use php mysqli_fetch_all function

php The mysqli_fetch_all function is used to obtain all rows from the result set as an associative array, a numeric array, or both. The syntax is mysqli_fetch_all(result,resulttype), and the parameter result is required.

php How to use the mysqli_fetch_all function?

Definition and Usage

mysqli_fetch_all() function fetches all rows from the result set as an associative array, a numeric array, or both.

Note:

This function is only available with the MySQL Native Driver.

Syntax

mysqli_fetch_all(result,resulttype);

Parameters

result Required. Specifies the result set identifier returned by mysqli_query(), mysqli_store_result(), or mysqli_use_result().

resulttype Optional. Specifies what type of array should be produced. Can be one of the following values:

MYSQLI_ASSOC
MYSQLI_NUM
MYSQLI_BOTH

Return value: Returns an associative array or numeric array containing the result rows.

PHP Version: 5.3

Example

Get all rows from the result set as an associative array:

The above is the detailed content of How to use php mysqli_fetch_all function. For more information, please follow other related articles on the PHP Chinese website!