<?php
// session_start();
include 'head.php';
include 'header.php';?>
<body class="skin-default fixed-layout">
<div id="main-wrapper">
<?php
include 'sidebar.php';
// include_once ("../_db.php");
$sql = $conn->query("SELECT * FROM dusers");
?>
<div class="page-wrapper">
<section>
<div class="">
<?php
include 'nav1.php';
?>
<div class="container-fluid">
<div class="card">
<div class="card-header">
<?php echo isset($_SESSION['mgs'])?$_SESSION['mgs']:""?>
</div>
<div class="card-body">
<div class="table-responsive">
<table class="table">
<thead>
<th>#</th>
<th>Sub ID</th>
<!-- <th>Name</th> -->
<th>Email</th>
<th>Duration</th>
<th>Amount</th>
<th>Status</th>
<th>----</th>
</thead><br>
<tbody>
<?php
$sql = $conn->query("SELECT * FROM dbooking ORDER BY id ASC");
if($sql->num_rows>0){
$num=1;
while($rowx = $sql->fetch_assoc()){
?>
<tr>
<td><?php echo $num++; ?></td>
<td><?php echo $rowx['sid']; ?></td>
<td><?php echo $rowx['demail']; ?></td>
<td><?php echo $rowx['duration']; ?></td>
<td><?php echo $rowx['amount']; ?></td>
<td><?php echo $row['status']; ?></td>
<td>
<?php if($row['status']=='pending'){?>
<a href="controller.php?id=<?php echo
$row['userid']; ?>&status=verify"
class="btn btn-primary btn-sm my-2">verify</a>
<?php } else { ?>
<a href="#" class="btn btn-success btn-sm">Verified</a>
<?php } ?>
<a href="controller.php?id=<?php echo $row
['userid']; ?>&status=delete" class="btn btn-danger btn-sm">Delete</a>
</td><br>
</tr>
<?php } }?>
</tbody>
</table>
</div>
</div>
</div>
</div>
</div>
</section>
</div>
</div>
<?php include 'footer.php'; ?>
</body>
</html>