你這個太麻煩 我給你推薦一個
站在用戶的角度思考問題,與客戶深入溝通,找到白山網(wǎng)站設(shè)計與白山網(wǎng)站推廣的解決方案,憑借多年的經(jīng)驗,讓設(shè)計與互聯(lián)網(wǎng)技術(shù)結(jié)合,創(chuàng)造個性化、用戶體驗好的作品,建站類型包括:成都網(wǎng)站制作、成都網(wǎng)站設(shè)計、企業(yè)官網(wǎng)、英文網(wǎng)站、手機端網(wǎng)站、網(wǎng)站推廣、域名注冊、網(wǎng)站空間、企業(yè)郵箱。業(yè)務(wù)覆蓋白山地區(qū)。
?php
class page
{
var $page_name="page";
var $next_page='';//下一頁
var $pre_page='';//上一頁
var $first_page='首頁';//首頁
var $last_page='尾頁';//尾頁
var $pre_bar='';//上一分頁條
var $next_bar='';//下一分頁條
var $format_left='';
var $format_right='';
var $page_webmode='';
/**
* private
*
*/
var $pagebarnum=10;//控制記錄條的個數(shù)。
var $totalpage=0;//總頁數(shù)
var $nowindex=1;//當(dāng)前頁
var $url="";//url地址頭
var $offset=0;
/**
* c*****tructor構(gòu)造函數(shù)
*
* @param array $array['total'],$array['perpage'],$array['nowindex'],$array['url'],$array['ajax']...
*/
function page($array)
{
if(is_array($array)){
if(!array_key_exists('total',$array))$this-error(__FUNCTION__,'need a param of total');
$total=intval($array['total']);
$perpage=(array_key_exists('perpage',$array))?intval($array['perpage']):10;
$nowindex=(array_key_exists('nowindex',$array))?intval($array['nowindex']):'';
$url=(array_key_exists('url',$array))?$array['url']:'';
}else{
$total=$array;
$perpage=10;
$nowindex='';
$url='';
}
if((!is_int($total))||($total0))$this-error(__FUNCTION__,$total.' is not a positive integer!');
if((!is_int($perpage))||($perpage=0))$this-error(__FUNCTION__,$perpage.' is not a positive integer!');
if(!empty($array['page_name']))$this-set('page_name',$array['page_name']);//設(shè)置pagename
$this-_set_nowindex($nowindex);//設(shè)置當(dāng)前頁
$this-_set_url($url);//設(shè)置鏈接地址
$this-totalpage=ceil($total/$perpage);
$this-total=$total;
$this-offset=($this-nowindex-1)*$perpage;
}
/**
* 設(shè)定類中指定變量名的值,如果改變量不屬于這個類,將throw一個exception
*
* @param string $var
* @param string $value
*/
function set($var,$value)
{
if(in_array($var,get_object_vars($this)))
$this-$var=$value;
else {
$this-error(__FUNCTION__,$var." does not belong to PB_Page!");
}
}
/**
* 獲取顯示"下一頁"的代碼
*
* @param string $style
* @return string
*/
function next_page($style='',$nowindex_style='')
{
if($this-nowindex$this-totalpage){
return $this-_get_link($this-_get_url($this-nowindex+1),$this-next_page,$style);
}
return 'span class="'.$nowindex_style.'"'.$this-next_page.'/span';
}
/**
* 獲取顯示“上一頁”的代碼
*
* @param string $style
* @return string
*/
function pre_page($style='',$nowindex_style='')
{
if($this-nowindex1){
return $this-_get_link($this-_get_url($this-nowindex-1),$this-pre_page,$style);
}
return 'span class="'.$nowindex_style.'"'.$this-pre_page.'/span';
}
/**
* 獲取顯示“首頁”的代碼
*
* @return string
*/
function first_page($style='',$nowindex_style='')
{
if($this-nowindex==1){
return 'span class="'.$nowindex_style.'"'.$this-first_page.'/span';
}
return $this-_get_link($this-_get_url(1),$this-first_page,$style);
}
/**
* 獲取顯示“尾頁”的代碼
*
* @return string
*/
function last_page($style='',$nowindex_style='')
{
if($this-nowindex==$this-totalpage){
return 'span class="'.$nowindex_style.'"'.$this-last_page.'/span';
}
return $this-_get_link($this-_get_url($this-totalpage),$this-last_page,$style);
}
function nowbar($style='',$nowindex_style='')
{
$plus=ceil($this-pagebarnum/2);
if($this-pagebarnum-$plus+$this-nowindex$this-totalpage)$plus=($this-pagebarnum-$this-totalpage+$this-nowindex);
$begin=$this-nowindex-$plus+1;
$begin=($begin=1)?$begin:1;
$return='';
for($i=$begin;$i$begin+$this-pagebarnum;$i++)
{
if($i=$this-totalpage){
if($i!=$this-nowindex)
$return.=$this-_get_text($this-_get_link($this-_get_url($i),$i,$style));
else
$return.=$this-_get_text('span class="'.$nowindex_style.'"'.$i.'/span');
}else{
break;
}
$return.="\n";
}
unset($begin);
return $return;
}
/**
* 獲取顯示跳轉(zhuǎn)按鈕的代碼
*
* @return string
*/
function select()
{
$return='select name="PB_Page_Select" onchange="self.location.href=\''.$this-url.'\'+this.opti*****[this.selectedIndex].value "';
for($i=1;$i=$this-totalpage;$i++)
{
if($i==$this-nowindex){
$return.='option value="'.$i.'" selected'.$i.'/option';
}else{
$return.='option value="'.$i.'"'.$i.'/option';
}
}
unset($i);
$return.='/select';
return $return;
}
/**
* 獲取mysql 語句中l(wèi)imit需要的值
*
* @return string
*/
function offset()
{
return $this-offset;
}
/**
* 控制分頁顯示風(fēng)格(你可以增加相應(yīng)的風(fēng)格)
*
* @param int $mode
* @return string
*/
function show($mode=1,$style='',$nowindex_style='')
{
switch ($mode)
{
case '1':
$this-next_page='下一頁';
$this-pre_page='上一頁';
$this-first_page='首頁';
$this-last_page='尾頁';
return $this-first_page($style,$nowindex_style)." ".$this-pre_page($style,$nowindex_style)." ".$this-next_page($style,$nowindex_style)." ".$this-last_page($style,$nowindex_style).' (當(dāng)前第span style="color:#C16012; font-size:12pt;"'.$this-nowindex.'/span頁 共span style="color:#C16012; font-size:12pt;"'.$this-totalpage.'/span頁 span style="color:#C16012; font-size:12pt;"'.$this-total.'/span條記錄)';
break;
case '2':
$this-next_page='下一頁';
$this-pre_page='上一頁';
$this-first_page='首頁';
$this-last_page='尾頁';
return $this-first_page($style,$nowindex_style)." ".$this-pre_page($style,$nowindex_style)." ".$this-next_page($style,$nowindex_style)." ".$this-last_page($style,$nowindex_style).' 第'.$this-select().'頁 (當(dāng)前第span style="color:#C16012; font-size:12pt;"'.$this-nowindex.'/span頁 共span style="color:#C16012; font-size:12pt;"'.$this-totalpage.'/span頁 span style="color:#C16012; font-size:12pt;"'.$this-total.'/span條記錄)';
break;
case '3':
$this-next_page='下一頁';
$this-pre_page='上一頁';
$this-first_page='首頁';
$this-last_page='尾頁';
return $this-pre_page($style,$nowindex_style)." ".$this-nowbar($style,$nowindex_style)." ".$this-next_page($style,$nowindex_style).' (當(dāng)前第span style="color:#C16012; font-size:12pt;"'.$this-nowindex.'/span頁 共span style="color:#C16012; font-size:12pt;"'.$this-totalpage.'/span頁 span style="color:#C16012; font-size:12pt;"'.$this-total.'/span條記錄)';
break;
case '4':
$this-next_page='下一頁';
$this-pre_page='上一頁';
return $this-pre_page($style,$nowindex_style)." ".$this-nowbar($style,$nowindex_style)." ".$this-next_page($style,$nowindex_style).' 第'.$this-select().'頁 (當(dāng)前第span style="color:#C16012; font-size:12pt;"'.$this-nowindex.'/span頁 共span style="color:#C16012; font-size:12pt;"'.$this-totalpage.'/span頁 span style="color:#C16012; font-size:12pt;"'.$this-total.'/span條記錄)';
break;
case '5':
$this-next_page='';
$this-pre_page='';
$this-first_page='';
$this-last_page='';
return $this-first_page($style,$nowindex_style)." ".$this-pre_page($style,$nowindex_style)." ".$this-nowbar($style,$nowindex_style)." ".$this-next_page($style,$nowindex_style)." ".$this-last_page($style,$nowindex_style).' (當(dāng)前第span style="color:#C16012; font-size:12pt;"'.$this-nowindex.'/span頁 共span style="color:#C16012; font-size:12pt;"'.$this-totalpage.'/span頁 span style="color:#C16012; font-size:12pt;"'.$this-total.'/span條記錄)';
break;
case '6':
$pagehtml="div";
if($this-nowindex1)
{
$pagehtml.="span class=\"pagenum-l\"a href=\"{$this-_get_url($this-nowindex-1)}\"img src=\"images/page_up.gif\" //a/span";
}
else
{
$pagehtml.="span class=\"pagenum-l\"img src=\"images/page_up.gif\" //span";
}
$pagehtml.="span class=\"pagenum-c\"";
$pagehtml.="tabletr";
$plus=ceil($this-pagebarnum/2);
if($this-pagebarnum-$plus+$this-nowindex$this-totalpage)$plus=($this-pagebarnum-$this-totalpage+$this-nowindex);
$begin=$this-nowindex-$plus+1;
$begin=($begin=1)?$begin:1;
for($i=$begin;$i$begin+$this-pagebarnum;$i++)
{
if($i=$this-totalpage){
if($i!=$this-nowindex)
$pagehtml.="td a href=\"{$this-_get_url($i)}\"{$i}/a /td";
else
$pagehtml.="td {$i} /td";
}else{
break;
}
$pagehtml.="\n";
}
unset($begin);
$pagehtml.="/tr/table";
$pagehtml.="/span";
if($this-nowindex$this-totalpage)
{
$pagehtml.="span class=\"pagenum-r\"a href=\"{$this-_get_url($this-nowindex+1)}\"img src=\"images/page_down.gif\" //a/span";
}
else
{
$pagehtml.="span class=\"pagenum-r\"img src=\"images/page_down.gif\" //span";
}
$pagehtml.="/div";
return $pagehtml;
break;
}
}
/*----------------private function (私有方法)-----------------------------------------------------------*/
/**
* 設(shè)置url頭地址
* @param: String $url
* @return boolean
*/
function _set_url($url="")
{
if($this-page_webmode!="php"$url!=""){
$this-url=$url;
}
else{
if(!empty($url)){
//手動設(shè)置
$this-url=$url.((stristr($url,'?'))?'':'?').$this-page_name."=";
}else{
//自動獲取
if(empty($_SERVER['QUERY_STRING'])){
//不存在QUERY_STRING時
$this-url=$_SERVER['REQUEST_URI']."?".$this-page_name."=";
}else{
//
if(stristr($_SERVER['QUERY_STRING'],$this-page_name.'=')){
//地址存在頁面參數(shù)
$this-url=str_replace($this-page_name.'='.$this-nowindex,'',$_SERVER['REQUEST_URI']);
$last=$this-url[strlen($this-url)-1];
if($last=='?'||$last==''){
$this-url.=$this-page_name."=";
}else{
$this-url.=''.$this-page_name."=";
}
}else{
//
$this-url=$_SERVER['REQUEST_URI'].''.$this-page_name.'=';
}//end if
}//end if
}//end if
}
}
/**
* 設(shè)置當(dāng)前頁面
*
*/
function _set_nowindex($nowindex)
{
if(empty($nowindex)){
//系統(tǒng)獲取
if(isset($_GET[$this-page_name])){
$this-nowindex=intval($_GET[$this-page_name]);
}
}else{
//手動設(shè)置
$this-nowindex=intval($nowindex);
}
}
/**
* 為指定的頁面返回地址值
*
* @param int $pageno
* @return string $url
*/
function _get_url($pageno=1)
{
if($this-page_webmode=="php"||$this-page_webmode==""){
return $this-url.$pageno;
}
else{
return $this-url.(($pageno==1)?"":"_".$pageno).".".$this-page_webmode;
}
}
/**
* 獲取分頁顯示文字,比如說默認(rèn)情況下_get_text('a href=""1/a')將返回[a href=""1/a]
*
* @param String $str
* @return string $url
*/
function _get_text($str)
{
return $this-format_left.$str.$this-format_right;
}
/**
* 獲取鏈接地址
*/
function _get_link($url,$text,$style=''){
$style=(empty($style))?'':'class="'.$style.'"';
return 'a '.$style.' href="'.$url.'"'.$text.'/a';
}
/**
* 出錯處理方式
*/
function error($function,$errormsg)
{
die('Error in file b'.__FILE__.'/b ,Function b'.$function.'()/b :'.$errormsg);
}
}
?
調(diào)用方法:
?
include("classpage.php");
$queryrow = $DB-query("SELECT * FROM article where article_sortid='$cls' and type='1' ORDER BY article_id DESC");
$rows=$DB-num_rows($queryrow);
$total=$rows;
$pagesize=15;
$currentRow = empty($_GET['page']) ? 0 : ($_GET['page']-1)* $pagesize;
$queryId = $DB-query("SELECT * FROM article where article_sortid='$cls' and type='1' ORDER BY article_id DESC limit $currentRow,$pagesize");
$iiii=1;
while ($a_array=$DB-fetch_array($queryId)) {
?
table width="674" border="0" cellspacing="0" cellpadding="0" height="30px"
tr
td width="54" /td
td width="87" align="center" class="news" style="font-size:12px;"
?php
if($iiii10)
{
echo $iiii;
}
else
{
echo '0'.$iiii;
}
?
/td
td width="371" class="news" style="font-size:12px;"a href="newslist.php?id=?=$a_array[article_id]?"?=$a_array['article_title']?/a/td
td width="73" class="news" style="font-size:12px;"?=$a_array['article_hits']?/td
td width="89" class="news" style="font-size:12px;"?=substr($a_array['article_addtime'],0,10)?/td
/tr
/table
?php
$iiii++;
}
if ($iiii==1) echo "抱歉,沒有搜索到任何信息。";
?
table width="720" border="0" cellspacing="0" cellpadding="0"
tr
td class="dibu" align="center" valign="top"
table width="98%" border="0" align="center" cellpadding="0" cellspacing="0"
tr
td width="52%" height="10" align="center"/td
td width="48%" align="center"/td
/tr
tr
td height="28" colspan="2" align="center" valign="bottom" style="font-size:12px"
?php
$page=new page(array('total'=$total,'perpage'=$pagesize));
$pagehtml=$page-show(6,"page","curr");
echo $pagehtml;
?
這個是調(diào)用方法
$pagehtml=$page-show(6,"page","curr"); 看到這個沒有 里面是6 我調(diào)用的是6這種方法顯示的 里面可以選擇0 ,1, 2, 3, 4, 5, 6, 六中方法分頁顯示不同 具體的你可以試試 我目前用6的比較多點 呵呵
使用GET傳參,再根據(jù)參數(shù)來確定查詢數(shù)據(jù)開始的偏移量,例:
$sql = sprintf('SELECT * FROM t WHERE uid=1 LIMIT %d,10',$_GET['page']);
$_GET['page']決定查詢結(jié)果集開始的序號,然后下一頁的開始序號就是這個值加上每頁顯示的條數(shù)(這里是10).
看了這個代碼,發(fā)現(xiàn)沒有獲取當(dāng)前頁碼的代碼,所以我改了一下,加了個獲取當(dāng)前頁碼的代碼
function?showpagelink($pagesize,$result,$currentpage,$pageleft,$pageright,$phpfile) //分頁顯示函數(shù),參數(shù)分別為每頁記錄數(shù),數(shù)據(jù)集,當(dāng)前頁,左偏移頁面數(shù)量,右偏移頁面數(shù)量,鏈接頁面
{
$totalpage=ceil($totalnum/$pagesize); //計算總頁數(shù)
$currentpage=$_GET['currentpage'];//獲取當(dāng)前頁碼
if($currentpage1)?$page?=?1; //處理頁碼合法性?
if($currentpage$totalpage)?$currentpage?=?$totalpage;
$pagecode='div?class="pagelink"';
if($currentpage!=1)
{
$pagecode.="a?href=\"{$phpfile}?currentpage=1\"/a";//第一頁
$pagecode.="?a?href=\"{$phpfile}?currentpage=".($currentpage-1)."\"/a";//上一頁
}
if(($pagelink=$currentpage-$pageleft)=0)?$pagelink=1;
while($pagelink$currentpage)
{
$pagecode.="?a?href=\"{$phpfile}?currentpage=$pagelink\"span?class='pc'$pagelink/span/a?";
$pagelink++;
}
$pagecode.="?strong$currentpage/strong?";?//輸出當(dāng)前頁
$pagelink=$currentpage+1;
$i=0;
while($pagelink=$totalpage?and?$i$pageright)
{
$pagecode.="?a?href=\"{$phpfile}?currentpage=$pagelink\"span?class='pc'$pagelink/span/a?";
$pagelink++;
$i++;
}
if($currentpage!=$totalpage){
$pagecode.="?a?href=\"{$phpfile}?currentpage=".($currentpage+1)."\"/a";//下一頁
$pagecode.="?a?href=\"{$phpfile}?currentpage=$totalpage\"/a";//最后一頁
}
$pagecode.="?span$currentpage/$totalpage?共為您查到".$totalnum."件商品/span"; //第幾頁,共幾頁
$pagecode.="/div";
echo?$pagecode;
}
function?showpagedetail($pagesize,$query,$currentpage,$conn) //頁面數(shù)據(jù)顯示函數(shù)
{
$limit=intval($pagesize*($currentpage-1));
$query.="?limit?$limit,$pagesize";
$result=mysql_query($query,$conn);
while($info=mysql_fetch_array($result,MYSQL_NUM))
{
echo?"ul?class='pro_con1'";
echo?$info[0];
echo?"li?class='pro_img'a?href='#'?title=''img?src='$info[7]'?width='150'?height='150'?alt='產(chǎn)品圖片'?//a/li";
echo"li?class='pro_name'a?href='#'?title=''?$info[1]/a/li";
?echo"li?class='pro_price'單價:span¥$info[5]/span?銷量:span$info[3]件/span/li";
echo"li?class='pro_custom'ainput?type='submit'?name='$info[0]'?id='$info[0]'?value='產(chǎn)品詳情'?//a/li/ul";
}
$num=mysql_affected_rows();
for($i=1;$i=$num;$i++){
if(@$_REQUEST[$i]){
echo?$i;
$_REQUEST["temp"]=$i;
echo?"scriptlocation.href='product_detail.php'/script";
}?}}
$pagesize=2;
$phpfile="product.php";
if(!@$currentpage=$_GET["currentpage"])?$currentpage=1;
$pageleft=1;
$pageright=1;
showpagedetail($pagesize,$query,$currentpage,$conn);
$num=mysql_affected_rows();
for($i=1;$i=$num;$i++){
if(@$_REQUEST[$i]){
echo?$i;
$_REQUEST["temp"]=$i;
echo?"scriptlocation.href='product_detail.php'/script";
}?}
你可以先試試這個
$page=$_GET['page'];
echo?"a?href=page_affiche.php?page=".$page-1."上一頁/anbsp;";
onchange='window.location=\"$url?page=\"+this.value'
字符解析,"是特殊字符。用\轉(zhuǎn)成字符
htmlhead
title分頁示例(php/title
meta http-equiv="Content-Type" content="text/html; charset=gb2312"
/head
body
?php
$pagesize=10; //設(shè)定每一頁顯示的記錄數(shù)
$conn=mysql_connect("localhost","root","jrq");
mysql_select_db("sj",$conn);
$rs = mysql_query( "select * from `dw_newsdata`",$conn); //這里有第二個可選參數(shù),指定打開的連接
//-----------------------------------------------------------------------------------------------//
//分頁邏輯處理
//-----------------------------------------------------------------------------------------------
$tmpArr = mysql_fetch_array($rs);
$numAL = mysql_num_rows($rs); //取得記錄總數(shù)$rs
$pages=intval($numAL/$pagesize); //計算總頁數(shù)
if ($numAL % $pagesize) $pages++;
//設(shè)置缺省頁碼
//↓判斷“當(dāng)前頁碼”是否賦值過
if (isset($_GET['page'])){ $page=intval($_GET['page']); }else{ $page=1; }//否則,設(shè)置為第一頁
//↓計算記錄偏移量
$offset=$pagesize*($page - 1);
//↓讀取指定記錄數(shù)
$rs=mysql_query("select * from `dw_newsdata` limit $offset,$pagesize",$conn);//取得—當(dāng)前頁—記錄集!
$curNum = mysql_num_rows($rs); //$curNum - 當(dāng)前頁實際記錄數(shù),for循環(huán)輸出用
?
table border="0" width="80%"
tr
td width="50%" bgcolor="#E0E0E0"標(biāo)題/td
td width="50%" bgcolor="#E0E0E0"發(fā)布時間/td
/tr
?php
while ($tmpArr = mysql_fetch_array($rs)) //提取一行,并循環(huán)判斷
{
$i=0;
// for($a=0;$a$ColNum;$a++) //==for結(jié)束==
?
tr
td width="50%"?= $tmpArr[1]; //$tmpArr["news_title"] ; ?/td
td width="50%"?php echo $tmpArr[2]; //$tmpArr["news_cont"]; ?/td
/tr
?php
}//==while結(jié)束==
?
/table
?php
//============================//
// 翻頁顯示 一
//============================//
echo "p"; // align=center
$first=1;
$prev=$page-1;
$next=$page+1;
$last=$pages;
if ($page 1)
{
echo "a href='?page=".$first."'首頁/a ";
echo "a href='?page=".$prev."'上一頁/a ";
}
if ($page $pages)
{
echo "a href='?page=".$next."'下一頁/a ";
echo "a href='?page=".$last."'尾頁/a ";
}
//============================//
// 翻頁顯示 二
//============================//
echo " | 共有".$pages."頁(".$page."/".$pages.")";
for ($i=1;$i $page;$i++){echo "a href='?page=".$i."'[".$i ."]/a ";} // 1-先輸出當(dāng)前頁之前的
if ($page 0) echo "[".$page."]";; // 2-再輸出當(dāng)前頁
for ($i=$page+1;$i=$pages;$i++){echo "a href='?page=".$i."'[".$i ."]/a ";}// 3-接著輸出當(dāng)前頁之后
echo "轉(zhuǎn)到第 INPUT maxLength=3 size=3 value=".($page+1)." name=gotox 頁 INPUT hideFocus onclick=\"location.href='?page=gotox.value';\" type=button value=Go name=cmd_goto";
echo "/p";
?
/body
/html
網(wǎng)站標(biāo)題:php數(shù)據(jù)分頁跳轉(zhuǎn) php實現(xiàn)分頁
網(wǎng)頁地址:http://m.rwnh.cn/article6/doopoig.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián),為您提供微信公眾號、定制網(wǎng)站、網(wǎng)站內(nèi)鏈、定制開發(fā)、搜索引擎優(yōu)化、ChatGPT
聲明:本網(wǎng)站發(fā)布的內(nèi)容(圖片、視頻和文字)以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主,如果涉及侵權(quán)請盡快告知,我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場,如需處理請聯(lián)系客服。電話:028-86922220;郵箱:631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載,或轉(zhuǎn)載時需注明來源: 創(chuàng)新互聯(lián)