PHP mysqli fetch_object() Function

Example - Object Oriented style

Return the current row of a result set, then print each field's value:

<?php
$mysqli = new mysqli("localhost","my_user","my_password","my_db");

if ($mysqli -> connect_errno) {
echo "Failed to connect to MySQL: " . $mysqli -> connect_error;
exit();
}

$sql = "SELECT Lastname, Age FROM Persons ORDER BY Lastname";

if ($result = $mysqli -> query($sql)) {
while ($obj = $result -> fetch_object()) {
printf("%s (%s)\n", $obj->Lastname, $obj->Age);
}
$result -> free_result();
}

$mysqli -> close();
?>

Look at example of procedural style at the bottom.

Definition and Usage

The fetch_object() / mysqli_fetch_object() function returns the current row of a result-set, as an object.

Note: Fieldnames returned from this function are case-sensitive.

Syntax

Object oriented style:

$mysqli_result -> fetch_object(classname, params)

Procedural style:

mysqli_fetch_object(result, classname, params)

Parameter Values

Parameter	Description
result	Required. Specifies a result set identifier returned by mysqli_query(), mysqli_store_result() or mysqli_use_result()
classname	Optional. Specifies the name of the class to instantiate, set the properties of, and return
params	Optional. Specifies an array of parameters to pass to the constructor for classname objects

Technical Details

Return Value:	Returns an object with string properties for the fetched row. NULL if there are no more rows in the result set
PHP Version:	5+
Changelog:	The ability to return as a different object was added in PHP 5.0.0

Example - Procedural style

Return the current row of a result set, then print each field's value:

<?php
$con = mysqli_connect("localhost","my_user","my_password","my_db");

if (mysqli_connect_errno()) {
echo "Failed to connect to MySQL: " . mysqli_connect_error();
exit();
}

$sql = "SELECT Lastname, Age FROM Persons ORDER BY Lastname";

if ($result = mysqli_query($con, $sql)) {
while ($obj = mysqli_fetch_object($result)) {
printf("%s (%s)\n", $obj->Lastname, $obj->Age);
}
mysqli_free_result($result);
}

mysqli_close($con);
?>

❮ PHP MySQLi Reference