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

33 votes126 views4 answers
Php switch
PHP
2 votes175 views2 answers
Create custom rule in laravel
PHP Laravel
0 vote131 views1 answer
Yii2 modules commands are not showing in console
PHP
47 votes183 views6 answers
Laravel create seeder
PHP
1 vote149 views1 answer
Laravel queue work schedule cpanel
PHP
2 votes138 views5 answers
Add key value array php
PHP
12 votes160 views5 answers
Array to object php
PHP
16 votes128 views6 answers
Laravel redirect back
PHP
3 votes138 views1 answer
Wordpress wp_head
PHP
11 votes154 views3 answers
Laravel log reader
PHP Laravel