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

5 votes299 views3 answers
Drop column table in migration if exist in laravel
PHP Laravel
4 votes307 views2 answers
Laravel sum group by
PHP Laravel
7 votes284 views3 answers
Php base64
PHP
0 vote279 views1 answer
Insert array
PHP
0 vote308 views1 answer
Show all laravel valet folders
PHP Laravel
0 vote265 views2 answers
Update pdo mysql php
PHP
3 votes272 views4 answers
Mac os change the php verison
PHP
2 votes266 views1 answer
Two digits after decimal point in php
PHP
2 votes262 views2 answers
Laravel get file in public folder
PHP
20 votes273 views3 answers
Make specific migration laravel
PHP