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 vote131 views1 answer
Laravel validation rules for video upload
PHP Laravel
0 vote118 views1 answer
Optimistic Locking Laravel
PHP
0 vote106 views1 answer
Php print number
PHP
26 votes169 views6 answers
Carbon in laravel
PHP Laravel
0 vote110 views1 answer
Min function in php
PHP
0 vote139 views1 answer
File: C:\xampp\htdocs\marvellogistik\application\libraries\Profiler.php Line: 386 Function: sendDataInHeaders
PHP
0 vote127 views4 answers
Installing bootstrap ui in laravel app
PHP
0 vote110 views1 answer
CURL error 60 : SSL certificate in Larvel in pusher or facebook authentication
PHP
1 vote106 views1 answer
Trim laravel
PHP Laravel
0 vote217 views1 answer
Drupal 9 entity.repository load entity by UUID
PHP Drupal