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

1 vote181 views2 answers
Php echo number with decimal
PHP
3 votes193 views5 answers
Php check if variable is int
PHP
9 votes193 views3 answers
Laravel download
PHP
0 vote212 views1 answer
Wordpress remove current post in sidebar php
PHP Wordpress
1 vote182 views1 answer
Count an array in php
PHP
0 vote184 views1 answer
Show woocommerce products in the form of table
PHP
39 votes241 views6 answers
Laravel foreign key constraint
PHP Laravel
11 votes210 views4 answers
Session variable in laravel
PHP Laravel
0 vote236 views4 answers
Wordpress get current taxonomy
PHP Wordpress
11 votes228 views6 answers
Laravel create resource
PHP Laravel