fetch-row
mysqli_result::fetch_row
mysqli_fetch_row
Fetch the next row of a result set as an enumerated array
ENTITY
ENTITY
public
array
null
false
mysqli_result::fetch_row
ENTITY
array
null
false
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 ENTITY if there are no more rows.
ENTITY
ENTITY
ENTITY
Returns an enumerated array representing the fetched row, ENTITY if there are no more rows in the result set, ENTITY.
ENTITY
mysqli_result::fetch_row example
ENTITY
<?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]);
}
ENTITY
<?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]);
}
ENTITY
Pueblo (USA)
Arvada (USA)
Cape Coral (USA)
Green Bay (USA)
Santa Clara (USA)
ENTITY
mysqli_fetch_array, mysqli_fetch_assoc, mysqli_fetch_column, mysqli_fetch_object, mysqli_query, mysqli_data_seek
谢谢你的反馈！