<div class="container">
<table class="table table-bordered" style="position: fixed; margin-left:12px; margin-top:210px; margin-bottom:10px; width:87%">
<thead>
<tr>
<th style="padding-bottom:15px;">No.</th>
<th style="padding-bottom:15px;">ID Number</th>
<th style="padding-bottom:15px;">Name</th>
<th style="padding-bottom:15px;">Department</th>
<th style="padding-bottom:15px;">Position</th>
<th style="padding-bottom:15px;">Role</th>
<th style="padding-bottom:15px;">Status</th>
<th style="padding-bottom:15px;">Option</th>
</tr>
</thead>
<tbody class="table-users">
<?php
$sql = "SELECT id, userid, name, department, position, status, role FROM tbl_user WHERE role<>'SUPER ADMIN'";
foreach ($db->query($sql) as $row) {
?>
<tr>
<td><?php echo $row['id']; ?></td>
<td><?php echo $row['userid']; ?></td>
<td><?php echo $row['name']; ?></td>
<td><?php echo $row['department']; ?></td>
<td><?php echo $row['position']; ?></td>
<td><?php echo $row['role']; ?></td>
<td><?php echo $row['status']; ?></td>
<td>
<a href="#edit_<?php echo $row['id']; >" class="btn btn-success btn-sm"
data-toggle="modal"><span class="glyphicon glyphicon-edit"></span> Edit</a>
</td>
<?php include('edit_delete_modal.php'); ?>
</tr>
<?php } ?>
</tbody>
</table>
</div>