Display Record on Webpage using PHP


Prev Tutorial Next Tutorial

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';

mysql_select_db("tutorohx_rw", $conncection);

$sql = "SELECT * from  user ORDER BY  s_no DESC";  
$result = mysql_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 = mysql_fetch_array($result))
 {
?>

<?php
 }
} 
?>

</table>

Prev Tutorial Next Tutorial

Google Advertisements
Download Projects

Google Adsense Advertisements

Buy 3 Year Old Domain, Tutorialday.com, SeosmoTools.com @$200

Buy This Ad Space @$50 per Month, Ad Size 300X250 Contact on: hitesh.xc@gmail.com WhatsApp no. 8882538826

Yahoo Advertisements