Showing database table in php

$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>" . $row['name'] . "</td><td>" . $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

Source: stackoverflow.com

Similar codes

25 votes196 views4 answers
ERROR 1071 (42000) at line 76: Specified key was too long; max key length is 767 bytes laravel
PHP
0 vote293 views3 answers
Get index number wordpress loop
PHP Wordpress
2 votes234 views2 answers
Wordpress theme The link you followed has expired.
PHP
0 vote225 views2 answers
Limit foreach loop laravel
PHP
3 votes233 views5 answers
Laravel permission
PHP
0 vote251 views1 answer
Laravel redis sentinel
PHP Laravel
0 vote226 views2 answers
Php numberformatter currency without symbol
PHP
0 vote270 views1 answer
Laravel check model column was changed
PHP Laravel
0 vote269 views1 answer
Eager load relationships on an existing model in route laravel
PHP Laravel
2 votes252 views1 answer
How to make a model in folder in laravel
PHP