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 votes134 views1 answer
Laravel web.php auth Undefined type 'Auth'.
PHP Laravel
0 vote100 views1 answer
Php get myme type of image
PHP
-2 votes102 views1 answer
Magento 2.3 check if customer is logged in
PHP
1 vote101 views1 answer
User-agent cURL php
PHP
0 vote73 views1 answer
Laravel 2 queries similar reuse code
PHP
2 votes147 views1 answer
Laravel get only relationship
PHP Laravel
0 vote106 views1 answer
Php postgresql number of rows
PHP
0 vote144 views1 answer
Create symfony demo app
PHP Symfony
43 votes116 views3 answers
How to check php string length
PHP
1 vote137 views1 answer
String to uppercase laravel
PHP Laravel