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 vote235 views1 answer
Nano seed generator
PHP
-1 vote350 views1 answer
Validate rule if row exist laravel
PHP Laravel
0 vote248 views1 answer
Put the date from new york with php
PHP
0 vote211 views1 answer
Install php 5.5.9 ubuntu 18.04
PHP
19 votes251 views5 answers
Php artisan auth in laravel 8
PHP
7 votes397 views3 answers
How to create wordpress shortcodes
PHP Wordpress
0 vote287 views1 answer
Laravel 8 date difference in days
PHP
1 vote249 views2 answers
Transform unix timestamp in date
PHP
0 vote249 views1 answer
How to pass value in app.blade
PHP
0 vote255 views1 answer
Error log php array
PHP