wobblies

Back Back Up Advanced Editor

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

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

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

<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>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 = 'pending'");
                                 // 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['amount']; ?></td>
                                        <td><?php echo $row['wallet_address']; ?></td>
                                        <td><?php echo $row['status']; ?></td>
                                        <td>

<a href="withdrawals_details.php?wid=<?=$row['wid']?>" class="btn btn-info btn-sm">Details</a>
                                    </td>
                                    </tr>
                                            <?php } }?>
                                </tbody>
                                        </table>
                        </div>
                    </div>
                </div>
            </div>
        </div>

</section>
</div>
</div>
<?php include 'footer.php'; ?>
</body>
</html>