File Manager

Editing File: /home/quiczmwg/bitmaven.org/admin/manage-users.php

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

<?php 
        include 'sidebar.php';
      
        // Modify the SQL query to order by a column (e.g., registration date)
        $sql = "SELECT * FROM user_login ORDER BY created_at ASC";
        $result = $conn->query($sql);
        ?>

<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>UserID</th>
                                            <th>Fullname</th>
                                            <th>Email</th>
                                            <th>Profit Balance</th>
                                            <th>Account Balance</th>
                                            <th>----</th>
                                        </thead><br>

<tbody>
                                            <?php 
                                            // Check if there are any rows returned by the query
                                            if($result !== false && $result->num_rows > 0){
                                                $num = 1;
                                                // Fetch each row from the result set
                                                while($row = $result->fetch_assoc()){                               
                                            ?>
                                            <tr>
        <td><?php echo $num++; ?></td>
        <td><?php echo $row['userid']; ?></td>
        <td><?php echo $row['full_name']; ?></td>
        <td><?php echo $row['email']; ?></td>
        <td>$<?php echo number_format($row['profit_balance'], 2); ?></td>
        <td>$<?php echo number_format($row['account_balance'], 2); ?></td>
        
<td>
    <a href="info.php" class="btn btn-info btn-sm">Details</a>
    <a href="admin_login_as_user.php?userid=<?php echo $row['userid']; ?>" class="btn btn-primary btn-sm">Login as User</a>
</td>

</tr>
    <?php 
        }
    } else {
        // Handle case where no rows are returned
        echo "<tr><td colspan='6'>No users found.</td></tr>";
    }
    ?>
                                        </tbody>
                                    </table>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

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

Back to Directory File Manager