how to display data from database in php in table? simple step by step learn to Fetch Data From Database in PHP and Display in HTML Table Example with demo.
<?php
$host = "127.0.0.1";
$userName = "root";
$userPass = "";
$database = "pakainfo_v1";
$link = mysqli_connect($host,$userName,$userPass,$database);
if(mysqli_connect_errno()){
echo mysqli_connect_error();
exit();
}else{
$sqlQQ = "SELECT * FROM `tbl_members` ORDER BY `member_id` ASC";
$result = mysqli_query($link,$sqlQQ);
if(mysqli_num_rows($result) > 0){
}else{
$msg = "No Member Record found";
}
}
?>
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>HTML and PHP code</title>
</head>
<body>
<h1>Display member list using HTML and PHP</h1>
<?=$msg;?>
<table border="1px" style="width:600px; line-height:40px;">
<thead>
<tr>
<th>Name</th>
<th>Email</th>
<th>Status</th>
<th>Registrating Date</th>
</tr>
</thead>
<tbody>
<?php
while($row = mysqli_fetch_assoc($result)){?>
<tr>
<td><?php echo $row['member_firstName'].$row['member_lastName']; ?></td>
<td><?php echo $row['member_email']; ?></td>
<td><?php if($row['member_status'] == 1){
echo "Active";
}else{
echo "Deactive";
} ?></td>
<td><?php echo $row['member_registrationDate']; ?></td>
<tr>
<?}?>
</tbody>
</table>
</body>
</html>
HTML File Code
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>HTML and PHP source code</title>
</head>
<body>
<h3>Display member list using HTML and PHP</h3>
<?=$msg;?>
<table border="1px" style="width:600px; line-height:40px;">
<thead>
<tr>
<th>Name</th>
<th>Email</th>
<th>Registrating Date</th>
</tr>
</thead>
<tbody id="tableBody">
</tbody>
</table>
</body>
</html>
<script src="https://code.jquery.com/jquery-3.4.1.min.js" integrity="sha256-CSXorXvZcTkaix6Yvo6HppcZGetbYMGWSFlBw8HfCJo=" crossorigin="anonymous"></script>
<script>
$( document ).ready(function() {
$.ajax({
url: 'fetch.php',
mothod: 'post',
dataType: 'json',
success:function(data){
let string = '';
$.each(data, function(key, value){
string += `<tr>
<td>${value['member_firstName']} ${value['member_lastName']}</td>
<td>${value['member_email']}</td>
<td>${value['member_registrationDate']}</td>
</tr>`;
});
$('#tableBody').append(string);
},
error:{
}
});
});
</script>
PHP File Code
<?php
//how to display data from database in php in table
$host = "127.0.0.1";
$userName = "root";
$userPass = "";
$database = "pakainfo_v1";
$link = mysqli_connect($host,$userName,$userPass,$database);
if(mysqli_connect_errno()){
echo mysqli_connect_error();
exit();
}else{
$sqlQQ = "SELECT * FROM `tbl_members` ORDER BY `member_id` ASC";
$result = mysqli_query($link,$sqlQQ);
if(mysqli_num_rows($result) > 0){
$result_array = array();
while($row = mysqli_fetch_assoc($result)){
array_push($result_array, $row);
}
}
echo json_encode($result_array);
}
?>
HTML File Code
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="ie=edge">
<title>HTML and PHP code</title>
<style>
table, td, th {
border: 1px solid #ddd;
text-align: left;
}
table {
border-collapse: collapse;
width: 100%;
}
th, td {
padding: 15px;
}
</style>
</head>
<body>
<h3>Display member list using HTML and PHP</h3>
<?= $msg; ?>
<table id="my-example">
<thead>
<tr>
<th>Name</th>
<th>Email</th>
<th>Registrating Date</th>
</tr>
</thead>
<tbody>
</tbody>
</table>
</body>
</html>
<script src="https://code.jquery.com/jquery-3.4.1.min.js" integrity="sha256-CSXorXvZcTkaix6Yvo6HppcZGetbYMGWSFlBw8HfCJo=" crossorigin="anonymous"></script>
<link rel="stylesheet" type="text/css" href="http://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/css/jquery.dataTables.css">
<script type="text/javascript" charset="utf8" src="https://ajax.aspnetcdn.com/ajax/jquery.dataTables/1.9.4/jquery.dataTables.min.js"></script>
<script>
$(document).ready(function() {
$('#my-example').dataTable({
"bProcessing": true,
"sAjaxSource": "fetch.php",
"aoColumns": [{
mData: 'member_firstName'
},
{
mData: 'member_email'
},
{
mData: 'member_registrationDate'
}
]
});
});
</script>
<?php
$host = "127.0.0.1";
$userName = "root";
$userPass = "";
$database = "pakainfo_v1";
$link = mysqli_connect($host,$userName,$userPass,$database);
if(mysqli_connect_errno()){
echo mysqli_connect_error();
exit();
}else{
$sqlQQ = "SELECT * FROM `tbl_members` ORDER BY `member_id` ASC";
$result = mysqli_query($link,$sqlQQ);
if(mysqli_num_rows($result) > 0){
$result_array = array();
while($row = mysqli_fetch_assoc($result)){
array_push($result_array, $row);
}
}
$results = ["sEcho" => 1,
"iTotalRecords" => count($result_array),
"iTotalDisplayRecords" => count($result_array),
"aaData" => $result_array ];
echo json_encode($results);
}
?>
I hope you get an idea about how to display data from database in php in table.