PHP中常用的分页类总结

当前位置:

首页 > PHP >

PHP中常用的分页类总结

php分页是目前在显示大量结果时所采用的最好的方式,有了下面这些代码的帮助,开发人员可以在多个页面中显示大量的数据,在互联网上,分页是一般用于搜索结果或是浏览全部信息.

php基本分页,代码如下:

<?php

// database connection info

$conn = mysql_connect('localhost','dbusername','dbpass') or trigger_error("SQL", E_USER_ERROR);

$db = mysql_select_db('dbname',$conn) or trigger_error("SQL", E_USER_ERROR);

// find out how many rows are in the table

$sql = "SELECT COUNT(*) FROM numbers";

$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

$r = mysql_fetch_row($result);

$numrows = $r[0];

// number of rows to show per page

$rowsperpage = 10;

// find out total pages

$totalpages = ceil($numrows / $rowsperpage);

// get the current page or set a default

if (isset($_GET['currentpage']) && is_numeric($_GET['currentpage'])) {

// cast var as int

$currentpage = (int) $_GET['currentpage'];

} else {

// default page num

$currentpage = 1;

} // end if

// if current page is greater than total pages...

if ($currentpage > $totalpages) {

// set current page to last page

$currentpage = $totalpages;

} // end if

// if current page is less than first page...

if ($currentpage < 1) {

// set current page to first page

$currentpage = 1;

} // end if

// the offset of the list, based on current page

$offset = ($currentpage - 1) * $rowsperpage;

// get the info from the db

$sql = "SELECT id, number FROM numbers LIMIT $offset, $rowsperpage";

$result = mysql_query($sql, $conn) or trigger_error("SQL", E_USER_ERROR);

// while there are rows to be fetched...

while ($list = mysql_fetch_assoc($result)) {

// echo data

echo $list['id'] . " : " . $list['number'] . "<br />";

} // end while

/****** build the pagination links ******/

// range of num links to show

$range = 3;

// if not on page 1, don't show back links

if ($currentpage > 1) {

// show << link to go back to page 1

echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=1'><<</a> ";

// get previous page num

$prevpage = $currentpage - 1;

// show < link to go back to 1 page

echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$prevpage'><</a> ";

} // end if

// loop to show links to range of pages around current page

for ($x = ($currentpage - $range); $x < (($currentpage + $range) + 1); $x++) {

// if it's a valid page number...

if (($x > 0) && ($x <= $totalpages)) {

// if we're on current page...

if ($x == $currentpage) {

// 'highlight' it but don't make a link

echo " [<b>$x</b>] ";

// if not current page...

} else {

// make it a link

echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$x'>$x</a> ";

} // end else

} // end if

} // end for

// if not on last page, show forward and last page links

if ($currentpage != $totalpages) {

// get next page

$nextpage = $currentpage + 1;

// echo forward link for next page

echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$nextpage'>></a> ";

// echo forward link for lastpage

echo " <a href='{$_SERVER['PHP_SELF']}?currentpage=$totalpages'>>></a> ";

} // end if

/****** end build pagination links ******/

?>

先看一个常用的php分页类,代码如下:

<?php

/*

  Place code to connect to your DB here.

*/

include('config.php'); // include your code to connect to DB.

$tbl_name="";  //your table name

// How many adjacent pages should be shown on each side?

$adjacents = 3;

/*

    First get total number of rows in data table.

    If you have a WHERE clause in your query, make sure you mirror it here.

*/

$query = "SELECT COUNT(*) as num FROM $tbl_name";

$total_pages = mysql_fetch_array(mysql_query($query));

$total_pages = $total_pages[num];

/* Setup vars for query. */

$targetpage = "filename.php";  //your file name  (the name of this file)

$limit = 2;         //how many items to show per page

$page = $_GET['page'];

if($page)

  $start = ($page - 1) * $limit;    //first item to display on this page

else

  $start = 0;        //if no page var is given, set start to 0

/* Get data. */

$sql = "SELECT column_name FROM $tbl_name LIMIT $start, $limit";

$result = mysql_query($sql);

/* Setup page vars for display. */

if ($page == 0) $page = 1;     //if no page var is given, default to 1.

