Thursday, 18 April 2013

Show Records using PHP + MySQL database connectivity in the website


PHPleqrn  Show Data of Database into the Tabular Format :

The Below Code will show the Columns
1.Username
2. Fullname 
3. Mobileno 
into the tabular format.


<?php
Echo "Show record of tbladmin";
$result = mysqli_query($con,"SELECT * FROM tbladmin");
echo "<table border=1>";
echo"<tr>
<th>Username</th>
<th>Fullname</th>
<th>Mobileno</th>
</tr>";
while($row = mysqli_fetch_array($result))
  {
  echo "<tr><td>".$row['username'] ."</td> <td> " . $row['fullname']." </td><td> ".$row['mobileno']."</td></tr>";

  }
 echo "</table>";
?>

For learning Project Training in Vadodara, Gujarat. Visit  website: www.vataliyatuitionclasses.com

No comments:

Post a Comment