ExpertCodingMaster.Com: Mysql_fetch_assoc( ) function in Php

Just like mysql_fetch_row ( ) function mysql_fetch_assoc ( ) function is also used to fetch the data from database. there is no difference between these two function the resultant will be same in both the case. The only difference between these two function is, in mysql_fetch_row ( ) function we need to write the index value in the square braes to fetch the data and in mysql_fetch_assoc ( ) function actual mysql field name is written in the square braes to fetch the data.

Mysql_fetch_assoc ( )
To perform the fetch function at first we need to establish the connection with Php without this we cannot send and fetch data from MYSQL.

connection.php

<?php
@mysql_connect('localhost','root',' '); //password field is blank
@mysql_select_db('management');
?>

The above code establish the connection with Php and Mysql. Copy the above code in notepad and save as connection.php in a folder. To view more on connection.php click here

Creating Database and Table :-
Now open the PhpMyadmin using usermae as root and keep the password field blank and click on login. Now click on new located on left side and create a Database name it 'management'. Now create a table record under the management database.
Record Table

ID	NAME	EMAIL	ROOM_NUMBER
1	MUKESH SINGH	Mukeshinfo45@gmail.com	703
2	PRASHANT PASHAWAN	Prashant4u@gmail.com	305
3	RANJAN KUMAR	ranjan@gmail.com	102
4	ARPANA KUMARI	arpananupam@gmail.com	80
5	SOURAV GUPTA	sourav@gmail.com	600

SQL Query :-
The SQL query to fetch data from database
data.php

<?php
include_once('connection.php');
?>
<!DOCTYPE html>
<html>
<head><title>expertcodingmaster.com</title>
</head>
<body>
<div>
<?php
$query = mysql_query("select id,name,email from record");

$result = mysql_fetch_assoc($query);
echo "Id :- " . $result['id'] . "<br>";
echo "Name :- " . $result['name'] . "<br>";
echo "Email :- " . $result['email'] . "<br>";
echo "<hr>";
$result = mysql_fetch_assoc($query);
echo "Id :- " . $result['id'] . "<br>";
echo "Name :- " . $result['name'] . "<br>";
echo "Email :- " . $result['email'] . "<br>";
echo "<hr>";
/*
if you use the mysql_fetch_row then we have to write the index value as
$result = mysql_fetch_row($query);
echo "Id :- " . $result[0] . "<br>";
echo "Name :- " . $result[1] . "<br>";
echo "Email :- " . $result[2] . "<br>";
*/
?>
</div>
</body>
</html>

Copy the above code in notepad and save as data.php in the same folder where connection.php file has been saved. Now run the data.php file in the browser.

Since the connection code is written in different file so we need to include the connection.php file to use in data.php file. You can also write the connection code in the data.php file but it is not good practice to use the connection code in the user interface page. To write the connection code separately also has an advantage, that we no need to write the same connection code several time for the several fetch function in a single page. if you simply include the connection file written somewhere else further that you no need to write the connection code several time for the several fetch function.

Explanation :-
'$query' is a variable which store the SQL query and '$result ' is a variable which stores the data fetched from the SQL query. We can also perform the fetch function without using these variable. But using of variable makes the code shorter and easier we don't need to wright the same code again and again apart form that we just use the variable everywhere.

mysql_fetch_assoc ( ) function fetch all the data as an array to avoid the data conversion problem. This fetch function uses mysql actual field name to fetch the data. so in the above code the field name of id is 'id' and the field name of name is 'name' similarly the field name of email is 'email'.

Mysql_fetch_assoc ( ) function fetches single record at a time, if you have 10 records in your database then you have to write the fetch statement 10 times to display all the 10 records. In the above example i write the fetch function two time to fetch the two record. If you don't want to write the fetch statement several time you can use loop function. See below how to use the loop statement to display all the record in a single fetch statement.

Continue to
mysql_fetch_row( ) function
mysql_fetch_array( ) function
mysql_fetch_object( ) function

Mysql_fetch_assoc( ) function in Php

No comments: