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:

<?php  
// 假定数据库用户名：root，密码：123456，数据库：RUNOOB  
$con=mysqli_connect("localhost","root","123456","RUNOOB");  
if (mysqli_connect_errno($con))  
{  
    echo "连接 MySQL 失败: " . mysqli_connect_error();  
}  
$sql="SELECT name,url FROM websites ORDER BY alexa"; 
$result=mysqli_query($con,$sql); 
// 获取数据 
mysqli_fetch_all($result,MYSQLI_ASSOC); 
// 释放结果集 
mysqli_free_result($result); 
mysqli_close($con); 
?>

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!