Get a row from the result set as a numeric array or associative array:
mysqli_fetch_array()
<?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 ) ; // numeric array $row = mysqli_fetch_array ( $result , MYSQLI_NUM ) ; printf ( " %s : %s " , $row [ 0 ] , $row [ 1 ] ) ; // Associative array $row = mysqli_fetch_array ( $result , MYSQLI_ASSOC ) ; printf ( " %s : %s " , $row [ " name " ] , $row [ " url " ] ) ; // Release the result set mysqli_free_result ( $result ) ; mysqli_close ( $con ) ; ?> Definition and usage
The mysqli_fetch_array() function fetches a row from the result set as an associative array, a numeric array, or both.
Note: The field names returned by this function are case-sensitive.
grammar
mysqli_fetch_array( result,resulttype ) ;
| parameter | describe |
|---|
| 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 |
technical details
| Return value: | Returns an array of strings matching the read lines. Returns NULL if there are no more rows in the result set. |
|---|
| PHP version: | 5+ |
|---|
