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

3 votes232 views1 answer
Cannot use object of type App\ViewModels\Admin\Category\Category ViewModels as array (View: C:\OSPanel\domains\megaimkon.loc\resources\views\admin\category\index.blade.php)
PHP
2 votes238 views1 answer
Convert multidimensional array to single array php
PHP
2 votes201 views1 answer
Img upload in php
PHP
0 vote199 views1 answer
Send multiple db notification same function in laravel
PHP
3 votes201 views2 answers
How to add values to an array in laravel
PHP Laravel
62 votes541 views6 answers
Clear cache laravel
PHP Laravel
4 votes183 views6 answers
Class 'App\Http\Controllers\Artisan' not found
PHP
0 vote220 views1 answer
Laravel skip a loop if error
PHP Laravel
3 votes140 views1 answer
Laravel go back
PHP
0 vote264 views3 answers
Oop php
PHP