有点乱有空再来封装一下,有点乱
//处理页数
$pagesize=30; //每页显示条数
$res = mysql_query("SELECT count(*) FROM PMT_RESULT");
$myrow = mysql_fetch_array($res);
$numrows=$myrow[0]; //总条数
$pages=intval($numrows/$pagesize); //总页数
if ($numrows%$pagesize)
$pages++;
if(isset($_GET['page'])){
$page=intval($_GET['page']);//非首次访问的页数
}
else{
$page=1;//首次访问的页数
}
//数据处理
$offset=$pagesize*($page-1);
$sql="select * from PMT_RESULT RESULT_TYPE like '%".$input."%' order by RESULT_DATE desc limit $offset,$pagesize";
$result = mysql_query($sql);
//页面跳转处理
echo "<form action='report1.php' method='get'> ";
echo "<div align='center' class='page'>共".$numrows."条记录 共".$pages."页 ";
echo "<a href='report1.php?page=1'>【首页】</a> ";
if ($page>1){
$prev=$page-1;
echo "<a href='report1.php?page=".$prev."'>【上一页】</a> ";
}
echo "当前第".$page."页 ";
if ($page<$pages){
$next=$page+1;
echo "<a href='report1.php?page=".$next."'>【下一页】</a> ";
}
echo "<a href='report1.php?page=".$pages."'>【尾页】</a> ";
echo "跳转到<input name='page' id='page' type='text' οnblur='check(this)' style='width:15px'/>页<input name='' type='submit' value='跳转' οnclick='check(this)' /></div>";
echo "</form>";
JS代码,处理跳转用
function check() {
var id = document.getElementById("page");
var p=id.value;
if (p<1 || p > <?php echo $pages;?>||p==''){
alert("请输入1-<?php echo $pages;?>的页码!");
return false;
}else return true;