PHP mysqli_fetch_assoc()Functions
Fetch a row from result set as an associative array:
mysqli_fetch_assoc()
//Assume database username: root, password: 123456, database: EXAMPLE
$con=mysqli_connect("localhost","root","123456","EXAMPLE");
if (mysqli_connect_errno($con))
{
echo "Connect MySQL failed:" . mysqli_connect_error();
}
$sql="SELECT name,url FROM websites ORDER BY alexa";
$result=mysqli_query($con,$sql);
//Associative array
$row=mysqli_fetch_assoc($result);
printf ("%s (%s)\n",$row["name"],$row["url"]);
//Free result set
mysqli_free_result($result);
mysqli_close($con);
Definition and Usage
The mysqli_fetch_assoc() function fetches a row from the result set as an associative array.
Note:The field names returned by this function are case-sensitive.
Syntax
mysqli_fetch_assoc(result);
| Parameters | Description |
|---|---|
| result | Required. Specifies the result set identifier returned by mysqli_query(), mysqli_store_result(), or mysqli_use_result(). |
Technical Details
| Return value: | Returns an associative array representing the fetched row. Returns NULL if there are no more rows in the result set. |
|---|---|
| PHP Version: | 5+ |
PHP MySQLi Reference Manual Other Extensions