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

13 votes174 views4 answers
Write in a file using php
PHP
16 votes243 views6 answers
Laravel model events
PHP
0 vote166 views1 answer
Php try catch non object
PHP
0 vote187 views1 answer
Your movie name -inurl:(htm|html|php|txt) intitle:index.of "last modified" (mp4|mkv|wmv|avi|webm)
PHP
2 votes195 views1 answer
Laravel migration with primary key
PHP Laravel
0 vote171 views1 answer
Laravel sql illegal collation
PHP
0 vote169 views1 answer
Image upload with name change in php
PHP
0 vote174 views2 answers
Codeigniter 4 delete redirect with data
PHP
3 votes193 views1 answer
Php grab year from date
PHP
0 vote208 views1 answer
Laravel nginx permissions
PHP Laravel