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

12 votes170 views4 answers
Laravel get second last record
PHP Laravel
0 vote145 views2 answers
Collection get first element laravel
PHP
6 votes157 views2 answers
Php multiple line string
PHP
-3 votes165 views2 answers
How to set up alert messages in laravel 8
PHP Laravel
0 vote151 views1 answer
Dropdown in crud application YII
PHP
10 votes228 views3 answers
Php sum array elements
PHP
0 vote169 views1 answer
Laravel looping checking if last record has reached
PHP Laravel
0 vote178 views1 answer
PaymentIntent::create laravel
PHP Laravel
0 vote144 views1 answer
Lewin muzvonda
PHP
21 votes178 views6 answers
Laravel seeder update
PHP Laravel