PHP program to fetch data from database and display in a HTML table
Write a PHP program to fetch data from database and display in a HTML table
In this tutorial, you will learn how to fetch data from database and display in a HTML table in php, so to read customer information like Cust_no, Cust_name, Item_purchased and Mob_no. from Customer table and display all these information in table format on output screen.
Below is the php script to fetch data from database and display in a HTML table in php
<html>
<head>
<title>PHP program to fetch data from database in & show in html table</title>
</head>
<body>
<h3>Write a PHP program to fetch data from database and display in a HTML table in php</h3>
<table border="2" bordercolor="blue" bgcolor="#00FF">
<thead>
<tr>
<th>Cust_Id</th>
<th>Cust_Name</th>
<th>Items_Purchased</th>
<th>Phone_No</th>
</tr>
</thead>
<tbody>
<?php
$connection = mysqli_connect("localhost","root","");
$db = mysqli_select_db($connection,"database_name");
$query = mysqli_query($connection,"SELECT * FROM customer");
if (mysqli_num_rows($query)==0)
{
echo "<tr>
<td colspan='4'> No rows returned </td>
</tr>";
}
else
{
while($row=mysqli_fetch_row($query))
{
echo "<tr>
<td> $row[0] </td>
<td> $row[1] </td>
<td> $row[2] </td>
<td> $row[3] </td>
</tr> ";
}
}
?>
</tbody>
</table>
</body>
</html>
Thanks for reading.