<script type="text/javascript">
function getUser(pno)
{
data = "pno="+pno;
$.ajax({
url: base_url+'/AjaxUser.php',
sync: true,
type: 'POST',
data: data,
success: function(resp) {
$("#listhistory").html(resp);
}
});
}
</script>
<div id="listhistory">
<?php
//Ajax Pagination
$w = '';
// getting page number
$pageno = (isset($_POST['pno']))?$_POST['pno']:'';
// for the filter option
$status = isset($_SESSION['status'])?$_SESSION['status']:'';
$status = (isset($_POST['Status']))?$_POST['Status']:$status;
if(!empty($status))
{
$_SESSION['paystatus'] = $status;
$w .= " and Status='$status'";
}
// page number calculation
if(empty($pageno)) $pageno = 1;
$perpage = 5;
$start = ($pageno-1)*$perpage;
// getting total no rows
$query = "select * from users where 1 $w";
$rett = mysql_query($query,$con);
$totrows = $mysql_num_rows($rett);
$query = "select * from users where 1 $w limit $start, $perpage";
$ret = $mydb->query($query);
$rs = $mydb->result_array($ret);
$i=$start+1;
if($mydb->num_rows($ret)>0)
{
?>
<table width="100%" cellpadding="0" cellspacing="0" border="0" class="tabgray" >
<tr><th>Sno</th><th>Username</th><th>email</th><th>Status</th></tr>
<? foreach($rs as $r) { ?>
<tr><td><?php echo $i; ?></td><td><?php echo $r['username']; ?></td><td><?php echo $r['email'] ?></td><td><?php echo $r['status']; ?></td></tr>
<?
$i++; }}
?>
</table>
<?php
// Pagination Links
$nopages = floor($totrows/$perpage)+(($totrows%$perpage)?1:0);
$lfrom = ($pageno>3)?$pageno-3:1;
$lto = ($pageno+5<$nopages)?$pageno+5:$nopages;
?>
<div>
<div class="pagination" style="float:left;">
<?php if($lfrom!=1) { ?><span class="btn" onclick="getUser(1);">1</span><strong>...</strong><?php } ?>
<?php for($li=$lfrom;$li<$lto;$li++){
$cls = ($pageno==$li)?'btnsel':'btn';
?>
<span class="<?php echo $cls; ?>" onclick="getUser(<?php echo $li; ?>);"><?php echo $li; ?></span>
<?php } ?>
<?php if($nopages>3){ ?><strong>...</strong><span class="btn" onclick="getUser(<?php echo $nopages; ?>);"><?php echo $nopages; ?></span> <?php } ?>
</div>
</div>
</div>
<script type="text/javascript">
getUser(1);
</script>