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

0 vote354 views1 answer
Laravel dompdf barcode
PHP Laravel
1 vote266 views1 answer
Laravel pluck multiple columns
PHP Laravel
0 vote321 views1 answer
Setup cron on macos for laravel
PHP Laravel
0 vote337 views1 answer
Wordpress change post format
PHP Wordpress
0 vote299 views1 answer
Laravel Http client retry request if fail
PHP
4 votes300 views1 answer
Php artisan make:auth Command "make:auth" is not defined.
PHP
0 vote335 views5 answers
Laravel tricks and tips
PHP Laravel
0 vote277 views1 answer
Laravel get all users except role spatie
PHP
0 vote294 views2 answers
PHP $argv echo with number of words
PHP
0 vote313 views1 answer
Php pass function as callback
PHP