$prev = $page - 1;       //previous page is page - 1

$next = $page + 1;       //next page is page + 1

$lastpage = ceil($total_pages/$limit);  //lastpage is = total pages / items per page, rounded up.

$lpm1 = $lastpage - 1;      //last page minus 1

/*

  Now we apply our rules and draw the pagination object.

  We're actually saving the code to a variable in case we want to draw it more than once.

*/

$pagination = "";

if($lastpage > 1)

{

  $pagination .= "<div class="pagination">";

  //previous button

  if ($page > 1)

   $pagination.= "<a href="$targetpage?page=$prev">� previous</a>";

  else

   $pagination.= "<span class="disabled">� previous</span>";



  //pages

  if ($lastpage < 7 + ($adjacents * 2)) //not enough pages to bother breaking it up

  {

   for ($counter = 1; $counter <= $lastpage; $counter++)

   {

    if ($counter == $page)

     $pagination.= "<span class="current">$counter</span>";

    else

     $pagination.= "<a href="$targetpage?page=$counter">$counter</a>";

   }

  }

  elseif($lastpage > 5 + ($adjacents * 2)) //enough pages to hide some

  {

   //close to beginning; only hide later pages

   if($page < 1 + ($adjacents * 2))

   {

    for ($counter = 1; $counter < 4 + ($adjacents * 2); $counter++)

    {

     if ($counter == $page)

      $pagination.= "<span class="current">$counter</span>";

     else

      $pagination.= "<a href="$targetpage?page=$counter">$counter</a>";

    }

    $pagination.= "...";

    $pagination.= "<a href="$targetpage?page=$lpm1">$lpm1</a>";

    $pagination.= "<a href="$targetpage?page=$lastpage">$lastpage</a>";

   }

   //in middle; hide some front and some back

   elseif($lastpage - ($adjacents * 2) > $page && $page > ($adjacents * 2))

   {

    $pagination.= "<a href="$targetpage?page=1">1</a>";

    $pagination.= "<a href="$targetpage?page=2">2</a>";

    $pagination.= "...";

    for ($counter = $page - $adjacents; $counter <= $page + $adjacents; $counter++)

    {

     if ($counter == $page)

      $pagination.= "<span class="current">$counter</span>";

     else

      $pagination.= "<a href="$targetpage?page=$counter">$counter</a>";

    }

    $pagination.= "...";

    $pagination.= "<a href="$targetpage?page=$lpm1">$lpm1</a>";

    $pagination.= "<a href="$targetpage?page=$lastpage">$lastpage</a>";

   }

   //close to end; only hide early pages

   else

   {

    $pagination.= "<a href="$targetpage?page=1">1</a>";

    $pagination.= "<a href="$targetpage?page=2">2</a>";

    $pagination.= "...";

    for ($counter = $lastpage - (2 + ($adjacents * 2)); $counter <= $lastpage; $counter++)

    {

     if ($counter == $page)

      $pagination.= "<span class="current">$counter</span>";

     else

      $pagination.= "<a href="$targetpage?page=$counter">$counter</a>";

    }

   }

  }



  //next button

  if ($page < $counter - 1)

   $pagination.= "<a href="$targetpage?page=$next">next �</a>";

  else

   $pagination.= "<span class="disabled">next �</span>";

  $pagination.= "</div>n";

}//开源代码phpfensi.com

?>

<?php

  while($row = mysql_fetch_array($result))

  {

  // Your while loop here

  }

?>

<?=$pagination?>

实例代码如下:

<?php

class PageView{

    /**页码**/

    public $pageNo = 1;

    /**页大小**/

    public $pageSize = 20;

    /**共多少页**/

    public $pageCount = 0;

    /**总记录数**/

    public $totalNum = 0;

    /**偏移量,当前页起始行**/

    public $offSet = 0;

    /**每页数据**/

    public $pageData = array();



    /**是否有上一页**/

    public $hasPrePage = true;

    /**是否有下一页**/

    public $hasNextPage = true;



    public $pageNoList = array();



    public $jsFunction ='jsFunction';

    /**

     *

     * @param unknown_type $count 总行数

     * @param unknown_type $size 分页大小

     * @param unknown_type $string

     */

