all_student.php

<table class="table table-bordered table-hover project_table">
	<thead>
		<tr>
			<th>Student Name</th>
			<th>Matric</th>
			<th>Level</th>
			<th>Department</th>
      <th>Date Added</th>
			<th>Option</th>
		</tr>
	</thead>
	<tbody>
		<?php
           $query = $db->query("SELECT * FROM student");
             $rows = $query->fetchAll(PDO::FETCH_OBJ);
             foreach($rows as $row){
               $name = $row->name;
               $department = $row->department;
               $level = $row->level;
               $matric = $row->matric;
               $date = $row->date;
        ?>
             <tr>
             	<td><?php echo $name; ?></td>
             	<td><?php echo $matric; ?></td>
             	<td><?php echo $level ?></td>
              <td><?php echo $department ?></td>
              <td><?php echo $date; ?></td>
             	<td>
             	    <a class="btn btn-xs btn-primary" href="edit_std_data.php?id=<?php echo $row->id; ?>"><i class="fa fa-edit"></i></a>
             		  <a class="btn btn-xs btn-danger" onclick="return confirm('Are you sure you want to delete project? ')" href="delete_std_data.php?id=<?php echo $row->id; ?>"><i class="fa fa-trash"></i></a>
             	</td>
             </tr>
        <?php
           }
		?>
	</tbody>
</table>