1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live / user /
Filename : referral-contest.php
back
<?php
session_start();
error_reporting(0);
include('../../config/conn.php');
include('includes/checklogin.php');
include 'includes/functions.php';

check_login();
$title="Dashboard";
include 'includes/header.php'; 
$today = date("Y-m-d");

?>
<div class="main-content">

<div class="page-content">
    <div class="container-fluid">

        <!-- start page title -->
        <div class="row">
            <div class="col-12">
                <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                    <h4 class="mb-sm-0">Referral Contest</h4>

                    <div class="page-title-right">
                        <ol class="breadcrumb m-0">
                            <li class="breadcrumb-item"><a href="index.php">Home</a></li>
                            <li class="breadcrumb-item active">Referral Contest</li>
                        </ol>
                    </div>

                </div>
            </div>
        </div>
        <!-- end page title -->
                        <?php if(isset($msg)){ ?>
                                <div class="alert alert-<?php echo $type?>">
                                <h6 class="alert-heading fw-bold mb-1"><?php echo $type?></h6>
                                <p class="mb-0"><?php echo $msg?></p>
                                </div>
                        <?php }?>
                    </div>
  
                    <div class="card border-0">
                       
                        <div class="card-body pt-3">

                          
                            <div class="col-lg-6 table-responsive">
                    <p class="mb-1 pt-2 text-bold">Leadership Board</p>
                    <?php 
              // Query to retrieve the top referrers
              $query = "SELECT referred_by, COUNT(*) AS referral_count 
                        FROM users 
                        WHERE referred_by IS NOT NULL AND created_at >= '2024-09-10 00:00:00'
                        GROUP BY referred_by 
                        ORDER BY referral_count DESC 
                        LIMIT 15";

              // 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>Username</th>
                      <th>Referrals</th>
                    </tr>
                  </thead>
                  <tbody>
                  <?php 
                       while ($row = $result->fetch_assoc()) {
                        $referredBy = $row['referred_by'];
                        $referralCount = $row['referral_count'];
                              
                      ?>
                    <tr>
                    <td><?php echo $cnt++;?></td>

                      <td>   
                          <p class="text-xs font-weight-bold mb-0"><?php echo $referredBy;?></p>
                     
                      </td>
                      <td>
                        <p class="text-xs font-weight-bold mb-0"><?php echo $referralCount;?></p>
                      </td>
                     
                    </tr>
                    
                    <?php
                    } 
                 
                    ?>
 
                  </tbody>
                </table>
                <?php
               
              } else {
                  echo "No record yet.";
              }

            }
                ?>
                  </div>

                            </div>

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

<?php include 'bottom-tabs.php' ?>
<?php include 'includes/footer.php' ?>