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

1 vote156 views1 answer
Laravel @canany
PHP
0 vote191 views1 answer
Laravel form validation based on another field value
PHP Laravel
2 votes154 views2 answers
Update kali
PHP
0 vote158 views1 answer
Wordpress ftp functions.php
PHP
1 vote115 views1 answer
Url contains words in laravel
PHP
1 vote199 views2 answers
Laravel sail alias
PHP
0 vote226 views1 answer
Spatie sluggable not working
PHP
6 votes229 views4 answers
Illuminate database queryexception could not find driver laravel
PHP Laravel
0 vote320 views4 answers
Get_adjacent_post wordpress
PHP Wordpress
1 vote174 views2 answers
Php keep only letters and numbers
PHP