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 vote391 views1 answer
Wordpress if is not page template
PHP Wordpress
0 vote285 views1 answer
Laravel migrate if not exists
PHP
0 vote329 views2 answers
Laravel has one through relationship
PHP
24 votes354 views3 answers
Upppercase php
PHP
1 vote325 views2 answers
Laravel middleware in constructor
PHP
0 vote383 views1 answer
Updating a row from databse using php
PHP
1 vote315 views1 answer
Cakephp 404 exception
PHP
0 vote324 views2 answers
Php artisan tinker send email
PHP
0 vote259 views1 answer
Php warning: php startup: unable to load dynamic library 'bz2' (tried: \xampp\php\ext\bz2 (the specified module could not be found), \xampp\php\ext\php_bz2.dll (the specified module could not be found)) in unknown on line 0
PHP
6 votes311 views1 answer
Php replace return character
PHP