How to retrieve data from database in php

Question

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.

Table of Contents Show

PHP Create Database Connection
Retrieve Data From Database
PHP code to display data in HTML Table
Related Articles
How do you retrieve data from a database?
How fetch data from database in PHP and display in table?
How can we fetch data from database in PHP and display in HTML?
How fetch data from database in PHP and display in Div?

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

<?php
$servername = "localhost";
$username = "root";
$password = "";
$database = "company";

$conn = new mysqli($servername , $username, $password', $database);

//Check for connection error
if($conn->connect_error){
  die("Error in DB connection: ".$conn->connect_errno." : ".$conn->connect_error);    
}
?>

Retrieve Data From Database

The given MySQL statement fetches data from the database.

$select = "SELECT * FROM employee WHERE is_enabled = '1'";
$result = $conn->query($select);

PHP code to display data in HTML Table

Here is the complete code to fetch data from the database and display it in the HTML table.

<?php 

// Include configuration file  
require ('config.php');
 
//Select query 
$select = "SELECT * FROM employee";
$result = $conn->query($select);
?> 

<!DOCTYPE html> 
<html lang="en"> 
<head> 
    <meta charset="UTF-8"> 
    <title>Employee Details</title> 
	
	<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css" >
</head> 
<body> 
    <div class="container">
		<table class="table">
			<thead class="thead-light">
			<tr>
			  <th scope="col">Emp Name</th>
			  <th scope="col">Email</th>
			  <th scope="col">Phone</th>
			</tr>
			</thead>
			<tbody>
                         
                        <?php   
			// Loop the employee data
				echo '<table class="table table-bordered">';
				while($row = $result->fetch_object()){
					echo '<tr>'
						.'<td>'.$row->emp_name.'</td>'
						.'<td>'.$row->email.'</td>'
						.'<td>'.$row->phone.'</td>'
						.'</tr>';
				}
				echo '</table>';
                        ?> 
			</tbody> 
        </table> 
    </div> 
</body> 
</html>

Output of the above code-

How do you retrieve data from a database?

Fetch data from a database.

Start by creating a new app..

Add a Screen to your app. ... .

Add data sources to your app by referencing some Entities in the Manage Dependencies window (Ctrl+Q). ... .

Publish the app by clicking the 1-Click Publish button. ... .

It's time to load some data to the Screen..

How fetch data from database in PHP and display in table?

php $connect=mysql_connect('localhost', 'root', 'password'); mysql_select_db("name"); //here u select the data you want to retrieve from the db $query="select * from tablename"; $result= mysql_query($query); //here you check to see if any data has been found and you define the width of the table If($result){ echo "< ...