We can view records of table using SELECT statement.

  • Let’s see a PHP code, to view records of a table.

File – view.php

<?php
$conn = mysqli_connect(‘localhost’,’root’,”,’microcodes’);
 
$sql=”SELECT * FROM registry”;
$query=mysqli_query($conn,$sql);
 
while($row=mysqli_fetch_assoc($query)){
    echo “<br>”.$row[‘enrollno’].” “.$row[‘fullname’].” “.$row[’emailaddr’].” “.$row[‘phone’].” “.$row[‘date’];
}
 
?>
output

  • Let’s see a PHP code, to view records of a table with border.

File – view_table.php

<?php
$conn = mysqli_connect(‘localhost’,’root’,”,’microcodes’);
 
$mysqli = $conn;
 
$query = “SELECT * FROM registry”;
 
echo ‘<table border=”2px” cellspacing=”2″ cellpadding=”2″>
      <tr>
          <td> <font face=”Arial”>Enroll No</font> </td>
          <td> <font face=”Arial”>Name</font> </td>
          <td> <font face=”Arial”>Email</font> </td>
          <td> <font face=”Arial”>phone</font> </td>
          <td> <font face=”Arial”>date</font> </td>
         </tr>’;
 
if ($result = $mysqli->query($query)) {
    while ($row = $result->fetch_assoc()) {
        $field1name = $row[“enrollno”];
        $field2name = $row[“fullname”];
        $field3name = $row[“emailaddr”];
        $field4name = $row[“phone”];
        $field5name = $row[“date”];
       
         echo ‘<tr>
                  <td>’.$field1name.'</td>
                  <td>’.$field2name.'</td>
                  <td>’.$field3name.'</td>
                  <td>’.$field4name.'</td>
                  <td>’.$field5name.'</td>
                  </tr>’;
    }
    $result->free();
}
?>
output

download notes

download code.zip