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 vote289 views1 answer
Wordpress get archive title
PHP
0 vote310 views1 answer
Orderby total sales woocommerce
PHP
4 votes315 views2 answers
Php xml to array
PHP
1 vote262 views1 answer
Append single quote around variable in php string
PHP
1 vote303 views1 answer
Php explode trim
PHP
38 votes305 views2 answers
Controller Command
PHP
2 votes285 views1 answer
Remove phpmyadmin ubuntu 20.04 completely
PHP
1 vote296 views1 answer
Laravel failed jobs retry
PHP
35 votes277 views4 answers
First letter capital of every word in php
PHP
1 vote272 views2 answers
Get file name from url in php
PHP