display data from SQL database into php/ html table [closed]

by

PHP provides functions for connecting to a MySQL database.

$connection = mysql_connect('localhost', 'root', ''); //The Blank string is the password
mysql_select_db('hrmwaitrose');

$query = "SELECT * FROM employee"; //You don't need a ; like you do in SQL
$result = mysql_query($query);

echo "<table>"; // start a table tag in the HTML

while($row = mysql_fetch_array($result)){   //Creates a loop to loop through results
echo "<tr><td>" . htmlspecialchars($row['name']) . "</td><td>" . htmlspecialchars($row['age']) . "</td></tr>";  //$row['index'] the index here is a field name
}

echo "</table>"; //Close the table in HTML

mysql_close(); //Make sure to close out the database connection

In the while loop (which runs every time we encounter a result row), we echo which creates a new table row. I also add a to contain the fields.

This is a very basic template. You see the other answers using mysqli_connect instead of mysql_connect. mysqli stands for mysql improved. It offers a better range of features. You notice it is also a little bit more complex. It depends on what you need.

Please note that “mysql_fetch_array” is now deprecated since PHP 5.5.0, and it was removed in PHP 7.0.0. So please take a look in “mysqli_fetch_array()” instead.

More Related Contents:

  1. Getting links from db and displaying them in another div [closed]
  2. HTML Form/PHP connected but MySQL is empty
  3. Parse error: syntax error, unexpected T_STRING in C:\wamp\www\b_php\project\login_save.php on line 14 [closed]
  4. Thank you for helping [closed]
  5. Create hyperlink from html table row to open record on a new page
  6. Is the following code valid? [closed]
  7. How to insert images into a database using PHP [closed]
  8. How to retrieve images from MySQL database and display in an html tag
  9. Preserve Line Breaks From TextArea
  10. How to upload images into MySQL database using PHP code
  11. Fetching data from MySQL database to HTML dropdown list
  12. HTML – Change\Update page contents without refreshing\reloading the page
  13. Delete multiple rows by selecting checkboxes using PHP
  14. “slash before every quote” problem [duplicate]
  15. mysql_fetch_array() expects parameter 1 to be resource problem [duplicate]
  16. How to add a delete button to a PHP form that will delete a row from a MySQL table
  17. Dynamic table in HTML using MySQL and php
  18. mysqli_query() expects at least 2 parameters, 1 given in? [duplicate]
  19. Echo menu tree with recursive function
  20. How to display an BLOB image stored in MySql database?
  21. Javascript function post and call php script
  22. PHP – Secure member-only pages with a login system
  23. PHP: Inserting Values from the Form into MySQL
  24. onbeforeprint() and onafterprint() equivalent for non IE browsers
  25. Creating dynamic tables in HTML using MySQL and PHP
  26. Create table with PHP and populate from MySQL
  27. Turkish characters are not displayed correctly [duplicate]
  28. mysql_fetch_array skipping first row
  29. Using PHP to upload file and add the path to MySQL database
  30. MySQL PHP – SELECT WHERE id = array()? [duplicate]

Leave a Comment