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 vote139 views1 answer
Drupal 7 hook_form_alter
PHP
0 vote133 views1 answer
Access denied for user 'accessor access'@'localhost' (using password: NO) cpanel laravel
PHP Laravel
-1 vote154 views1 answer
How to know the path of php in linux
PHP
0 vote131 views1 answer
@lang laravel blade
PHP
2 votes213 views3 answers
Laravel get query result as array
PHP Laravel
1 vote116 views2 answers
How set field after another field in migration in laravel
PHP
19 votes127 views2 answers
How to get ip address of client using php
PHP
0 vote127 views1 answer
Passing parameters with route keyword in blade laravel
PHP Laravel
15 votes124 views4 answers
Remove space from start and end of string in php
PHP
0 vote146 views1 answer
Morph laravel without classes name
PHP Laravel