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 vote203 views1 answer
Laravel ID Generator
PHP Laravel
16 votes204 views1 answer
Php reload current page
PHP
2 votes226 views4 answers
Laravel redirect action
PHP
0 vote216 views1 answer
Laravel vue csrf
PHP Laravel
0 vote173 views1 answer
Php artisan spark not working in codeigniter
PHP
0 vote186 views1 answer
Laravel count distance lat/longtidue
PHP
3 votes198 views6 answers
Laravel find query
PHP Laravel
3 votes186 views2 answers
Laravel longblob migration
PHP
1 vote188 views5 answers
Variables in php
PHP
15 votes213 views2 answers
Error: Cannot find module 'webpack/lib/rules/DescriptionDataMatcherRulePlugin
PHP