PHP 分页代码

蓝
PHP编程
阅读:3762
评论:0

Calchas 发表于 2009, April 3, 5:22 PM

PHP代码

require_once("Pagination.class.php");
//连接数据库
$dbconn = mssql_connect($webdbhost,$webdbuser,$webdbpwd) or die("服务器连接失败.");
mssql_select_db($webdbname) or die ("数据库连接失败");
$numrs = mssql_query($strQueryCount) or die("数据查询失败");
$numrow = mssql_fetch_row($numrs);
$num = $numrow[0]; //总记录
$result = mssql_query( $strQuery ) or die ("数据查询失败");
$p = new Pagination();
$p->setTotal($num);
$p->initialize();
$start = $p->getStartNumber();
$end = $p->getEndNumber();
for( $i = $start; $i < $end; $i++ ){
//echo "<tr><td>".$results[$i][0]."</td><td>".$results[$i]["3"]."</td><td>".$results[$i][5]." </td></tr>";
echo "<tr><td>".mssql_result($result,$i,"GeneralID")."</td><td>".mssql_result($result,$i,"Title")."</td><td>".mssql_result($result,$i,"InputTime")." </td></tr>";
echo "";
}
echo "<tr><td colspan='10'>";
echo $p->getFirstPage();
echo $p->getPreviousPage();
echo $p->getNumberBar();
echo $p->getNextPage();
echo $p->getLastPage();
echo $p->getJumpForm();
echo "</td></tr>";
mssql_free_result($result);
mssql_close($dbconn);

Pagination.class.php

PHP代码

