wobblies

Back Back Up Advanced Editor

<?php
// session_start();
include 'head.php';
include 'header.php';?>

<?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>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>