Get a row from the result set as an associative array:
mysqli_fetch_assoc()
<?php // Assume database username: root, password: 123456, database: CODERCTO $con = mysqli_connect ( " localhost " , " root " , " 123456 " , " CODERCTO " ) ; if ( mysqli_connect_errno ( $con ) ) { echo " Failed to connect to MySQL: " . 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) " , $row [ " name " ] , $row [ " url " ] ) ; // Release the 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.
grammar
mysqli_fetch_assoc( result ) ;
| parameter | describe |
|---|
| 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 rows read. Returns NULL if there are no more rows in the result set. |
|---|
| PHP version: | 5+ |
|---|
