php分页代码

php分页代码

include "conn.inc";
//没页显示记录数
$PageSize = 10;
$StartRow = 0; //开始显示记录的编号
//获取需要显示的页数，由用户提交
if(empty($_GET['PageNo'])){ //如果为空，则表示第1页
if($StartRow == 0){
$PageNo = $StartRow + 1; //设定为1
}
}else{
$PageNo = $_GET['PageNo']; //获得用户提交的页数
$StartRow = ($PageNo - 1) * $PageSize; //获得开始显示的记录编号
}

//因为显示页码的数量是动态变化的
//假如总共有一百页，则不可能同时显示100个链接
//而是根据当前的页数显示一定数量的页面链接
//设置显示页码的初始值
if($PageNo % $PageSize == 0){
$CounterStart = $PageNo - ($PageSize - 1);
}else{
$CounterStart = $PageNo - ($PageNo % $PageSize) + 1;
}

//显示页码的最大值
$CounterEnd = $CounterStart + ($PageSize - 1);
?>







$TRecord = mysql_query("SELECT * FROM news");
$result = mysql_query("SELECT title,addtime,id FROM news ORDER BY id DESC LIMIT $StartRow,$PageSize");

//获取总记录数
$RecordCount = mysql_num_rows($TRecord);

//获取总页数
$MaxPage = $RecordCount % $PageSize;
if($RecordCount % $PageSize == 0){
$MaxPage = $RecordCount / $PageSize;
}else{
$MaxPage = ceil($RecordCount / $PageSize);
}
?>

分页显示记录

$i = 1;
while($row = mysql_fetch_array($result, MYSQL_NUM)) {
$bil = $i + ($PageNo-1)*$PageSize;
$lei=$row[2]
?>






$i++;
}?>

记录序号	文章标题	所属类别	修改
		$sql2="select * from class where id=$lei"; $result2=mysql_query($sql2,$conn); $row=mysql_fetch_array($result2); $classname=$row['classname']; mysql_free_result($result2); ?>	修改 删除

echo ""; //显示第一页或者前一页的链接 // 如果当前页不是第1页，则显示第一页和前一页的链接 if($PageNo != 1){ $PrevStart = $PageNo - 1; print "First : "; print "Previous "; } print " [ "; $c = 0; //打印需要显示的页码 for($c=$CounterStart;$c<=$CounterEnd;$c++){ if($c < $MaxPage){ if($c == $PageNo){ if($c % $PageSize == 0){ print "$c "; }else{ print "$c ,"; } }elseif($c % $PageSize == 0){ echo "$c "; }else{ echo "$c ,"; }//END IF }else{ if($PageNo == $MaxPage){ print "$c "; break; }else{ echo "$c "; break; }//END IF }//END IF }//NEXT echo "] "; if($PageNo < $MaxPage){ //如果当前页不是最后一页，则显示下一页链接 $NextPage = $PageNo + 1; echo "Next"; } //同时如果当前页补上最后一页，要显示最有一页的链接 if($PageNo < $MaxPage){ $LastRec = $RecordCount % $PageSize; if($LastRec == 0){ $LastStartRecord = $RecordCount - $PageSize; } else{ $LastStartRecord = $RecordCount - $LastRec; } print " : "; echo "Last"; } echo ""; ?>

mysql_free_result($result);
mysql_free_result($TRecord);
?>