File size: 1.99Kb
<?php
include '../../db.php';
include '../../functions.php';
headtag("$SiteName - Receivers");
if($adminlog==1){
echo '<div class="title">Receivers List</div>';
// OREDER BY id DESC is order result by descending
$result=mysql_query($sql);
// how many rows to show per page
$rowsPerPage = 20;
// by default we show first page
$pageNum = 1;
// if $_GET['page'] defined, use it as page number
if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
// counting the offset
$offset = ($pageNum - 1) * $rowsPerPage;
$sql = " SELECT * FROM receivers ORDER BY id DESC" .
" LIMIT $offset, $rowsPerPage ";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){ // Start looping table row
$receiver=$rows["receiverid"];
echo '<div class="ua">Receiver ID: '.$rows["receiverid"].'</a><br/>Pay ID: '.$rows["payid"].'</a><br/>Sender: '.$rows["sender"].'<br/>Name: '.$rows["name"].'<br/>Account No: '.$rows["accountno"].'<br/>IFSC Code: '.$rows["ifsc"].'<br/>Mobile: '.$rows["mobile"].'<br/>Status: '.$rows["status"].'<br/><a href="transfer.php?receiver='.$receiver.'">Transfer Money</a></div>';
}
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " || <a href=\"$self?page=$page\">Prev</a> || ";
$first = " <a href=\"$self?page=1\">First Page</a> ";
}
else
{
$prev = ' '; // we're on page one, don't print previous link
$first = ' '; // nor the first page link
}
if ($pageNum < 1000)
{
$page = $pageNum + 1;
$next = " <a href=\"$self?page=$page\">Next</a> ";
$last = " <a href=\"$self?page=$maxPage\">[Last Page]</a> ";
}
else
{
$next = ' '; // we're on the last page, don't print next link
$last = ' '; // nor the last page link
}
// print the navigation link
echo '<div class="ad">'.$first.' '.$prev.' '.$nav.' '.$next.'</div>';
mysql_close();
echo '<a href="addreceiver.php"><div class="ad">Add New Receiver</div></a>';
echo '<a href="index.php"><div class="ua">Home</div></a>';
include '../../foot.php';
}
else {
header('Location:/login.php');
}
?>