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