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

5 votes136 views2 answers
Array prepend php
PHP
1 vote152 views1 answer
Laravel refresh server
PHP
0 vote120 views1 answer
Count files in folder php
PHP
2 votes147 views2 answers
Laravel valet 504 gateway time-out
PHP
16 votes140 views3 answers
Wp_debug
PHP
0 vote154 views2 answers
Laravel validation exact string length
PHP Laravel
3 votes126 views1 answer
Laravel check if array is empty
PHP
0 vote176 views2 answers
Php read big file line by line
PHP
8 votes144 views2 answers
Laravel drop multiple columns
PHP
0 vote143 views1 answer
GZIP COMPRESSION Using PHP
PHP