Home >>MySQL Tutorial >Mysqli fetch object

Mysqli fetch object

Fetch data using mysqli_fetch_object( ) function

The mysqli_fetch_object() function returns a row from a recordset as an object.

mysqli_fetch_object() return the rows from the number of records available in the database as an object. at a time it return only the first row as an object. if we want to retrieve all the records of the table then we must put this function inside the while loop.

Syntax
mysqli_fetch_object(data) 

Display the records using mysqli_fetch_object()

<?php
//connect database 
$con=mysqli_connect("localhost","root","","Employee") or die(mysqli_error());	
//select table 
$sql = "SELECT * from empInfo WHERE email='devesh@gmail.com'";
$result = mysqli_query($con,$sql);
$row=mysqli_fetch_object($result);
echo $row->name;
mysqli_close($con);
?>
Output : Devesh 
In the above example first connection to the database is created after that the result provided by mysqli_query() is passed to mysqli_fetch_object() and object returned is stored in row variable. the data of the object is displayed .

Retrieve all records from empInfo table using mysqli_fetch_object( ) function.

 <?php
//connect database 
$con=mysqli_connect("localhost","root","","Employee") or die(mysqli_error());
//select all values from empInfo table
$data="SELECT * FROM empInfo";
$val=mysqli_query($con,$data);			
while($row=mysqli_fetch_object($val))
{
echo $row->emp_id." ".$row->name." ".$row->email." ".$row->mobile."<br/>";
}		
mysqli_close($con);	
?>
Output :
Emp_id Name Email Mobile
1 devesh devesh@gmail.com 9910099100
2 deepak deepak@gmail.com 9210053520
3 ravi ravi@gmail.com 9810098100
In the above example first connection to the database is created after that the result provided by mysqli_query() is passed to mysqli_fetch_object() and object returned is stored in row variable and it put in while loop to fetch all records . after that the data is displayed in tabular form.

Popular Tutorials