SQL PHP HTML ASP JavaScript articles and free scripts to download
PHP PHP & Database Query

Displaying records in PHP from MySQL table

Displaying data from a table is a very common requirement and we can do this in various ways depending on the way it is required. We will start with a simple one to just display the records and then we will move to advance one like breaking the returned records to number of pages. We will start with simple displaying the records of this table.
id name class mark
1 John Deo Four 75
2 Max Ruin Three 85
3 Arnold Three 55
4 Krish Star Four 60
5 John Mike Four 60
6 Alex John Four 55
7 My John Rob Fifth 78

Before starting please ensure that you have connected to MySql database and also check the article on PHP MySQL query to know how to execute MySql queries by using PHP

Let us first start by storing the query in a variable and then executing it

$query="select * from student";  // query string stored in a variable
$rt=mysql_query($query);          // query executed 
echo mysql_error();                    // if any error is there that will be printed to the screen

Select Query to get records from database
We will use mysql_fetch_array function to get the array of records and then we will loop through it to display record by record. You can see our php array to lean how to use array in PHP.  The code below will print name , class and mark records and you can see we have used <br> tag to give one line break after each record. This can be formatted well to display inside a table.

while($nt=mysql_fetch_array($rt)){
echo "$nt[name] $nt[class] $nt[mark]<br>";     // name class and mark will be printed with one line break
}

Number of User Comments : 4


Google+
mariel16-02-2012
thank you...it works..
Simon22-02-2012
Thanks dude, this tutorial helped me a lot.
Atar25-05-2012
Hi
can you tell me how to insert date month and year combine in databese
Venedict Francisco07-09-2013
how can i post or display data information from the two different table?
Post Comment This is for short comments only. Use the forum for more discussions.
Name
Email( not to be displayed)Privacy Policy
1+2=This is to prevent automatic submission by spammers. Please enter the result of the sum as asked



HTML . MySQL. PHP. JavaScript. ASP. Photoshop. Articles. FORUM Contact us

©2000-2014 plus2net.com All rights reserved worldwide Privacy Policy Disclaimer