X
HOME HTML CSS JAVASCRIPT SQL PHP JQUERY ANGULAR XML ASP.NET MORE...
REFERENCES | EXAMPLES | FORUM | ABOUT

PHP mysqli_fetch_object() Function

PHP MySQLi Reference 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 PHP MySQLi Reference

Your suggestion:

Close [X]

Thank You For Helping Us!

Your message has been sent to W3Schools.

Close [X]
Search w3schools.com:

WEB HOSTING

UK Reseller Hosting

WEB BUILDING

Download XML Editor FREE Website BUILDER Free HTML5 Templates FREE Website Templates Free HTML Templates

SHARE THIS PAGE

facebook