PHP - Function MySQLi Fetch Object

Syntax

mysqli_fetch_object(result,classname,params);

Definition and Usage

It returns the current row of a result set, as an object.

Return Values

It returns string properties for the fetched row or NULL if there are no more rows in the result set

Parameters

Example

Try out the following example

<?php
   $connection_mysql = mysqli_connect("localhost","user","password","db");
   
   if (mysqli_connect_errno($connection_mysql)){
      echo "Failed to connect to MySQL: " . mysqli_connect_error();
   }
   
   $sql = "SELECT name FROM emp";
   
   if ($result = mysqli_query($connection_mysql,$sql)){
      while ($obj = mysqli_fetch_object($result)){
         print $obj->name;
         print "\n";
      }
      mysqli_free_result($result);
   }
   mysqli_close($connection_mysql);
?>