    public function __construct($count=0, $size=20,$pageNo=1,$pageData =array(),$jsFunction='jsFunction'){

        $this->totalNum = $count;//总记录数

        $this->pageSize = $size;//每页大小

        $this->pageNo = $pageNo;

        //计算总页数

        $this->pageCount = ceil($this->totalNum/$this->pageSize);

        $this->pageCount = ($this->pageCount<=0)?1:$this->pageCount;

        //检查pageNo

        $this->pageNo = $this->pageNo == 0 ? 1 : $this->pageNo;

        $this->pageNo = $this->pageNo > $this->pageCount? $this->pageCount : $this->pageNo;



        //计算偏移

        $this->offset = ( $this->pageNo - 1 ) * $this->pageSize;

        //计算是否有上一页下一页

        $this->hasPrePage = $this->pageNo == 1 ?false:true;

        $this->hasNextPage = $this->pageNo >= $this->pageCount ?false:true;



        $this->pageData = $pageData;

        $this->jsFunction = $jsFunction;



    }

    /**

     * 分页算法

     * @return

     */

    private function generatePageList(){

        $pageList = array();

        if($this->pageCount <= 9){

            for($i=0;$i<$this->pageCount;$i++){

                array_push($pageList,$i+1);

            }

        }else{

            if($this->pageNo <= 4){

                for($i=0;$i<5;$i++){

                    array_push($pageList,$i+1);

                }

                array_push($pageList,-1);

                array_push($pageList,$this->pageCount);

            }else if($this->pageNo > $this->pageCount - 4){

                array_push($pageList,1);



                array_push($pageList,-1);

                for($i=5;$i>0;$i--){

                    array_push($pageList,$this->pageCount - $i+1);

                }

            }else if($this->pageNo > 4 && $this->pageNo <= $this->pageCount - 4){

                array_push($pageList,1);

                array_push($pageList,-1);



                array_push($pageList,$this->pageNo -2);

                array_push($pageList,$this->pageNo -1);

                array_push($pageList,$this->pageNo);

                array_push($pageList,$this->pageNo + 1);

                array_push($pageList,$this->pageNo + 2);



                array_push($pageList,-1);

                array_push($pageList,$this->pageCount);



            }

        }

        return $pageList;

    }

    /***

     * 创建分页控件

    * @param

    * @return String

    */

    public function echoPageAsDiv(){

        $pageList = $this->generatePageList();



        $pageString ="<div class='pagination'><div class='page-bottom'>";



        if(!emptyempty($pageList)){

            if($this->pageCount >1){

                if($this->hasPrePage){

                    $pageString = $pageString ."<a class='page-next' href="javascript：" .$this->jsFunction . "(" . ($this->pageNo-1) . ")">上一页</a>";

                }

                foreach ($pageList as $k=>$p){

                    if($this->pageNo == $p){

                        $pageString = $pageString ."<span class='page-cur'>" . $this->pageNo . "</span>";

                        continue;

                    }

                    if($p == -1){

                        $pageString = $pageString ."<span class='page-break'>...</span>";

                        continue;

                    }

                    $pageString = $pageString ."<a href="javascript：" .$this->jsFunction . "(" . $p . ")">" . $p . "</a>";

                }



                if($this->hasNextPage){

                    $pageString = $pageString ."<a class='page-next' href="javascript：" .$this->jsFunction . "(" . ($this->pageNo+1) . ")">下一页</a>";

                }



            }

        }

        $pageString = $pageString .("</div></div>");

        return $pageString;

    }

}

?>

css代码如下:

<style type="text/css">



</style>

在php页面中的调用方法,代码如下:

$pageNo = $_GET['pageNo'];

        if(emptyempty($pageNo)){

            $pageNo = 1;

        }

        //分页数据

        $pageData = News::getNewsPage($pageNo,$pageSize);

       //取得总行数

        $count = News::getNewsCount();

        //创建分页器

        $p = new PageView($count['0']['TOTAL'],$pageSize,$pageNo,$pageData);

　　　　 //生成页码

        $pageViewString = $p->echoPageAsDiv();

出处：http://www.phpfensi.com/php/20140828/4925.html

栏目列表