Display data from SQL database into php html table

Question

I want to display one of my SQL tables on an HTML or PHP table using a MySQL database. I looked online but was unable to use this option. Please, if you could, assist me with the coding.

database = 'hrmwaitrose'
username = 'root'
host = 'localhost'

There is no password. I want to show the information from the "employee" table.

Can someone please help me with this?

Answer 1

We echo in the while loop, which runs each time we come across a result row and adds a new table row. In order to house the fields, I also add a. It's a really simple template. Instead of utilizing MySQL connect, the other responses use mysqli connect. MySQL Improved is referred to as mySQLi. It provides a wider variety of features. It is also a little bit more complicated, as you can see. Depending on your needs, yes.

Please note that "mysql_fetch_array" is now deprecated since PHP 5.5.0, and it was removed in PHP 7.0.0. So please take a look in "mysqli_fetch_array()" instead.