.-.-.-.-.-

<?php 
$title= "Referral Growth";
include 'header.php';
$uid = $_SESSION['userid'];
include_once('lib/ps_pagination.php');
?>
    <h1>Referral Bonus</h1>
        <?php echo getMessage();?>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>From</th>
              <th>Commitment Amount</th>
              <th>Referral Bonus</th>
              <th>Date</th>
              <th>Confirm Status</th>
            </tr>
          </thead>
          <tbody>
            <?php
            $query = "SELECT ri.from_uid AS from_uid, ri.amount AS amount, ri.commit_id AS commit_id, ri.datetime AS datetime, "
                    . "ri.confirm_status AS confirm_status, c.amount AS commit_amount, u.login_id AS login_id, u.name AS name FROM `referral_income` ri "
                    . " INNER JOIN `commit` c ON ri.commit_id = c.commit_id INNER JOIN user u ON ri.from_uid = u.uid "
                    . " WHERE ri.uid='".$uid."' ORDER BY ri.datetime DESC";
            if(!isset($_GET['page'])){ $i=1; }else{$i=(($_GET['page']-1)*20)+1;}
            $pager = new PS_Pagination($link, $query, 20, 5);
            $pager->setDebug(true);
            $result = $pager->paginate();
            if($result){
                while ($row = mysqli_fetch_object($result)){
                    //$user = mysqli_fetch_object(mysqli_query($connection,"SELECT login_id, name FROM user WHERE uid='".$row->from_uid."'"));
                ?>
            <tr <?php if($i%2){echo "class='light'";}else{echo "class='dark'";}?>>
              <td><?php echo $i; ?></td>
              <td><?php echo $row->name." (".$row->login_id.")";?></td>
              <td><?php echo $row->commit_amount;?></td>
              <td><?php echo $row->amount;?></td>
              <td><?php echo date("d M, Y H:i A", strtotime($row->datetime)); ?></td>
              <td><?php echo $row->confirm_status == 1 ? "Confirm" : "Unconfirm"; ?></td>
            </tr>
            <?php 
            $i++;}
            }
            ?>
          </tbody>
        </table>
            <?php echo $pager->renderFullNav();?>  
      </section>
<?php include 'footer.php';?>

/home2/wtmwscom/logs/../public_html/member/referral_bonus.php