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 vote201 views1 answer
At C:\Users\Kamyar\web-pages\telebot\vendor\symfony\process\Pipes\WindowsPipes.php:63 laravel error
PHP Laravel
0 vote150 views1 answer
Laravel list get x amount in a collection
PHP
2 votes152 views1 answer
Create guid in php
PHP
0 vote183 views1 answer
Wordpress exclude current post from loop
PHP Wordpress
0 vote189 views1 answer
Run laravel localhost network
PHP Laravel
77 votes190 views6 answers
Php substr
PHP
0 vote158 views1 answer
Add action hook
PHP
4 votes156 views3 answers
Laravel migration index
PHP
7 votes176 views3 answers
One to many laravel
PHP Laravel
1 vote182 views1 answer
How can get url from $request in laravel
PHP