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

1 vote352 views1 answer
How to set a validation on a value if its not null in laravel php
PHP Laravel
0 vote307 views1 answer
Get all users created in a month laravel
PHP
0 vote319 views1 answer
Run a server php terminal
PHP
14 votes318 views1 answer
Php full form
PHP
1 vote342 views1 answer
Setup_postdata not working
PHP
2 votes307 views1 answer
Command to run php file on chrome
PHP
93 votes405 views3 answers
Add object in array php
PHP
9 votes321 views3 answers
Laravel enum migration example
PHP
0 vote358 views1 answer
Boot add schema in laravel
PHP
2 votes359 views1 answer
Php login google api
PHP