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
Description
Object-oriented style
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.
Note:
This function sets the properties
of the object before calling the object constructor.
Note: Field names returned by this function
are case-sensitive.
Note: This function sets NULL fields to
the PHP null value.
Return Values
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, or false on failure.
Errors/Exceptions
A ValueError is thrown when
the constructor_args is non-empty with the class not having constructor.
Examples
Example #1 mysqli_result::fetch_object() example
<?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)