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 vote184 views1 answer
How to display custom field in wordpress?
PHP
0 vote179 views1 answer
$query->free_result();
PHP
0 vote220 views1 answer
Count object php
PHP
0 vote172 views2 answers
Xml to object php
PHP
36 votes205 views3 answers
Run seeder command in laravel
PHP
0 vote187 views1 answer
Readfile in php
PHP
6 votes209 views1 answer
Qual é a melhor linguagem de
PHP
0 vote179 views1 answer
Php write to standard out
PHP
-2 votes250 views1 answer
Codeigniter select for update
PHP CodeIgniter
4 votes197 views2 answers
Get permalink by id wordpress
PHP Wordpress