function select_page($QueryStr,$page,$pageSize)
{
$R=@mssql_query($QueryStr);
if($R) {
$totalPage = ceil(mssql_num_rows($R)/$pageSize);
$this->total_page = $totalPage;
if(!$page||$page<=0) $page=1; $this->page_amount=1;
if($page>$totalPage) $page=$totalPage;
$begin = ($page-1) * $pageSize;
$ReArr=array();
$index=0;
if($pageSize>0) mssql_data_seek($R,$begin);
while($ResultArr=@mssql_fetch_array($R)){
if($pageSize>0)
if($index>$pageSize-1) break;
$ReArr[$index]=$ResultArr;
$index++;
}
return $ReArr;
} else
return false;
}
对照下
{
$R=@mssql_query($QueryStr);
if($R) {
$totalPage = ceil(mssql_num_rows($R)/$pageSize);
$this->total_page = $totalPage;
if(!$page||$page<=0) $page=1; $this->page_amount=1;
if($page>$totalPage) $page=$totalPage;
$begin = ($page-1) * $pageSize;
$ReArr=array();
$index=0;
if($pageSize>0) mssql_data_seek($R,$begin);
while($ResultArr=@mssql_fetch_array($R)){
if($pageSize>0)
if($index>$pageSize-1) break;
$ReArr[$index]=$ResultArr;
$index++;
}
return $ReArr;
} else
return false;
}
对照下
$pagesize=2;//每页要显示的记录数
$rs->pagesize=$pagesize; //定义每页记录数变量
$totalsize=$rs->recordCount(); //定义记录总数变量
$totalpage=$rs->pagecount(); //定义总页数变量
if ($TotalPage<1 ) {$TotalPage=1;} //判断页数小于1就是设定首页
$nowpage=1;
if (is_numeric(trim($_GET["page"])) ){$nowpage=trim($_GET["page"]);}
if ($nowpage<1 || $nowpage=="" ) {$nowpage=1;}
if ($nowpage>$totalpage ) {$nowpage=$totalpage;} if (! $rs->eof && ! $rs->bof )
{
$rs->AbsolutePage=$nowpage ;
$i=1;
while (! $rs->eof && ! $rs->bof && $i<=$rs->pagesize)
{
?>
省略
................................
<?
$i=$i+1;
$rs->movenext();
}
}
?>
成功 谢谢鼓励,我会努力的