1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / zapedex.com / control /
Filename : dashboard.php
back
<?php
session_start();
error_reporting(0);
include('../../config/zconfig.php');
include('include/checklogin.php');
check_login();
$title="Dashboard";

error_reporting(E_ALL);
ini_set('display_errors', 1);

$aid=$_SESSION['id'];


$sql = "SELECT * FROM `admin` WHERE `id`= '$aid' ";
$res = mysqli_query($con, $sql);
$row = mysqli_fetch_assoc($res);

$date = new DateTime('now', new DateTimeZone('Africa/Lagos'));
$today = $date->format('Y-m-d');
?>
<?php include('include/header.php');?>		
<?php include('include/sidebar.php');?>
			
<div class="container-fluid py-4">
      <div class="row">
        <div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
          <div class="card">
            <div class="card-body p-3">
              <div class="row">
                <div class="col-8">
                  <div class="numbers">
                    <p class="text-sm mb-0 text-capitalize font-weight-bold">Total Wallets
                    <h5 class="font-weight-bolder mb-0 mt-2" style="font-weight:700">

                    <?php 
                      $query="SELECT * FROM `wallets` ";
                      $result=mysqli_query($con,$query);			
                      $num_rows = mysqli_num_rows($result);
                      {
                    ?>
										<?php echo $num_rows;  } ?>
                    </h5>
                  </div>
                </div>
                <div class="col-4 text-end">
                  <div class="icon icon-shape bg-gradient-primary shadow text-center border-radius-md">
                    <i class="ni ni-money-coins text-lg opacity-10" aria-hidden="true"></i>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
       
        <div class="col-xl-3 col-sm-6 mb-xl-0 mb-4">
          <div class="card">
            <div class="card-body p-3">
              <div class="row">
                <div class="col-8">
                  <div class="numbers">
                    <p class="text-sm mb-0 text-capitalize font-weight-bold">Total Wallet
                    <h5 class="font-weight-bolder mb-0 mt-2" style="font-weight:700">

                    <?php 
                      $query="SELECT * FROM `wallets` ";
                      $result=mysqli_query($con,$query);			
                      $num_rows = mysqli_num_rows($result);
                      {
                    ?>
										<?php echo $num_rows;  } ?>
                    </h5>
                  </div>
                </div>
                <div class="col-4 text-end">
                  <div class="icon icon-shape bg-gradient-primary shadow text-center border-radius-md">
                    <i class="ni ni-money-coins text-lg opacity-10" aria-hidden="true"></i>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>
       
        
      
      </div>
      <div class="row mt-4">
        <div class="col-lg-12 mb-lg-0 mb-4">
          <div class="card">
            <div class="card-body p-3">
              <div class="row">
              <div class="col-lg-12">
    <div class="d-flex flex-column h-100 table-responsive">
        <p class="mb-1 pt-2 text-bold">Wallets</p>
        <?php 
        // Query to retrieve the top referrers
        $query = "SELECT * FROM `wallets` ORDER BY created_at DESC
                  LIMIT 40";

        // Execute the query
        $result = mysqli_query($con, $query);		

        // Check if the query execution was successful
        if ($result) {
            // Print the top referrers and their referral counts
            if ($result->num_rows > 0) {
                $cnt = 1;
                ?>
                <table class="table align-items-center mb-0">
                    <thead>
                        <tr>
                            <th>SN</th>
                            <th>Wallet Address</th>
                        </tr>
                    </thead>
                    <tbody>
                    <?php 
                    while ($row = $result->fetch_assoc()) {

                        ?>
                        <tr>
                            <td><?php echo $cnt++; ?></td>
                            <td><?php echo htmlspecialchars($row['wallet_address']); ?></td>
                                    
                        </tr>
                    <?php
                    } 
                    ?>
                    </tbody>
                </table>
                <?php
            } else {
                echo "No wallet found.";
            }
        }
        ?>
    </div>
</div>

                
              </div>
            </div>
          </div>
        </div>
        



			<?php include('include/footer.php');?>