Home >>MySQL Tutorial >Mysqli Fetch Assoc

Mysqli Fetch Assoc

Fetch data using mysqli_fetch_assoc( ) function

mysqli_fetch_assoc() return the rows from the number of records available in the database as an associative array.

at a time it return only the first row as an associative array. if we want to retrieve all the records of the table then we must put this function inside the while loop.

Syntax

 mysqli_fetch_assoc(data)

Display the records using mysqli_fetch_assoc( )

<?php
$con=mysqli_connect("localhost","root","","Employee") or die(mysqli_error());
//select values from empInfo table
$sql = "SELECT * from empInfo WHERE email='devesh@gmail.com'";
$result = mysqli_query($con,$sql);
print_r(mysqli_fetch_assoc($result));	
mysqli_close($con); 
?>

	Output : Array(
			[emp_id] =>1 
			[Name] => devesh
			[email] =>devesh@gmail.com
			[mobile] => 22
			)

In the above example first connection to the database is created after that the result provided by mysqli_query() is passed to mysqli_fetch_assoc() and the data of the associative array is displayed .

Display all records from empInfo table using mysqli_fetch_assoc( ) 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($r=mysqli_fetch_assoc($val))
{
echo $r['emp_id']." ".$r['name']." ".$r['email']." ".$r['mobile']."<br/>";
}				
?>

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_assoc() and array returned is stored in 'r' variable and it put in while loop to fetch all records . after that the data is displayed in tabular form.

« Previous Next »

MySQL Tutorial SQL Introduction MySQL Constraints MySQL Common Queries PHP MySQL Connectivity PHP Mysqli Database Connectivity PHP MySQL Create Database PHP Create MySQLi Database PHP MySQL Insert PHP MySQL Update PHP MySQL Delete PHP MySQL Select Mysqli Fetch Array Mysqli Fetch Assoc Mysqli fetch row Mysqli fetch object MySQL Where Clause MySQL Order By Select Insert Update Delete in Php How to create foreign key MySQL auto increment PHP MySQL Secure Registration Page PHP MySQL Secure Login Page MySQL Predefined Function MySQL Joins How to Export MySQL to CSV How to import csv into mysql How to edit radio button in PHP MySQL PHP MySQL Pagination Upload and Display Video in PHP Building a bar chart How to update Radio button, Checkbox and dropdown Create Registration form PHP MySQL How to insert data from textarea to database PHP PHP PDO

No Sidebar ads