Latest web development tutorials
 

PHP mysqli_fetch_object() Function

< PHP MySQLi Reference

Example

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");
// Check connection
if (mysqli_connect_errno())
  {
  echo "Failed to connect to MySQL: " . mysqli_connect_error();
  }

$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);
    }
  // Free result set
  mysqli_free_result($result);
}

mysqli_close($con);
?>

Definition and Usage

The 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

mysqli_fetch_object(result,classname,params);

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

< PHP MySQLi Reference