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 vote339 views2 answers
How to download file in laravel 8 delelete from directry
PHP
2 votes323 views1 answer
If language wpml
PHP
3 votes310 views3 answers
How to add hour minute seconds in php datetime
PHP
0 vote329 views1 answer
How to print image just on side where upload php
PHP
22 votes316 views6 answers
Php get url
PHP
8 votes307 views6 answers
Command not found: laravel
PHP
0 vote392 views1 answer
Check null in laravel blade
PHP Laravel
0 vote340 views1 answer
Php array_intersect_assoc
PHP
0 vote318 views1 answer
Laravel Secured Password
PHP
0 vote300 views1 answer
Php artisan tinker encription cmd
PHP