Viewing File: /home/quiczmwg/public_html/admin/confirmed_withdrawal.php

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


<body class="skin-default fixed-layout">
<div id="main-wrapper">

    <?php 
    include 'sidebar.php';
    // include 'config.php';

    // $sql = $conn->query("SELECT * FROM deposit WHERE dstatus = 'confirmed' ");
    $sql = $conn->query("SELECT * FROM withdrawals WHERE status = 'confirmed' ");
    ?>

<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>Date</th>
                                    <th>UserID</th>
                                    <th>withdrawals ID</th>
                                    <!-- <th>Email</th> -->
                                    <th>Amount</th>
                                    <th>Method</th>
                                    <th>Status</th>
                                    <th>----</th>
                                </thead><br>

                                <tbody>
                                <?php
                                  // Modify the SQL query to order by a column (e.g., registration date)
                                  $sql = $conn->query("SELECT * FROM withdrawals WHERE status = 'confirmed'");
                                 // Check if there are any rows returned by the query
                                 if ($sql !== false && $sql->num_rows > 0) {
                                    $num = 1;
                                    // Fetch each row from the result set
                                    while ($row = $sql->fetch_assoc()) {
                                        ?>
                                    <tr>
                                        <td><?php echo $num++; ?></td>
                                        <td><?php echo $row['created_at']; ?></td>
                                        <td><?php echo $row['userid']; ?></td>
                                        <td><?php echo $row['wid']; ?></td>
                                        <!-- <td></?php echo $row['email']; ?></td> -->
                                        <td>$<?php echo $row['amount']; ?></td>
                                        <td><?php echo $row['wallet_address']; ?></td>
                                        <td><?php echo $row['status']; ?></td>
                                        <td>
                                        

                                        <a href="delete-withdrawals.php?delete=<?php echo $row['id']; ?>" class="btn btn-danger"><i class="bi bi-trash3-fill"></i> Delete</a>
                                    </td>
                                    </tr>
                                            <?php } }?>
                                </tbody>
                                        </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>

    </section>
</div>
</div>
<?php include 'footer.php'; ?>
</body>
</html>
Back to Directory File Manager
<