How fetch data from database in php and display in another page?

In this post, you will learn how to fetch data from the database in PHP programming language and display it in an HTML web page.

Data is one of the most important assets for any business. It is a significant resource in any organization, and for certain organizations, it is one of the main resources. The manner in which you store your information assumes a significant function in its simple entry, use, and security. Digitizing data storage permits you to store large volumes of data in less space than paper would occupy.

To add, access, and perform operations on data, we need a database management system. MySQL is the most popular and widely used Open Source Relational Database Management System.

Database

Suppose we have the following 'employee' table. Execute the following query to create the employee table in your MySQL database-

CREATE TABLE IF NOT EXISTS `employee` [
  `id` int[11] NOT NULL AUTO_INCREMENT,
  `emp_name` varchar[150] NOT NULL,
  `email` varchar[150] NOT NULL,
  `phone` varchar[100] NOT NULL,
  `created_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY [`id`]
] ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;

INSERT INTO `employee` [`id`, `emp_name`, `email`, `phone`, `created_date`] VALUES
[1, 'John', This email address is being protected from spambots. You need JavaScript enabled to view it.', '2323234543', '2019-06-05 15:36:07'],
[3, 'Priska', This email address is being protected from spambots. You need JavaScript enabled to view it.', '9393452387', '2019-05-28 15:36:07'],
[7, 'Alaya', This email address is being protected from spambots. You need JavaScript enabled to view it.', '3290349906', '2019-03-02 11:16:07'],
[8, 'Carle', This email address is being protected from spambots. You need JavaScript enabled to view it.', '9059098968', '2019-06-01 10:06:07'],
[9, 'Amma', This email address is being protected from spambots. You need JavaScript enabled to view it.', '6750390948', '2019-04-05 16:30:07'];

PHP Create Database Connection

Before we can get data into the MySQL database, we need to be able to connect to the server. The given PHP code makes a MySQL database connection. When we fetch, insert, update or delete data from the MySQL database, we will include this file there. Make sure to replace the database credentials and name.

config.php