首先一個分頁類,如下(摘自網絡)可拷貝直接使用
each_disNums = intval($each_disNums); $this->nums = intval($nums); if (!$current_page) { $this->current_page = 1; } else { $this->current_page = intval($current_page); } $this->sub_pages = intval($sub_pages); $this->pageNums = ceil($nums / $each_disNums); $this->subPage_link = $subPage_link; $this->show_SubPages($subPage_type); //echo $this->pageNums."--".$this->sub_pages; } /* __destruct析構函數,當類不在使用的時候調用,該函數用來釋放資源。 */ function __destruct() { unset ($each_disNums); unset ($nums); unset ($current_page); unset ($sub_pages); unset ($pageNums); unset ($page_array); unset ($subPage_link); unset ($subPage_type); } /* show_SubPages函數用在構造函數裡面。而且用來判斷顯示什麼樣子的分頁 */ function show_SubPages($subPage_type) { if ($subPage_type == 1) { $this->subPageCss1(); } elseif ($subPage_type == 2) { $this->subPageCss2(); } } /* 用來給建立分頁的數組初始化的函數。 */ function initArray() { for ($i = 0; $i < $this->sub_pages; $i++) { $this->page_array[$i] = $i; } return $this->page_array; } /* construct_num_Page該函數使用來構造顯示的條目 即使:[1][2][3][4][5][6][7][8][9][10] */ function construct_num_Page() { if ($this->pageNums < $this->sub_pages) { $current_array = array (); for ($i = 0; $i < $this->pageNums; $i++) { $current_array[$i] = $i +1; } } else { $current_array = $this->initArray(); if ($this->current_page <= 3) { for ($i = 0; $i < count($current_array); $i++) { $current_array[$i] = $i +1; } } elseif ($this->current_page <= $this->pageNums && $this->current_page > $this->pageNums - $this->sub_pages + 1) { for ($i = 0; $i < count($current_array); $i++) { $current_array[$i] = ($this->pageNums) - ($this->sub_pages) + 1 + $i; } } else { for ($i = 0; $i < count($current_array); $i++) { $current_array[$i] = $this->current_page - 2 + $i; } } } return $current_array; } /* 構造普通模式的分頁 共4523條記錄,每頁顯示10條,當前第1/453頁 [首頁] [上頁] [下頁] [尾頁] */ function subPageCss1() { $subPageCss1Str = ""; $subPageCss1Str .= "共" . $this->nums . "條記錄,"; $subPageCss1Str .= "每頁顯示" . $this->each_disNums . "條,"; $subPageCss1Str .= "當前第" . $this->current_page . "/" . $this->pageNums . "頁 "; if ($this->current_page > 1) { http://blog.csdn.net/tangcheng_ok/article/details/$firstPageUrl = $this->subPage_link . "1"; http://blog.csdn.net/tangcheng_ok/article/details/$prewPageUrl = $this->subPage_link . ($this->current_page - 1); $subPageCss1Str .= "[首頁] "; $subPageCss1Str .= "[上一頁] "; } else { $subPageCss1Str .= "[首頁] "; $subPageCss1Str .= "[上一頁] "; } if ($this->current_page < $this->pageNums) { http://blog.csdn.net/tangcheng_ok/article/details/$lastPageUrl = $this->subPage_link . $this->pageNums; http://blog.csdn.net/tangcheng_ok/article/details/$nextPageUrl = $this->subPage_link . ($this->current_page + 1); $subPageCss1Str .= " [下一頁] "; $subPageCss1Str .= "[尾頁] "; } else { $subPageCss1Str .= "[下一頁] "; $subPageCss1Str .= "[尾頁] "; } echo $subPageCss1Str; } /* 構造經典模式的分頁 當前第1/453頁 [首頁] [上頁] 1 2 3 4 5 6 7 8 9 10 [下頁] [尾頁] */ function subPageCss2() { $subPageCss2Str = ""; $subPageCss2Str .= "當前第" . $this->current_page . "/" . $this->pageNums . "頁 "; if ($this->current_page > 1) { http://blog.csdn.net/tangcheng_ok/article/details/$firstPageUrl = $this->subPage_link . "1"; http://blog.csdn.net/tangcheng_ok/article/details/$prewPageUrl = $this->subPage_link . ($this->current_page - 1); $subPageCss2Str .= " 首頁 "; $subPageCss2Str .= " 上一頁 "; } else { $subPageCss2Str .= " 首頁 "; $subPageCss2Str .= " 上一頁 "; } $a = $this->construct_num_Page(); for ($i = 0; $i < count($a); $i++) { $s = $a[$i]; if ($s == $this->current_page) { $subPageCss2Str .= " " . $s . " "; } else { http://blog.csdn.net/tangcheng_ok/article/details/$url = $this->subPage_link . $s; $subPageCss2Str .= " " . $s . " "; } } if ($this->current_page < $this->pageNums) { http://blog.csdn.net/tangcheng_ok/article/details/$lastPageUrl = $this->subPage_link . $this->pageNums; http://blog.csdn.net/tangcheng_ok/article/details/$nextPageUrl = $this->subPage_link . ($this->current_page + 1); $subPageCss2Str .= " 下一頁 "; $subPageCss2Str .= " 尾頁 "; } else { $subPageCss2Str .= " 下一頁 "; $subPageCss2Str .= " 尾頁 "; } echo $subPageCss2Str; } } ?>
在需要分頁的php文件中
include_once ("Pagination.php"); //每頁顯示的條數 $pageSize = 10; //總條目數 $pageTotal = $db->get_var("select count(*) from tb"); //每次顯示的頁數 $sub_pages = 10; //得到當前是第幾頁 if (is_array($_GET) && count($_GET) > 0) { if (isset ($_GET["p"])) { //是否存在"id"的參數 $pageCurrent = $_GET["p"]; } } else { $pageCurrent = 1; } $goodses = $db->get_results("SELECT g.id,* FROM tb as g INNER JOIN (select id from tb order by updatetime desc limit " . ($pageCurrent -1) * $pageSize . ",10 )as g1 ON g.id=g1.id");
顯示分頁數據
注:本文的Pagination類來自網絡,沒有標注網址,在原代碼的基礎上進行了修改,如果涉及任何問題,請留言。在此感謝作者,並作出上述聲明。
轉載請注明出處:http://blog.csdn.net/tangcheng_ok