Copyright 1997-2021 the PHP Documentation Group.
mysqli_result::fetch_object
mysqli_fetch_object
Returns the current row of a result set as an object
Description
Object oriented style
public object mysqli_result::fetch_object(string class_name= ="stdClass",
array params);
Procedural style
object mysqli_fetch_object(mysqli_result result,
string class_name= ="stdClass",
array params);
Returns the current row result set as an object where the attributes of the object represent the names of the fields found within the result set.
This function sets the properties of the object before calling the object constructor.
Field names returned by this function are case-sensitive.
This function sets NULL fields to
the PHP null
value.
Parameters
-
result
Procedural style only: A result set identifier returned by
mysqli_query
,mysqli_store_result
ormysqli_use_result
.-
class_name
The name of the class to instantiate, set the properties of and return. If not specified, a
stdClass
object is returned.-
params
An optional array of parameters to pass to the constructor for
class_name
objects.
Return Values
Returns an object that corresponds to the fetched row or
null
if there are no more rows in result
set.
Examples
Example 7.125 mysqli_result::fetch_object
example
Object oriented style
<?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 ($obj = $result->fetch_object()) {
printf("%s (%s)\n", $obj->Name, $obj->CountryCode);
}
Procedural style
<?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);
/* fetch associative array */
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)
See Also
mysqli_fetch_array
|
mysqli_fetch_assoc
|
mysqli_fetch_row
|
mysqli_query
|
mysqli_data_seek
|