php mysql數(shù)據(jù)庫操作分頁類
更新時(shí)間：2008年06月04日 19:55:52 作者：
如果您加了新功能，或者是有改進(jìn)，請(qǐng)與大家一起分享。
復(fù)制代碼 代碼如下:
<?php
/*
* mysql數(shù)據(jù)庫 分頁類
* @package pagelist
* @author yytcpt(無影)
* @version 2008-03-27
* @copyrigth http://www.d5s.cn/
*/
/*
* 分頁樣式
.page{float: left;font: 11px Arial, Helvetica, sans-serif; padding:6px 0; margin: 0px 10%; margin-top: 10px;}
.page a, .page strong{padding: 2px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.page a:visited{padding: 2px 6px; border: solid 1px #ddd; background: #fff; text-decoration: none;}
.page .break{padding: 2px 6px; border: none; background: #fff; text-decoration: none;}
.page strong{padding: 2px 6px; border-color: #999; font-weight: bold; font-size: 13px; vertical-align: top; background: #fff;}
.page a:hover{color: #fff; background: #0063DC; border-color: #036; text-decoration: none;}
.page a:hover div{color: #FFF;cursor: pointer !important;cursor: hand;}
*/
class pagelist{
var $page; //分頁頁碼
var $sql; //分頁sql
var $img_path; //圖標(biāo)路徑
var $img; //圖標(biāo)名稱
var $img_btn; //圖標(biāo)地址
var $page_size; //設(shè)置每頁顯示條數(shù)
var $num_btn; //設(shè)置數(shù)字分頁的顯示個(gè)數(shù)
var $total_pages; //一共分多少頁
var $total_records; //一共有多少條記錄
var $url;
var $table;
var $new_sql; //指定的SQL語句
var $db;
function __construct(){
global $db;
$this->db = $db;
$tmp_page = intval(trim($_GET["page"]));
$this->page = empty($tmp_page)?1:$tmp_page;
$this->set_table();
$this->page_size = 20;
$this->num_btn = 9;
$this->img_path = '/images/';
$this->img = array("ico_first.gif", "ico_front.gif", "ico_next.gif", "ico_last.gif");
}
function set_table(){
$this->table["tablename"] = "";
$this->table["id"] = "id";
$this->table["orderby"] = $this->table["id"];
$this->table["descasc"] = "DESC";
$this->table["fileds"] = "*";
$this->table["where"] = "";
}
function set_img(){
$this->img_btn[0] = "<img src='".$this->img_path.$this->img[0]."' alt='首頁' border='0' align='absmiddle'/>";
$this->img_btn[1] = "<img src='".$this->img_path.$this->img[1]."' alt='上一頁' border='0' align='absmiddle'/>";
$this->img_btn[2] = "<img src='".$this->img_path.$this->img[2]."' alt='下一頁' border='0' align='absmiddle'/>";
$this->img_btn[3] = "<img src='".$this->img_path.$this->img[3]."' alt='末頁' border='0' align='absmiddle'/>";
}
function set_show_page(){
$this->set_img(); //設(shè)置翻頁圖片路徑
$this->set_url();
$this->set_total_records();
if ($this->total_records<$this->page_size){
$this->total_pages = 1;
}else{
$this->total_pages = ceil($this->total_records/$this->page_size);
}
if ($this->page>$this->total_pages){
$this->page = $this->total_pages;
}
}
function show_first_prv(){
if ($this->page==1){
$str = "<strong>".$this->img_btn[0]."</strong> <strong>".$this->img_btn[1]."</strong>";
}else{
$str = "<a href='".$this->url."1"."'>".$this->img_btn[0]."</a> "; //此處1為首頁，page值為1
$str.= "<a href='".$this->url.($this->page-1)."'>".$this->img_btn[1]."</a>";
}
return $str;
}
function show_next_last(){
if ($this->page>=$this->total_pages){
$str = "<strong>".$this->img_btn[2]."</strong> <strong>".$this->img_btn[3]."</strong>";
}else{
$str = "<a href='".$this->url.($this->page+1)."'>".$this->img_btn[2]."</a> ";
$str.= "<a href='".$this->url.$this->total_pages."'>".$this->img_btn[3]."</a>";
}
return $str;
}
function show_num_text(){
$str = " 轉(zhuǎn)到第 <input id='go_num_text' type='text' value='".$this->page."' style='border:0;border-bottom:1px solid #CCC;text-align:center;width:20px;'/> 頁 ";
$str.= "<a href='#' onClick=\"window.location='".$this->url."'+document.getElementById('go_num_text').value;\" style='font-family: Arial, Helvetica, sans-serif;font-weight:bold;font-size:14px;'>[Go]</a>";
return $str;
}
function show_num_select(){
if ($this->total_pages<50){
$str = "<select onchange=\"if(this.options[this.selectedIndex].value!=''){location=this.options[this.selectedIndex].value;}\">";
for ($i=1; $i<=$this->total_pages; $i++){
$str.= "<option value='".$this->url.$i."' ".($this->page==$i ? " selected='selected'":"").">".$i."</option>";
}
$str.= "</select> ";
}else{
$str = "";
}
return $str;
}
function show_num_btn(){
if ($this->page>=1 and $this->page<=$this->total_pages){
$tmp_p = ($this->num_btn-1)/2;
if (($this->page - $tmp_p)<=0){
$start_p = 1;
}else{
if (($this->page-$tmp_p)>$this->num_btn and ($this->page-$tmp_p)>($this->total_pages - $this->num_btn+1)){
$start_p = $this->total_pages - $this->num_btn + 1;
}else{
$start_p = $this->page - $tmp_p;
}
}
if (($this->page+$tmp_p) < $this->total_pages){
$end_p = ($this->page + $tmp_p)<$this->num_btn?$this->num_btn:($this->page + $tmp_p);
if ($end_p>$this->total_pages){
$end_p = $this->total_pages;
}
}else{
$end_p = $this->total_pages;
}
}
$str = "";
for ($i=$start_p; $i<=$end_p; $i++){
if ($i==$this->page){
$str.= " <strong>".$i."</strong> ";
}else{
$str.= " <a href='".$this->url.$i."'>".$i."</a> ";
}
}
return $str;
}
function show_page_info(){
$str = " 共".$this->total_records."條/".$this->total_pages."頁";
return $str;
}
function show_page(){
if ($this->total_records<1){
$this->set_show_page();
}
$str = $this->total_pages>1 ? $this->show_first_prv().$this->show_num_btn().$this->show_next_last().$this->show_page_info().$this->show_num_text():"";
return $str;
}
//總頁數(shù)
function set_total_pages(){
$this->total_pages = ceil($this->total_records/$this->page_size);
}
//總記錄數(shù)
function set_total_records(){
if ($this->total_records==0 or !isset($this->total_records)){
if (empty($this->count_sql) and !empty($this->table["tablename"])){
$sql = "SELECT count(".$this->table["id"].") as count_id FROM `".$this->table["tablename"]."` ".($this->table["where"]!=""?" WHERE ".$this->table["where"]:"");
}else{
$sql = preg_replace("/SELECT(.*?)FROM(.*?)/i", "SELECT count(id) AS count_id FROM\\2", $this->sql);
}
$arr = $this->db->row_query_one($sql);
$this->total_records = $arr["count_id"];
}
}
/*
* 根據(jù)sql返回查詢數(shù)據(jù)
* 指定$sql時(shí)，不必指定limit
*/
function get_rows_by_sql($sql){
$this->sql = $sql." LIMIT ".$this->page_size*($this->page-1).", ".$this->page_size; //指定的SQL;
return $this->db->row_query($this->sql);
}
/*
* 最常用的分頁方法，只需要傳3個(gè)參數(shù)
* $tablename 表名， $where 查詢條件， $orderby 排序字段（默認(rèn)以id倒序排列）
*/
function get_rows($tablename, $where="", $orderby=""){
$this->table["tablename"] = $tablename;
$this->table["where"] = $where;
$orderby ? $this->table["orderby"] = $orderby : "";
$arr = array(
"page" => $this->show_page(), //分頁代碼
"rows" => $this->get_rows_by_sql(), //記錄數(shù)
"sum" => $this->total_records, //總記錄數(shù)
);
return $arr;
}
/*
* 特殊查詢，$sql_query 查詢sql語句, $row_count 統(tǒng)計(jì)總數(shù)
*/
function get_rows_sql($sql_query, $row_count=0) {
$this->total_records = $row_count;
$arr["rows"] = $this->get_rows_by_sql($sql_query);
$arr["page"] = $this->show_page();
$arr["sum"] = $this->total_records;
return $arr;
}
function get_sql(){
if ($this->total_records>10000) {
$this->sql = "SELECT ".$this->table["fileds"]." FROM `".$this->table["tablename"]."` ".($this->table["where"]!=""?" WHERE ".$this->table["where"].' AND '.$this->table["id"].'>=':' WHERE '.$this->table["id"].'>=').'(SELECT '.$this->table["id"].' FROM `'.$this->table["tablename"].'` ORDER BY '.$this->table["id"].' LIMIT '.$this->page_size*($this->page-1).', 1)'." ORDER BY ".$this->table["orderby"]." ".$this->table["descasc"]." LIMIT ".$this->page_size;
}else{
$this->sql = "SELECT ".$this->table["fileds"]." FROM `".$this->table["tablename"]."` ".($this->table["where"]!=""?" WHERE ".$this->table["where"]:"")." ORDER BY ".$this->table["orderby"]." ".$this->table["descasc"]." LIMIT ".$this->page_size*($this->page-1).", ".$this->page_size;
}
//SELECT * FROM articles ORDER BY id DESC LIMIT 0, 20
//SELECT * FROM articles WHERE category_id = 123 AND id >= (SELECT id FROM articles ORDER BY id LIMIT 10000, 1) LIMIT 10
return $this->sql; //SQL語句
}
function set_url(){
$arr_url = array();
parse_str($_SERVER["QUERY_STRING"], $arr_url);
unset($arr_url["page"]);
if (empty($arr_url)){
$str = "page=";
}else{
$str = http_build_query($arr_url)."&page=";
}
$this->url = "http://".$_SERVER["HTTP_HOST"].$_SERVER["PHP_SELF"]."?".$str;
}
}
?>
復(fù)制代碼 代碼如下:
<?php
$db_config["hostname"] = "127.0.0.1"; //服務(wù)器地址
$db_config["username"] = "root"; //數(shù)據(jù)庫用戶名
$db_config["password"] = "root"; //數(shù)據(jù)庫密碼
$db_config["database"] = "wap_blueidea_com"; //數(shù)據(jù)庫名稱
$db_config["charset"] = "utf8";
$config["charset"] = "utf-8"; //網(wǎng)站編碼
include('db.php');
include('pagelist.php');
$db = new db();
$db->connect($db_config);
header("content-type:text/html;charset=".$config["charset"]);//設(shè)置頁面編碼
$pl = new pagelist();
$arr = $pl->get_rows('table_name');
unset($pl);
echo '<pre style="text-align:left">';
print_r($arr);
echo '</pre>';
//指定特殊 sql 時(shí)候
$pl = new pagelist();
$sql = 'SELECT * FROM `wap_article` AS a, `wap_article_info` AS b WHERE a.id=b.articleid';
$arr = $pl->get_rows_sql($sql);
unset($pl);
echo '<pre style="text-align:left">';
print_r($arr);
echo '</pre>';
?>
相關(guān)文章
PHP對(duì)二維數(shù)組(多維數(shù)組)進(jìn)行排序的方法
在 PHP 中,可以使用函數(shù) array_multisort() 來對(duì)二維數(shù)組進(jìn)行排序處理,該函數(shù)可以按照指定的鍵或值對(duì)數(shù)組進(jìn)行排序,本文通過一個(gè)示例來給大家介紹一下PHP如何對(duì)二維數(shù)組(多維數(shù)組)進(jìn)行排序,需要的朋友可以參考下2023-09-09
這篇文章主要介紹了php數(shù)組添加元素方法,實(shí)例總結(jié)了常見的數(shù)組添加元素的方法,具有一定的參考借鑒價(jià)值,需要的朋友可以參考下2014-12-12
PhpStorm配置debug環(huán)境的詳細(xì)過程
在開發(fā)php項(xiàng)目的時(shí)候,有時(shí)候不知道明確的錯(cuò)誤在哪里,想要用java或者c#那樣能夠開啟debug斷點(diǎn)分步調(diào)試,下面這篇文章主要給大家介紹了關(guān)于PhpStorm配置debug環(huán)境的詳細(xì)過程,需要的朋友可以參考下2023-01-01
本篇文章是對(duì)php引用返回與取消引用進(jìn)行了詳細(xì)的分析介紹，需要的朋友參考下2013-06-06
.htaccess太強(qiáng)大了，但它本身會(huì)不會(huì)被破解掉呢，請(qǐng)問如何保護(hù)它？2011-02-02
PHP中使用Imagick實(shí)現(xiàn)各種圖片效果實(shí)例
這篇文章主要介紹了PHP中使用Imagick實(shí)現(xiàn)各種圖片效果實(shí)例,本文講解了偏置圖像、改變圖片大小、創(chuàng)建文本圖像、圖像模糊度處理等內(nèi)容,需要的朋友可以參考下2015-01-01
php變量與JS變量實(shí)現(xiàn)不通過跳轉(zhuǎn)直接交互的方法
這篇文章主要介紹了php變量與JS變量實(shí)現(xiàn)不通過跳轉(zhuǎn)直接交互的方法,涉及php與javascript變量傳輸及代碼混編相關(guān)操作技巧,需要的朋友可以參考下2017-08-08
本文給大家簡單總結(jié)了php的10點(diǎn)優(yōu)點(diǎn)和3個(gè)缺點(diǎn)，都是個(gè)人對(duì)于php開發(fā)的一些體悟和總結(jié)，有需要的小伙伴可以參考下。2015-07-07
PHP排序算法之堆排序(Heap Sort)實(shí)例詳解
這篇文章主要介紹了PHP排序算法之堆排序(Heap Sort),結(jié)合實(shí)例形式詳細(xì)分析了堆排序的原理、實(shí)現(xiàn)方法及相關(guān)使用注意事項(xiàng),需要的朋友可以參考下2018-04-04
php數(shù)據(jù)類型判斷時(shí)需要注意的是is_numeric() 檢測變量是否為數(shù)字或數(shù)字字符串有別 is_integer()2013-09-09