PHP mysqli_fetch_all()Functions
Examples
Fetch all rows from the result set as an associative array:
<?php
// Assume database username: root, password: 123456, database: EXAMPLE
$con=mysqli_connect("localhost","root","123456","EXAMPLE");
if (mysqli_connect_errno($con))
{
echo "Connection to MySQL failed: ". mysqli_connect_error();
}
$sql="SELECT name,url FROM websites ORDER BY alexa";
$result=mysqli_query($con,$sql);
// Fetch data
mysqli_fetch_all($result,MYSQLI_ASSOC);
// Free the result set
mysqli_free_result($result);
mysqli_close($con);
?>
// Assume database username: root, password: 123456, database: EXAMPLE
$con=mysqli_connect("localhost","root","123456","EXAMPLE");
if (mysqli_connect_errno($con))
{
echo "Connection to MySQL failed: ". mysqli_connect_error();
}
$sql="SELECT name,url FROM websites ORDER BY alexa";
$result=mysqli_query($con,$sql);
// Fetch data
mysqli_fetch_all($result,MYSQLI_ASSOC);
// Free the result set
mysqli_free_result($result);
mysqli_close($con);
?>
Definition and Usage
The 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 when MySQL Native Driver is installed.
Syntax
mysqli_fetch_all(result,resulttype);
| Parameters | Description |
|---|---|
| result | Required. Specifies the result set identifier returned by mysqli_query(), mysqli_store_result(), or mysqli_use_result(). |
| resulttype | Optional. Specifies which type of array should be produced. Can be one of the following values:
|
Technical Details
| Return value: | Returns an associative array or numeric array containing the result rows. |
|---|---|
| PHP version: | 5.3+ |
PHP MySQLi Reference Manual Other Extensions