类:
<?php
class pager {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit;
private $uri;
private $pageNum; //页数
private $config=array('header'=>"个记录", "prev"=>"上一页", "next"=>"下一页", "first"=>"首 页", "last"=>"尾 页");
private $listNum=5;
/*
* $total
* $listRows
*/
public function __construct($total, $listRows=12, $pa=""){
$this->total=$total;
$this->listRows=$listRows;
$this->uri=$this->getUri($pa);
$this->page=!empty($_GET["page"]) ? $_GET["page"] : 1;
$this->pageNum=ceil($this->total/$this->listRows);
$this->limit=$this->setLimit();
} private function setLimit(){
return "Limit ".($this->page-1)*$this->listRows.", {$this->listRows}";
} private function getUri($pa){
$url=$_SERVER["REQUEST_URI"].(strpos($_SERVER["REQUEST_URI"], '?')?'':"?").$pa;
echo $url;
$parse=parse_url($url); if(isset($parse["query"])){
parse_str($parse['query'],$params);
unset($params["page"]);
$url=$parse['path'].'?'.http_build_query($params);
} return $url;
} private function __get($args){
if($args=="limit")
return $this->limit;
else
return null;
} private function start(){
if($this->total==0)
return 0;
else
return ($this->page-1)*$this->listRows+1;
} private function end(){
return min($this->page*$this->listRows,$this->total);
} private function first(){
if($this->page==1)
$html.='';
else
$html.=" <a href='{$this->uri}&page=1'>{$this->config["first"]}</a> "; return $html;
} private function prev(){
if($this->page==1)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->page-1)."'>{$this->config["prev"]}</a> "; return $html;
} private function pageList(){
$linkPage="";
$inum=floor($this->listNum/2);
for($i=$inum; $i>=1; $i--){
$page=$this->page-$i; if($page<1)
continue; $linkPage.=" <a href='{$this->uri}&page={$page}'>{$page}</a> "; }
$linkPage.=" {$this->page} ";
for($i=1; $i<=$inum; $i++){
$page=$this->page+$i;
if($page<=$this->pageNum)
$linkPage.=" <a href='{$this->uri}&page={$page}'>{$page}</a> ";
else
break;
} return $linkPage;
} private function next(){
if($this->page==$this->pageNum)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->page+1)."'>{$this->config["next"]}</a> "; return $html;
} private function last(){
if($this->page==$this->pageNum)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->pageNum)."'>{$this->config["last"]}</a> "; return $html;
} private function goPage(){
return ' <input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>'.$this->pageNum.')?'.$this->pageNum.':this.value;location=\''.$this->uri.'&page=\'+page+\'\'}" value="'.$this->page.'" style="width:25px"><input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>'.$this->pageNum.')?'.$this->pageNum.':this.previousSibling.value;location=\''.$this->uri.'&page=\'+page+\'\'"> ';
}
function fpage($display=array(0,1,2,3,4,5,6,7,8)){
$html[0]=" 共有<b>{$this->total}</b>{$this->config["header"]} ";
$html[1]=" 每页显示<b>".($this->end()-$this->start()+1)."</b>条,本页<b>{$this->start()}-{$this->end()}</b>条 ";
$html[2]=" <b>{$this->page}/{$this->pageNum}</b>页 ";
$html[3]=$this->first();
$html[4]=$this->prev();
$html[5]=$this->pageList();
$html[6]=$this->next();
$html[7]=$this->last();
$html[8]=$this->goPage();
$fpage='';
foreach($display as $index){
$fpage.=$html[$index];
} return $fpage; }
}我写的php:
<?
$sql="SELECT * FROM ma_program,ma_programcategory
WHERE ma_program.ProgramID=ma_programcategory.ProgramID
AND ma_programcategory.CategoryParentID=".$CategoryID."
ORDER BY ma_programcategory.CategoryID DESC";
require('pager.php');
$total=mysql_num_rows(mysql_query($sql))
$pager=new __construct($total);
$result=mysql_query($sql)
while($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
echo"<div class='film'>
<span><a href='detail.php?ProgramID={$row['ProgramID']}'><img src='http://localhost/{$row['ProgramPicture']}' class='img_film'/></a>
<br>
<a href='detail.php?ProgramID={$row['ProgramID']}' class='film_font'>{$row['ProgramName']}</a></span>
</div>
";
}?>
感觉自己像是胡写的 麻烦帮忙给下正解 应该怎么写 我不知道如何打印分页 因为我看分页类里面有好多的function 蛋疼啊 跪求正解 php中如何写 谢···
<?php
class pager {
private $total; //数据表中总记录数
private $listRows; //每页显示行数
private $limit;
private $uri;
private $pageNum; //页数
private $config=array('header'=>"个记录", "prev"=>"上一页", "next"=>"下一页", "first"=>"首 页", "last"=>"尾 页");
private $listNum=5;
/*
* $total
* $listRows
*/
public function __construct($total, $listRows=12, $pa=""){
$this->total=$total;
$this->listRows=$listRows;
$this->uri=$this->getUri($pa);
$this->page=!empty($_GET["page"]) ? $_GET["page"] : 1;
$this->pageNum=ceil($this->total/$this->listRows);
$this->limit=$this->setLimit();
} private function setLimit(){
return "Limit ".($this->page-1)*$this->listRows.", {$this->listRows}";
} private function getUri($pa){
$url=$_SERVER["REQUEST_URI"].(strpos($_SERVER["REQUEST_URI"], '?')?'':"?").$pa;
echo $url;
$parse=parse_url($url); if(isset($parse["query"])){
parse_str($parse['query'],$params);
unset($params["page"]);
$url=$parse['path'].'?'.http_build_query($params);
} return $url;
} private function __get($args){
if($args=="limit")
return $this->limit;
else
return null;
} private function start(){
if($this->total==0)
return 0;
else
return ($this->page-1)*$this->listRows+1;
} private function end(){
return min($this->page*$this->listRows,$this->total);
} private function first(){
if($this->page==1)
$html.='';
else
$html.=" <a href='{$this->uri}&page=1'>{$this->config["first"]}</a> "; return $html;
} private function prev(){
if($this->page==1)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->page-1)."'>{$this->config["prev"]}</a> "; return $html;
} private function pageList(){
$linkPage="";
$inum=floor($this->listNum/2);
for($i=$inum; $i>=1; $i--){
$page=$this->page-$i; if($page<1)
continue; $linkPage.=" <a href='{$this->uri}&page={$page}'>{$page}</a> "; }
$linkPage.=" {$this->page} ";
for($i=1; $i<=$inum; $i++){
$page=$this->page+$i;
if($page<=$this->pageNum)
$linkPage.=" <a href='{$this->uri}&page={$page}'>{$page}</a> ";
else
break;
} return $linkPage;
} private function next(){
if($this->page==$this->pageNum)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->page+1)."'>{$this->config["next"]}</a> "; return $html;
} private function last(){
if($this->page==$this->pageNum)
$html.='';
else
$html.=" <a href='{$this->uri}&page=".($this->pageNum)."'>{$this->config["last"]}</a> "; return $html;
} private function goPage(){
return ' <input type="text" onkeydown="javascript:if(event.keyCode==13){var page=(this.value>'.$this->pageNum.')?'.$this->pageNum.':this.value;location=\''.$this->uri.'&page=\'+page+\'\'}" value="'.$this->page.'" style="width:25px"><input type="button" value="GO" onclick="javascript:var page=(this.previousSibling.value>'.$this->pageNum.')?'.$this->pageNum.':this.previousSibling.value;location=\''.$this->uri.'&page=\'+page+\'\'"> ';
}
function fpage($display=array(0,1,2,3,4,5,6,7,8)){
$html[0]=" 共有<b>{$this->total}</b>{$this->config["header"]} ";
$html[1]=" 每页显示<b>".($this->end()-$this->start()+1)."</b>条,本页<b>{$this->start()}-{$this->end()}</b>条 ";
$html[2]=" <b>{$this->page}/{$this->pageNum}</b>页 ";
$html[3]=$this->first();
$html[4]=$this->prev();
$html[5]=$this->pageList();
$html[6]=$this->next();
$html[7]=$this->last();
$html[8]=$this->goPage();
$fpage='';
foreach($display as $index){
$fpage.=$html[$index];
} return $fpage; }
}我写的php:
<?
$sql="SELECT * FROM ma_program,ma_programcategory
WHERE ma_program.ProgramID=ma_programcategory.ProgramID
AND ma_programcategory.CategoryParentID=".$CategoryID."
ORDER BY ma_programcategory.CategoryID DESC";
require('pager.php');
$total=mysql_num_rows(mysql_query($sql))
$pager=new __construct($total);
$result=mysql_query($sql)
while($row=mysql_fetch_array($result,MYSQL_ASSOC))
{
echo"<div class='film'>
<span><a href='detail.php?ProgramID={$row['ProgramID']}'><img src='http://localhost/{$row['ProgramPicture']}' class='img_film'/></a>
<br>
<a href='detail.php?ProgramID={$row['ProgramID']}' class='film_font'>{$row['ProgramName']}</a></span>
</div>
";
}?>
感觉自己像是胡写的 麻烦帮忙给下正解 应该怎么写 我不知道如何打印分页 因为我看分页类里面有好多的function 蛋疼啊 跪求正解 php中如何写 谢···
$total=mysql_num_rows(mysql_query($sql))
$pager=new pager($total);//some code here
echo $pager->fpage();
后面的echo什么意思 能说一下么 不明白你写的做什么用 先去吃饭马上回来
$pageNum = 1;if(isset($_GET['page']))
{
$pageNum = $_GET['page'];
}
$offset = ($pageNum - 1) * $rowsPerPage;//SQL举例
$sql="SELECT * FROM delaycalllogs ORDER BY id DESC"." LIMIT $offset, $rowsPerPage";
$rs=odbc_exec($conn, $sql);/*
*
*放置需要分页显示的第一页的内容
*
*/
//检查数据库里一共有多少条数据
$query="SELECT COUNT(id) AS numrows FROM delaycalllogs";$numrows = odbc_exec($conn,$query);
$numrows = odbc_result($numrows,"numrows"); //计算一共有几页
$maxPage = ceil($numrows/$rowsPerPage);//生成每一页的链接
$nav = '';for($page = 1; $page <= $maxPage; $page++)
{
if ($page == $pageNum)
{
$nav .= " $page ";
}
else
{
$nav .= " <a href=\"cl_details.php?page=$page\">$page</a> ";
}
}//////////////////////////////////////////////////////////////////
if ($pageNum > 1)
{
$page = $pageNum - 1;
$prev = " <a href=\"cl_details.php?page=$page\">[Previous page]</a> "; $first = " <a href=\"cl_details.php?page=1\">[First Page]</a> ";
}
else
{
$prev = ' ';
$first = ' ';
}if ($pageNum < $maxPage)
{
$page = $pageNum + 1;
$next = " <a href=\"cl_details.php?page=$page\">[Next page]</a> "; $last = " <a href=\"cl_details.php?page=$maxPage\">[Last Page]</a> ";
}
else
{
$next = ' ';
$last = ' ';
}//生成页面导航链接
echo "<div class=\"paging\">".$first . $prev . $nav . $next . $last."</div>";
有个缺点,当页数太多的时候会全部显示出来。。