mysqli_result::fetch_object
mysqli_fetch_object
(PHP 5, PHP 7, PHP 8)
mysqli_result::fetch_object -- mysqli_fetch_object — Fetch the next row of a result set as an object
Descrizione
Stile orientato agli oggetti
If two or more columns of the result have the same name, the last
column will take precedence and overwrite any previous data. To
access multiple columns with the same name,
mysqli_fetch_row() may be used to fetch the numerically
indexed array, or aliases may be used in the SQL query select list to give
columns different names.
Nota:
This function sets the properties
of the object before calling the object constructor.
Nota: I nomi dei campi
restituiti da questa funzione sono
case-sensitive.
Nota: Questa funzione imposta i campio NULL al
valore PHP null.
Elenco dei parametri
resultSolo nello stile procedurale: un identificatore
di resultset restituito da mysqli_query(), mysqli_store_result()
o mysqli_use_result().
class
-
The name of the class to instantiate, set the properties of and return.
If not specified, a stdClass object is returned.
constructor_args
-
An optional array of parameters to pass to the constructor
for class objects.
Valori restituiti
Returns an object representing the fetched row, where each property
represents the name of the result set's column, null if there
are no more rows in the result set, o false in caso di fallimento.
Errori/Eccezioni
A ValueError is thrown when
the constructor_args is non-empty with the class not having constructor.
Esempi
Example #1 mysqli_result::fetch_object() example
Stile orientato agli oggetti
<?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);
while ($obj = $result->fetch_object()) {
printf("%s (%s)\n", $obj->Name, $obj->CountryCode);
}
<?php
mysqli_report(MYSQLI_REPORT_ERROR | MYSQLI_REPORT_STRICT);
$link = mysqli_connect("localhost", "my_user", "my_password", "world");
$query = "SELECT Name, CountryCode FROM City ORDER BY ID DESC";
$result = mysqli_query($link, $query);
while ($obj = mysqli_fetch_object($result)) {
printf("%s (%s)\n", $obj->Name, $obj->CountryCode);
}
The above examples will output
something similar to:
Pueblo (USA)
Arvada (USA)
Cape Coral (USA)
Green Bay (USA)
Santa Clara (USA)