ExpertCodingMaster.Com: How to display data from database in Php

To display data from database Php has four inbuilt function
1) mysql_fetch_row( )
2) mysql_fetch_assoc( )
3) mysql_fetch_array( )
4) mysql_fetch_object( )

Here i will show you all the four fetch function one by one. Starting with the first fetch function

Mysql_fetch_row ( )
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 and name it 'management'. Now create a table record under the management database.
Record Table

ID	NAME	EMAIL	ROOM NO.
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,room_number from record");

$result = mysql_fetch_row($query);
echo "Id :- " . $result[0] . "<br>";
echo "Name :- " . $result[1] . "<br>";
echo "Email :- " . $result[2] . "<br>";
echo "<hr>";
$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_row ( ) function fetch all the data as an array to avoid the data conversion problem. This fetch function uses mysql field index value to fetch the data. An index number is a numeric value starts with zero ( 0 ) by default so in the above code the index value of id field is zero ( 0 ) and the index value of name field in 1 similarly the index value of email field is 2 and so on.

Mysql_fetch_row ( ) 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 have written 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.

<?php
include_once('connection.php');
?>
<!DOCTYPE html>
<html>
<head><title>expertcodingmaster.com</title>
</head>
<body>
<div>
<?php
$query = mysql_query("select id,name,email,room_number from record");
while($result = mysql_fetch_row($query))
{
echo "Id :- " . $result[0] . "<br>";
echo "Name :- " . $result[1] . "<br>";
echo "Email :- " . $result[2] . "<br>";
echo "<hr>";
}
?>
</div>
</body>
</html>

Continue to
2) mysql_fetch_assoc( )
3) mysql_fetch_array( )
4) mysql_fetch_object( )

How to display data from database in Php

No comments: