.-.-.-.-.-

<?php 
$title= "Binary Growth";
include 'header.php';
include_once('lib/ps_pagination.php');
$uid = $_SESSION['userid'];
?>
    <h1>Binary Growth</h1>
        <?php echo getMessage();?>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>Closing Date</th>
              <th>Matching Amount</th>
              <th>Binary Amount</th>
              <th>Date</th>
              <th>Slot</th>
            </tr>
          </thead>
          <tbody>
            <?php
            $query = "SELECT amount, matching_amount, datetime, date, slot FROM binary_income WHERE uid='$uid' ORDER BY `datetime` DESC";
            //$query = "SELECT from_uid, amount, datetime FROM `binary_income` WHERE `uid`='".$uid."' ORDER BY `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)){
                //$name = mysqli_fetch_object(mysqli_query($connection,"SELECT name FROM user WHERE uid='".$row->from_uid."'"))->name;
                ?>
            <tr <?php if($i%2){echo "class='light'";}else{echo "class='dark'";}?>>
              <td><?php echo $i; ?></td>
              <td><?php echo date("d M, Y h:i A", strtotime($row->datetime));?></td>
              <td><?php echo $row->matching_amount;?></td>
              <td><?php echo $row->amount;?></td>
              <td><?php echo date("d M, Y", strtotime($row->date));?></td>
              <td><?php echo $row->slot;?></td>
            </tr>
            <?php 
            $i++;}
            }?>
          </tbody>
        </table>
            <?php echo $pager->renderFullNav();?>  
      </section>
<?php include 'footer.php';?>

/home2/wtmwscom/public_html/css/../member/binary_growth.php