class Pagination{
/**
* 总条目数
*/
private $total;
/**
* 每页显示条目数
*/
private $pageSize = 20;
/**
* 总页数
*/
private $sumPageNumber;
/**
* 当前页数
*/
private $currentlyPageNumber;
/**
* 结果集开始条目数
*/
private $startNumber;
/**
* 结果集结束条目数
*/
private $endNumber;
/**
* 翻页时的标识
*/
private $pageNumberFlag = "page";
/**
* 翻页时需要额外带的参数
*/
private $linksParameter;
/**
* 数字翻页条的数量
*/
private $numberBar = 6;
/**
* 首页翻页标识
*/
private $firstPageFlag = "[首页]";
/**
* 尾页翻页标识
*/
private $lastPageFlag = "[尾页]";
/**
* 上页翻页标识
*/
private $previousPageFlag = "[上页]";
/**
* 下页翻页标识
*/
private $nextPageFlag = "[下页]";
/**
* 初始化，在SET相关参数后执行，执行后才可以调用GET
* @name initialize
* @return void
*/
function initialize(){
$this->sumPageNumber = ceil( $this->total / $this->pageSize );
if( 0 == $this->sumPageNumber )$this->sumPageNumber++;
if (isset($_REQUEST[$this->pageNumberFlag]) && is_numeric($_REQUEST[$this->pageNumberFlag]))
{
$this->currentlyPageNumber = $_REQUEST[$this->pageNumberFlag];
}
else
{
$this->currentlyPageNumber = 1;
}
if ( ( $this->currentlyPageNumber == "" ) ||
( $this->currentlyPageNumber <= 0 ) ||
( $this->currentlyPageNumber > $this->sumPageNumber )
){
$this->currentlyPageNumber = 1;
}
$this->startNumber =
$this->currentlyPageNumber * $this->pageSize - $this->pageSize;
$this->endNumber = $this->currentlyPageNumber * $this->pageSize;
if( $this->total < $this->endNumber ){
$this->endNumber = $this->total;
}
}
/**
* 得到含有连接的首页翻页标识
* @return string
*/
function getFirstPage(){
if( 1 == $this->currentlyPageNumber){
return $this->firstPageFlag . " \n ";
}else{
return "<a href=\"?" . $this->pageNumberFlag . "=1". $this->linksParameter ."\">" . $this->firstPageFlag . "</a> \n";
}
}
/**
* 得到含有连接的尾页翻页标识
* @return string
*/
function getLastPage(){
if( $this->currentlyPageNumber != $this->sumPageNumber && 0 != $this->sumPageNumber ){
return "<a href=\"?" . $this->pageNumberFlag . "=" . $this->sumPageNumber . $this->linksParameter . "\">" . $this->lastPageFlag . "</a> \n";
}else{
return $this->lastPageFlag . " \n ";
}
}
/**
* 得到含有连接的上页翻页标识
* @return string
*/
function getPreviousPage(){
if( $this->currentlyPageNumber > 1 ){
return "<a href=\"?" . $this->pageNumberFlag . "=" . ( $this->currentlyPageNumber - 1 ) . $this->linksParameter ."\">" . $this->previousPageFlag . "</a> \n";
}else{
return $this->previousPageFlag . " \n";
}
}
/**
* 得到含有连接的下页翻页标识
* @return string
*/
function getNextPage(){
if( $this->currentlyPageNumber < $this->sumPageNumber && $this->sumPageNumber != 0){
return "<a href=\"?" . $this->pageNumberFlag . "=" . ( $this->currentlyPageNumber + 1 ) . $this->linksParameter ."\">" . $this->nextPageFlag . "</a> \n";
}else{
return $this->nextPageFlag . " \n";
}
}
/**
* 得到翻页的数字条
* @return string
*/
function getNumberBar(){
if( 0 == ( $this->numberBar % 2 ) ){
$this->numberBar++;
}
$scope = ( $this->numberBar - 1 )/2;
$start = $this->currentlyPageNumber - $scope;
$end = $this->currentlyPageNumber + $scope;
if( $start < 1 ){
$start = 1;
}
if( $end > $this->sumPageNumber ){
$end = $this->sumPageNumber;
if( $this->sumPageNumber > $this->numberBar ){
$start = $this->sumPageNumber - $this->numberBar + 1;
}
}
if( 1 == $start && $this->sumPageNumber > $this->numberBar ){
$end = $this->numberBar;
}
if( $start == $end ){
return "<font color=\"red\">[1]</font>\n";
}
$nb = "";
for( $i=$start; $i<=$end; $i++ ){
if( $i == $this->currentlyPageNumber ){
$nb .= "<font color=\"red\">[" . $i . "]</font> \n";
continue;
}
$nb .= "<a href=\"?" . $this->pageNumberFlag . "=" . $i . $this->linksParameter . "\">[" . $i . "]</a> \n";
}
return $nb;
}
/**
* 得到可以跳转的表单框，GET方式传递
* @return string
*/
function getJumpForm(){
$jf = "<script language=\"javascript\">\n";
$jf .= "function _checkForm(){\n";
$jf .= "var a = document.getElementById(\"" . $this->pageNumberFlag . "\").value;\n";
$jf .= "if( a > " . $this->sumPageNumber . " || a <1 || a == " . $this->currentlyPageNumber . " ){\n";
$jf .= "return false;}else{\n";
$jf .= "window.location.href=\"?" . $this->pageNumberFlag . "=\"+a+\"" . $this->linksParameter . "\";";
$jf .= "}\n}\n</script>\n";
$jf .= "<input class=\"selectButtonCss\" id=\"" . $this->pageNumberFlag . "\" name=\"" . $this->pageNumberFlag . "\" tpye=\"text\" size=\"3\" value=\"" . $this->currentlyPageNumber . "\">\n";
$jf .= "<input type=\"button\" name=\"button\" value=\"GO\" onClick=\"return _checkForm()\" class=\"ButtonCss\">\n";
return $jf;
}
/**
* 得到结果集的开始数
* @return int
*/
function getStartNumber(){
return $this->startNumber;
}
/**
* 得到结果集的结束数
* @return int
*/
function getEndNumber(){
return $this->endNumber;
}
/**
* 得到当前页数
* @return string
*/
function getCurrentlyPageNumber(){
return $this->currentlyPageNumber;
}
/**
* 得到总页数
* @return string
*/
function getSumPageNumber(){
return $this->sumPageNumber;
}
/**
* 得到翻页时需要的所有参数
* @return string
*/
function getAllLinksParameter(){
$page = emptyempty($_GET[$this->pageNumberFlag])?0:$_GET[$this->pageNumberFlag];
return $this->pageNumberFlag."=".$page.$this->linksParameter;
}
/**
* 设定总的结果集条目数
* @return void
*/
function setTotal( $total ){
$this->total = $total;
}
/**
* 设定每页需要显示的结果集条目数
* @return void
*/
function setPageSize( $pageSize ){
$this->pageSize = $pageSize;
}
/**
* 设定翻页时传递页数的变量名称
* @return void
*/
function setPageNumberFlag( $pageNumberFlag ){
$this->pageNumberFlag = $pageNumberFlag;
}
/**
* 设定翻页时需要额外传递的变量
* @return void
*/
function setLinksParameter( $linksParameter ){
$this->linksParameter = $linksParameter;
}
/**
* 设定首页翻页标识
* @return void
*/
function setFirstPageFlag( $firstPageFlag ){
$this->firstPageFlag = $firstPageFlag;
}
/**
* 设定尾页翻页标识
* @return void
*/
function setLastPageFlag( $lastPageFlag ){
$this->lastPageFlag = $lastPageFlag;
}
/**
* 设定上页翻页标识
* @return void
*/
function setPreviousPageFlag( $previousPageFlag ){
$this->previousPageFlag = $previousPageFlag;
}
/**
* 设定下页翻页标识
* @return void
*/
function setNextPageFlag( $nextPageFlag ){
$this->nextPageFlag = $nextPageFlag;
}
/**
* 设定翻页数字条所显示的数量
* @return void
*/
function setNumberBar( $numberBar ){
$this->numberBar = $numberBar;
}
function __set($name,$val){
echo "不能在Pagination.class.php中SET 属性 <font color=\"red\">" .$name. "</font>";
}
function __get($name){
echo "不能在Pagination.class.php中GET 属性 <font color=\"red\">" .$name. "</font>";
}
function __call($name,$arguments){
echo "Pagination.class.php中不存在 function <font color=\"red\">" .$name. "</font>";
}
}

标签: php

相关文章： (最多只显示5条记)

PHP读MSSQL日期问题 (浏览：4428, 评论：1)
Undefined index 错误 (浏览：3917, 评论：0)
php5 无法连接 mssql2005 (浏览：4771, 评论：1)

引用：

发表评论：( 你的参与是我最大的动力! )

金沙水拍云崖暖 - WEB程序开发

PHP 分页代码

日志分类

搜索文章/评论

最新评论 (» 查看更多...)