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

2 votes179 views3 answers
Name of today php
PHP
0 vote187 views1 answer
Laravel Eloquent, group by month/year
PHP Laravel
2 votes162 views2 answers
404 page in laravel
PHP
1 vote191 views1 answer
How login with phone in laravel
PHP
0 vote164 views1 answer
How to get a list of registered route paths in Laravel?
PHP Laravel
12 votes184 views5 answers
Php get first 10 elements of array
PHP
23 votes234 views4 answers
Laravel change foreign key name
PHP Laravel
0 vote206 views3 answers
Laravel remove duplicates from array
PHP
0 vote213 views1 answer
Laravel check if relationship has data
PHP Laravel
0 vote178 views1 answer
Wordpress wpdb delete
PHP