How to fetch data from database and display on table using PHP?

Very often we need to display data from a database on a web page. To display those data it is best to use HTML table. Today I will share how to display data from MySQL database into HTML table using PHP.

Consider, we have a database named data, a table named student. And inside this table there have some data.

First create a HTML form. A simple HTML form containing fields – Name, E-mail, phone, state and password. On submitting the form, the data is inserted into MySQL table using PHP code. We will fetch the inserted record present in the database table and display those data in an HTML table.

1. Create a HTML form = First we have to create a form to insert data into database table.

Read - How to Insert Form Data into MySQL Database using PHP ?

2. Now we have to create a table inside the home.php page and fetch the inserted record present in the database table and display those data in the table.

Code -

<title>Untitled Document</title>
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/4.0.0/css/bootstrap.min.css" integrity="sha384-Gn5384xqQ1aoWXA+058RXPxPg6fy4IWvTNh0E263XmFcJlSAwiGgFAW/dAiS6JXm" crossorigin="anonymous">
<link rel="stylesheet" href="https://cdnjs.cloudflare.com/ajax/libs/font-awesome/4.7.0/css/font-awesome.min.css">

</head>

<body>

<h1 style="text-align:center; color:#CC3300;" > Welcome to the home page.</h1>
<br>
<div class="card-body">
              <div class="table-responsive">
                <table class="table table-bordered" id="dataTable" width="100%" cellspacing="0" >
                  <thead>
                    <tr>
                      <th>Sl. No.</th>
                      <th>Name</th>
                      <th>Email</th>
                      <th>Phone</th>
                      <th>State</th>
                      
                      <th>Update</th>
                      <th>Delete</th>
                    </tr>
                  </thead>
                  
                  <tbody>
                  <?php
							require('dbconnect.php');
   							$sl=0;
							$query1=mysqli_query($con,"select * from student");
							while($row=mysqli_fetch_array($query1))
								{ 
									$sl++;
								?>
					<tr>
						<td><?php echo $sl; ?></td>
											
                      <td><?php echo $row['name']; ?></td>
                      <td><?php echo $row['email']; ?></td>
                      <td><?php echo $row['phone']; ?></td>
                      <td><?php echo $row['state']; ?></td>
                      
											<td><i class="fa fa-pencil-square-o"></i></td>
											<td><i class="fa fa-trash"></i></a> 
   </td>
											
										</tr>
										<?php } ?>     
                  </tbody>
                </table>
              </div>
            </div>
</body>
</html>

Note - The fetch_array() / mysqli_fetch_array() function fetches a result row as an associative array, a numeric array, or both.

Header ads

How to fetch data from database and display on table using PHP?

Visit YouTube - Techno Junkie

Post a Comment

0 Comments

Search This Blog

Most Popular

HTML Form Validation Using JavaScript

How to Insert Form Data into MySQL Database using PHP ?