mysqli_result::fetch_row
PHP function
Edit on GitHub ✎
(PHP 5, PHP 7, PHP 8)
Fetch the next row of a result set as an enumerated array
Description
Oop
mysqli_result::fetch_row(): array|null|false
Procedural
mysqli_fetch_row(mysqli_result $result): array|null|false
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.
Fetch-null
Parameters
Return Values
Returns an enumerated array representing the fetched row, null if there are no more rows in the result set, Falseforfailure.
Examples
mysqli_result::fetch_row example
Oop
php
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = new mysqli("localhost", "my_user", "my_password", "world");
$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
$result = $mysqli->query($query);
/* fetch object array */
while ($row = $result->fetch_row()) {
printf("%s (%s)\n", $row[0], $row[1]);
}Procedural
php
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$mysqli = mysqli_connect("localhost", "my_user", "my_password", "world");
$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
$result = mysqli_query($mysqli, $query);
/* fetch associative array */
while ($row = mysqli_fetch_row($result)) {
printf("%s (%s)\n", $row[0], $row[1]);
}Similar
output
Pueblo (USA)
Arvada (USA)
Cape Coral (USA)
Green Bay (USA)
Santa Clara (USA)