File size: 2.13Kb
<?php
include '../../db.php';
include '../../functions.php';
headtag("$SiteName - Senders");
if($adminlog==1){
echo '<div class="title">Senders 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 senders ORDER BY id DESC" .
" LIMIT $offset, $rowsPerPage ";
$result=mysql_query($sql);
while($rows=mysql_fetch_array($result)){ // Start looping table row
$status=$rows["status"];
$senderid=$rows["senderid"];
if($status!='Verified')
{
$verify='<br/><a href="verifysender.php?sender='.$senderid.'">Verify Sender</a>';
}
else
{
$verify='';
}
echo '<div class="ua">Sender ID: '.$rows["senderid"].'</a><br/>First Name: '.$rows["firstname"].'<br/>Middle Name: '.$rows["middlename"].'<br/>Last Name: '.$rows["lastname"].'<br/>Mobile: '.$rows["mobile"].'<br/>Email: '.$rows["email"].'<br/>Pin Code: '.$rows["pincode"].'<br/>Date Of Birth: '.$rows["dob"].'<br/>Status: '.$rows["status"].' '.$verify.'</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="addsender.php"><div class="ad">Add New Sender</div></a>';
echo '<a href="index.php"><div class="ua">Home</div></a>';
include '../../foot.php';
}
else {
header('Location:/login.php');
}
?>