PHP mysqli_fetch_array() Function

Object oriented style

mixed mysqli_result::fetch_array ([ int $resulttype = MYSQLI_BOTH ] )

Procedural style

mixed mysqli_fetch_array ( mysqli_result $result [, int $resulttype = MYSQLI_BOTH ] )

The mysqli_fetch_array() function fetches a result row as an associative array, a numeric array, or both.

Returns an array that corresponds to the fetched row or NULL if there are no more rows for the resultset represented by the result parameter.mysqli_fetch_array() is an extended version of the mysqli_fetch_row() function. In addition to storing the data in the numeric indices of the result array, the mysqli_fetch_array() function can also store the data in associative indices, using the field names of the result set as keys.

Examples -

Object oriented style

Procedural style

The above examples will output:

Kabul (AFG) Qandahar (AFG) Herat (AFG)

ParameterDescription
resultProcedural style only: A result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result().
resulttypeThis optional parameter is a constant indicating what type of array should be produced from the current row data. The possible values for this parameter are the constants MYSQLI_ASSOC, MYSQLI_NUM, or MYSQLI_BOTH.By using the MYSQLI_ASSOC constant this function will behave identically to the mysqli_fetch_assoc(), while MYSQLI_NUM will behave identically to the mysqli_fetch_row() function. The final option MYSQLI_BOTH will create a single array with the attributes of both.

Return Values

Returns an array of strings that corresponds to the fetched row or NULL if there are no more rows in resultset.