php查询mysql显示在html表格中,将数据从SQL数据库显示到php / html表格中

OK I have a database on phpmyadmin (sql) and I want to display one of my tables into a table on HTML/PHP. I have searched online and can not implement this feature, so I'm wondering if someone could help me with the coding on this?

database = 'hrmwaitrose'

username = 'root'

host = 'localhost'

NO PW

I would like to display the data from table name employee

解决方案

You say you have a database on PhpMyAdmin, so you are using MySQL. 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 "

while($row = mysql_fetch_array($result)){ //Creates a loop to loop through results

echo "

" . $row['name'] . "" . $row['age'] . ""; //$row['index'] the index here is a field name

}

echo "

"; //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.