|
<title>php+ajax Pagination Demo </title>
<meta http-equiv= "Content-type" content= "text/html; Charset=utf-8 "/>
<script language= "javascript" src= "Ajaxpage.js" ></script>
<div id= "Result" >
<?php
$terry =mysql_connect ("localhost", "root", "") or Die ("Connection Database failed:". Mysql_error ());
mysql_select_db ("Ajaxtest", $terry);
mysql_query ("Set NAMES ' UTF8 '");
$result =mysql_query ("SELECT * from Tb_user");
$total =mysql_num_rows ($result) or Die (Mysql_error ());
$page =isset ($_get[' page ')? Intval ($_get[' page '): 1;
$page _size=3;
$url = ' index.php ';
$pagenum =ceil ($total/$page _size);
$page =min ($pagenum, $page);
$prepage = $page-1;
$nextpage = ($page = = $pagenum 0: $page + 1);
$pageset = ($page-1) * $page _size;
$pagenav = ';
$pagenav. = "Show <font color= ' Red ' >". ($total? ($pageset + 1): 0). " -". Min ($pageset +5, $total)." </font> Records total <b><font color= ' yellow ' > '. $total. " </font></b> Records is now the first <b><font color= ' Blue ' > '. $page. " </font></b> page ";
if ($page <=1)
$pagenav. = "<a style=cursor:not-allowed;> home </a> ";
Else
$pagenav. = "<a onclick=javascript:dopage (' result ', ' $url? page=1 ') style=cursor:pointer;> home </a>& nbsp; ";
if ($prepage)
$pagenav. = "<a onclick=javascript:dopage (' result ', ' $url? page= $prepage ') style=cursor:pointer;> previous page </a> ";
Else
$pagenav. = "<a style=cursor:not-allowed;> prev </a> ";
if ($nextpage)
$pagenav. = "<a onclick=javascript:dopage (' result ', ' $url? page= $nextpage ') style=cursor:pointer;> next page </a > ";
Else
$pagenav. = "<a style=cursor:not-allowed;> next page </a> ";
if ($pagenum)
$pagenav. = "<a onclick=javascript:dopage (' result ', ' $url? page= $pagenum ') style=cursor:pointer;> last </a> ";
Else
$pagenav. = "<a style=cursor:not-allowed;> last </a> ";
$pagenav. = "Total". $pagenum. " Page ";
if ($page > $pagenum) {
echo "Error: no this page". $page;
Exit ();
}
?>
<table align= "center" border= "2" width= ">"
<tr bgcolor= "#cccccc" align= "Center" >
<td> User name </td>
<td> User Password </td>
</tr>
<?php
$info =mysql_query ("SELECT * from Tb_user" desc limit $pageset, $page _size ");
while ($array =mysql_fetch_array ($info)) {
?>
<TR align= "center" >
<td><?php echo $array [' id '];? ></td>
<td><?php echo $array [' username '];? ></td>
</tr>
<?php
}
?>
</table>
<?php
echo "<p align=center> $pagenav </p>";
?>
</div>
|