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 vote261 views1 answer
My laravel has no docker-composer.yml file
PHP Laravel
0 vote230 views1 answer
How to make custom validator in laravel
PHP
0 vote231 views1 answer
Get the number of affected rows in php using pdo update statement
PHP
0 vote205 views2 answers
Laravel model column default value
PHP
1 vote228 views1 answer
Select selected fields in laravel join
PHP
0 vote260 views4 answers
Date format change in laravel blade
PHP
1 vote254 views2 answers
How to get data from a table in laravel
PHP Laravel
0 vote256 views1 answer
Laravel simplexmlelement not found
PHP Laravel
1 vote267 views3 answers
Laravel function to check if image exist or not
PHP
0 vote247 views1 answer
File form validation codeigniter
PHP CodeIgniter