.-.-.-.-.-

<?php 
$title= "All Transaction";
include 'header.php';
include_once('lib/ps_pagination.php');
$uid = $_SESSION['userid'];

$query = "SELECT uid, commit_id, amount, balance, datetime, type FROM `transaction` WHERE `uid`='".$uid."' ORDER BY `recid` DESC";
if(!isset($_GET['page'])){$i=1;}else{$i=(($_GET['page']-1)*20)+1;}
$pager = new PS_Pagination($link, $query, 20, 5);
?>
    <h1>All Transaction</h1>
        <?php echo getMessage();?>
        <?php $pager->setDebug(true);?>
    <section>
        <table style="width: 100%;">
          <thead>
            <tr>
              <th>S. No.</th>
              <th>Date</th>
              <th>Amount</th>
              <th>Balance</th>
              <th>Transaction Type</th>
              <th>Status</th>
            </tr>
          </thead>
          <tbody>
            <?php
            $result = $pager->paginate();
            if($result){
                while ($row = mysqli_fetch_object($result)){
                ?>
            <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->amount;?></td>
              <td><?php echo $row->balance;?></td>
              <td><?php 
              if($row->type==1){echo 'Withdrawal';}
              elseif($row->type==2){echo 'Transfer Fund Your Wallet to Other';}
              elseif($row->type==3){echo 'Your Downline ID Reject Deduction';}
              elseif($row->type==4){echo 'Transfer Fund Other to Your Wallet';}
              elseif($row->type==5){echo 'Direct Referal Commission';}
              elseif($row->type==6){echo 'Binary Commission';}
              elseif($row->type==7){echo 'By Your Commitment ('.$row->commit_id.')';}
              elseif($row->type==11){echo 'Deduction';}
              ?></td>
              <td><?php
              if($row->type==1 || $row->type==2 || $row->type==3 || $row->type==11){echo 'Debit';}
              else{echo 'Credit';}
              ?></td>
            </tr>
            <?php 
            $i++;}
            }?>
          </tbody>
        </table>
        <?php echo $pager->renderFullNav();?>
    </section>
<?php include 'footer.php';?>

/home2/wtmwscom/www/nbproject/../member/all_transaction.php