<?php
class FenyePage{
public $pageSize=6;
public $res_array;
public $rowCount;
public $pageNow=1;
public $pageCount;
public $navigate;
public $page_whole=10;
public $gotoUrl;
}
?>
这是一个类,暂时写public
// 考虑分页情况的查询,这是一个比较通用的分页
//sql1表示查询的结果集的sql
//sql2表示查询到总数的sql
// $fenyePage是一个bean
public function exectue_dql_fenye($sql1, $sql2, $fenyePage) {
$res = mysql_query ( $sql1, $this->conn ) or die ( mysql_error () );
//查询到结果集,用数组装数据来释放结果集的内存
while ( $row = mysql_fetch_assoc ( $res ) ) {
$arr [] = $row;
}
mysql_free_result ( $res );
$res2 = mysql_query ( $sql2, $this->conn ) or die ( mysql_error () );
if ($row = mysql_fetch_row ( $res2 )) {
$fenyePage->pageCount = ceil ( $row [0] / $fenyePage->pageSize );
$fenyePage->rowCount = $row [0];
}
mysql_free_result ( $res2 );
//上一页,下一页的显示
$navigate = "";if ($fenyePage->pageNow > 1) {
$prePage = $fenyePage->pageNow - 1;
$navigate = "<a href='empList.php?pageNow=$prePage'>上一页</a> ";
}
if ($fenyePage->pageNow < $fenyePage->pageCount) {
$nextPage = $fenyePage->pageNow + 1;
$navigate .= "<a href='empList.php?pageNow=$nextPage'>下一页</a> ";
}
// 【1】【2】【3】页码显示
//有点逻辑性
$start = floor ( ($fenyePage->pageNow - 1) / $fenyePage->page_whole ) * $fenyePage->page_whole + 1;
$index = $start;
if ($fenyePage->pageNow >$fenyePage->page_whole) {
$navigate .= " <a
href='empList.php?pageNow=" . ($start - 1) . "'><<</a>";
}
for(; $start < $index + $fenyePage->page_whole; $start ++) {
$navigate .= "<a
href='empList.php?pageNow=$start'>[$start]</a>";
}
$navigate .= " ";
$navigate.="<a href='empList.php?pageNow=$start'>>></a>"; // 显示当前页和共有多少页 echo
$navigate.=" 当前页{$fenyePage->pageNow}/共{$fenyePage->pageCount}页"; // 跳转到 echo"<br/><br/>";
$fenyePage->navigate = $navigate;
$fenyePage->res_array = $arr;
}