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

3 votes100 views3 answers
Php best debugging functions
PHP
0 vote96 views1 answer
Cake php 2.x joins
PHP
8 votes222 views6 answers
Codeigniter 4 get last query
PHP CodeIgniter
107 votes268 views6 answers
Php get current date
PHP
5 votes101 views3 answers
Laravel eloquent duplicate record
PHP
4 votes106 views5 answers
Repeater acf
PHP
0 vote111 views2 answers
Check method in laravel
PHP
4 votes95 views2 answers
Php http authentication
PHP
0 vote112 views1 answer
Create fake users on click laravel
PHP
0 vote130 views1 answer
Function to fetch user details
PHP