Create Table

Create a table named ‘user_info’. The table contains four fields:

• id – int(11) – primary key – auto increment
• first_name – varchar(100)
• last_name – varchar(100)
• gfg_username – varchar(100)

Your table structure should look like this:

Or you can create a table by copying and pasting the following code into the SQL panel of your PHPMyAdmin.

CREATE TABLE IF NOT EXISTS `user_info` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`first_name` varchar(100) NOT NULL,
`last_name` varchar(100) NOT NULL,
`gfg_username` varchar(100) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

To do this from the SQL panel refer to the following screenshot:

In this article, we will see how we can display the records by fetching them from the MySQL database using PHP. 

Approach: Make sure you have an XAMPP server or WAMP server installed on your machine. In this article, we will be using the XAMPP server.

XAMPP is a free and open-source cross-platform web server solution stack package developed by Apache which allows a web application to be easily tested on a local web server. Here, we can manually create a relational database and store data in tabular form by going to this link. But to operate on localhost or for storing data first we have to start Apache and MySQL from the XAMPP control panel. Let, for example, the database name is server, the table name is user_info having column names as ID, First Name, Username, and Password and we have to fetch the data stored there. So, below is the PHP program whose task is to fetch data. 

Follow the steps to fetch data from the Database using PHP: