mysqli_fetch_row
(PHP 5, PHP 7, PHP 8)
mysqli_result::fetch_row -- mysqli_fetch_row — Fetch the next row of a result set as an enumerated array
Description
Object-oriented style
public mysqli_result::fetch_row():
array|null|false
mysqli_fetch_row(mysqli_result $result
): array|null|false
Note: This function sets NULL fields to the PHP null
value.
Return Values
Returns an enumerated array representing the fetched row, null
if there are no more rows in the result set, or false
on failure.
Examples
Example #1 mysqli_result::fetch_row() example
Object-oriented style
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 style
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]);
}
The above examples will output something similar to:
Pueblo (USA)
Arvada (USA)
Cape Coral (USA)
Green Bay (USA)
Santa Clara (USA)
See Also
- mysqli_fetch_array() - Fetch the next row of a result set as an associative, a numeric array, or both
- mysqli_fetch_assoc() - Fetch the next row of a result set as an associative array
- mysqli_fetch_column() - Fetch a single column from the next row of a result set
- mysqli_fetch_object() - Fetch the next row of a result set as an object
- mysqli_query() - Performs a query on the database
- mysqli_data_seek() -
Adjusts the result pointer to an arbitrary row in the result
Stephen ¶
15 years ago
It's worth noting that the MySQLi functions (and, I presume, the MySQL functions) fetch a string regardless of the MySQL data type. E.g. if you fetch a row with an integer column, the corresponding value for that column and row will still be stored as a string in the array returned by mysql_fetch_row.
sainthyoga2003 at gmail dot com ¶
8 years ago
Note that mysqli_fetch() is deprecated but still is in PHP function list. mysqli_fetch_row() is nowadays mysql procedural style used, but is not listed in PHP functions.
evangun2001 at yahoo dot
fr ¶
15 years ago
Remember that fetch() and fetch_row() are two different things, and differ in the way to use them.
- fetch() is used on a statement (like an executed prepared statement) and needs to be used in association with bind_result().
- fetch_row() is used on a result (like the result of query()).
As a consequence, if you want to use to use fetch_row() with an executed prepared statement, first you'll have to get the result out of this statement with mysqli_store_result() or mysqli_use_result().
maillist at pnpitalia.it ¶
18 years
ago
from "README.PHP4-TO-PHP5-THIN-CHANGES"
4. Be careful when porting from ext/mysql to ext/mysqli. The following
functions return NULL when no more data is available in the result set
(ext/mysql's functions return FALSE).
- mysqli_fetch_row()
- mysqli_fetch_array()
- mysqli_fetch_assoc()
Mysqli_fetch_array () untuk apa?
Fungsi mysql_fetch_array() merupakan salah satu fungsi yang banyak digunakan dalam proses pengambilan data MySQL. Fungsi ini akan menangkap data dari hasil perintah query dan membentuknya ke dalam array asosiatif dan array numerik.
Apa fungsi dari php MySQL?
PHP sering digunakan bersama dengan MySQL untuk membangun sebuah website yang dinamis. MySQL adalah sebuah sistem manajemen database yang akan mengakses dan memproses data.
Apa itu Fetch Assoc?
Fungsi fetch_assoc() / mysqli_fetch_assoc() digunakan untuk mengambil baris hasil sebagai array asosiatif. Catatan: Nama kolom yang dikembalikan dari fungsi ini peka huruf besar / kecil(Case-sensitive).
Apa itu ROW pada php?
$row adalah variabel yang akan menampung hasil fungsi mysql_fetch_row(). Hasil dari fungsi mysql_fetch_row() berupa tipe data array dengan key merujuk kepada kepada urutan kolom, dan value-nya (nilai dari array) adalah isi dari kolom tersebut.