PHP mysqli_fetch_row() Function

Object oriented style

mixed mysqli_result::fetch_row ( void )

Procedural style

mixed mysqli_fetch_row ( mysqli_result $result )

Fetches one row of data from the result set and returns it as an enumerated array, where each column is stored in an array offset starting from 0 (zero). Each subsequent call to this function will return the next row within the result set, or NULL if there are no more rows.The mysqli_fetch_row() function fetches one row from a result-set and returns it as an enumerated array.

Examples -

Object oriented style

Procedural style

The above examples will output:

Pueblo (USA) Arvada (USA) Cape Coral (USA) Green Bay (USA) Santa Clara (USA)

ParameterDescription
resultProcedural style only: A result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result().

mysqli_fetch_row() returns an array of strings that corresponds to the fetched row or NULL if there are no more rows in result set.