1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / tapnaire.live /
Filename : top-earners.php
back
<?php 
session_start();
// Database connection
include('../config/conn.php');
include "includes/header.php" 
?>

 <!-- Page title start-->
 <div class="page-title-area pb-100 bg-light bg-img" data-bg-image="images/page-title-bg-1.jpg" style="margin-top:-5vh !important;">
    <div class="container">
        <div class="content r">
            <h2>Tapnaire Leadership Board</h2>
            <div class>
            </div>
        </div>
    </div>
</div>
<!-- Page title end-->

<style>
    .card{
        border-radius: 18px !important;
        border: 1px solid #E25D1A;
        margin-top: -5px !important;
        margin-bottom: -5px !important;
        max-height: 100px !important;
        padding: -50px;
    }
    .card-img{
        max-width: 100px !important;
        height: 100px !important;
        magrgin-left: -20px;
    }
    
    .card-text{
        padding-top: -50px !important;
    }
    
    
        .absolute {
        position: absolute;
    }
    .relative {
        position: relative;
    }
    
    
    .small{
        font-size: 12px !important;
        color: #fff;
    }
    .bold{
        font-weight: semibold !important;
    }
    .bolder{
        font-weight: bold !important;
    }
</style>

<!-- Terms-area start -->
<section class>
    
<div class="row mt-4 px-4">

<div class="row mb-5 ">

<script type="text/javascript">
	atOptions = {
		'key' : '2c5d7ed65ce539d57442ba51ae801137',
		'format' : 'iframe',
		'height' : 50,
		'width' : 320,
		'params' : {}
	};
	document.write('<scr' + 'ipt type="text/javascript" src="http' + (location.protocol === 'https:' ? 's' : '') + '://www.profitabledisplaynetwork.com/2c5d7ed65ce539d57442ba51ae801137/invoke.js"></scr' + 'ipt>');
</script>
</div>


   
<?php 
                    //$query = "SELECT * FROM `users` WHERE `ref_bonus` >= 4500 ORDER BY `ref_bonus` DESC LIMIT 10";
                     
                    $query = "SELECT u.username, u.user_picture, SUM(e.amount) AS total_earning
                    FROM earning_history e
                    JOIN users u ON e.user_id = u.id
                    GROUP BY u.username, u.user_picture
                    HAVING total_earning >= 100000
                    ORDER BY total_earning DESC
                    LIMIT 50";    
                    $result=mysqli_query($con,$query);
                    $cnt=1;
                    if(mysqli_num_rows($result)>0){
                    while($row=mysqli_fetch_array($result)){
                        $username = $row['username'];
                        $userPicture = $row['user_picture'];
                        $totalEarning = $row['total_earning'];

                    ?>
<div class="col-sm-6 col-md-4 mb-4">
<div class="card">
  <div class="row no-gutters d-flex flex-column justify-content-between h-100">
    <div class="col-md-4 absolute ">
      <img src="admin/profilepics/<?php echo $row['user_picture'];?>" class="card-img rounded-circle img-fluid p-2">
    </div>
    <div class="col-md-8 text-end">
      <div class="card-body  ">
        <div>
          <p class="card-text text-black bold"
          style="text-transform:uppercase;"><?php echo $username;?></p>
        </div>
        <div class="mt-3">
          <p class="card-text text-black bold">Amount: <small class="color-primary bolder">₦<?php echo $totalEarning;?></small></p>
        </div>
      </div>
    </div>
  </div>
</div>
</div>


<?php } 
                    }else{
                      echo"No Record Found!";
                  }
                  ?>

</div>
<div class="row mt-4 px-4">
<script type="text/javascript">
	atOptions = {
		'key' : '704054eaa141a74a3bff128905210a64',
		'format' : 'iframe',
		'height' : 50,
		'width' : 320,
		'params' : {}
	};
</script>
<script type="text/javascript" src="//www.highperformanceformat.com/704054eaa141a74a3bff128905210a64/invoke.js"></script>
</div>
</section>
<!-- Terms-area end -->

<script>
function goToLink(url) {
  window.location = url;
}
</script>

<?php include "includes/footer.php" ?>