Display data from MySQL with PHP
Editor’s note: To display the data from MySQL database with PHP, we have to use the mysql_query( ) function to run a SQL query, here is a sample I have made to display all data from a table with 2 fields.
First we have to connect to database.
mysql_connect("Host Name", "User Name", "User Password") or die("Connection Failed"); mysql_select_db("DataBase Name")or die("Connection Failed");
Now we create the query for getting all the records from the table “table1″ and we use a PHP variable to store the SQL query.
$query = "SELECT * FROM table1";
Now we run the query and we use a PHP variable to store the result of the SQL query.
$result = mysql_query($query);
We now use a while loop to go through the record 1 by 1 and keep doing so until the the result does not match the criteria of the query
while ($line = mysql_fetch_assoc($result)) {
Print out the data of field1 which matches the criteria of the query:
echo $line['field1'];
Print out the data of field2 which matches the criteria of the query:
echo $line['field2'];
Give a line feed after print out each record just to make it nicely displays.
echo "<br>\n"; }
All together we have:
<?php mysql_connect("Host Name", "User Name", "User Password") or die("Connection Failed"); mysql_select_db("DataBase Name")or die("Connection Failed"); $query = "SELECT * FROM table1"; $result = mysql_query($query); while ($line = mysql_fetch_assoc($result)) { echo $line['field1']; echo $line['field2']; echo "<br>\n"; } ?>
Similar Posts:
- Display data from MySQL database with HTML form and PHP
- Display all field (column) names of a table in MySQL database
- Merging 2 MySQL tables with PHP – update one table’s field with another table’s field data (both table have one common field)
- Copy one table’s field records into another table’s field in MySQL database with PHP
- Find the number of column (field) of a table in MySQL database
