Display Record on Webpage using PHP
Advertisements
How to Display Record on Webpage using PHP
To display all record from database on webpage; we write below mysql syntax
Syntax
<?php
include 'db-connect.php';
mysqli_select_db("tutorohx_rw", $conncection);
$sql = "SELECT * from user ORDER BY s_no DESC";
$result = mysqli_query($sql, $connection);
?>
This code display all record in decending order.
display-record.php
Display Record
<table>
<tr><th>ID</th><th>First Name</th><th>Last Name</th></tr>
<tr>
<td><?php echo $row["f_name"]; ?></td>
<td><?php echo $row["l_name"]; ?></td>
</tr>
<?php
if ($result)
{
while($row = mysqli_fetch_array($result))
{
?>
<?php
}
}
?>
</table>
Google Advertisment
