中文字幕二区_国产精品免费在线观看_黄色网站观看_人人草人人澡_日本真实娇小xxxx

運(yùn)行代碼框
<?php /* * mysql數(shù)據(jù)庫(kù) 分頁(yè)類 * @package pagelist * @author yytcpt(無影) * @version 2008-03-27 * @copyrigth http://www.d5s.cn/ */ /* * 分頁(yè)樣式 .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; //分頁(yè)頁(yè)碼 var $sql; //分頁(yè)sql var $img_path; //圖標(biāo)路徑 var $img; //圖標(biāo)名稱 var $img_btn; //圖標(biāo)地址 var $page_size; //設(shè)置每頁(yè)顯示條數(shù) var $num_btn; //設(shè)置數(shù)字分頁(yè)的顯示個(gè)數(shù) var $total_pages; //一共分多少頁(yè) var $total_records; //一共有多少條記錄 var $url; var $table; var $new_sql; //指定的SQL語(yǔ)句 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='首頁(yè)' border='0' align='absmiddle'/>"; $this->img_btn[1] = "<img src='".$this->img_path.$this->img[1]."' alt='上一頁(yè)' border='0' align='absmiddle'/>"; $this->img_btn[2] = "<img src='".$this->img_path.$this->img[2]."' alt='下一頁(yè)' border='0' align='absmiddle'/>"; $this->img_btn[3] = "<img src='".$this->img_path.$this->img[3]."' alt='末頁(yè)' border='0' align='absmiddle'/>"; } function set_show_page(){ $this->set_img(); //設(shè)置翻頁(yè)圖片路徑 $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為首頁(yè)，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;'/> 頁(yè) "; $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."頁(yè)"; 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; } //總頁(yè)數(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); } /* * 最常用的分頁(yè)方法，只需要傳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(), //分頁(yè)代碼 "rows" => $this->get_rows_by_sql(), //記錄數(shù) "sum" => $this->total_records, //總記錄數(shù) ); return $arr; } /* * 特殊查詢，$sql_query 查詢sql語(yǔ)句, $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語(yǔ)句 } 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; } } ?>
[Ctrl+A 全部選擇 提示：你可先修改部分代碼，再按運(yùn)行]

如果您加了新功能，或者是有改進(jìn)，請(qǐng)與大家一起分享。

測(cè)試代碼如下，db.php 請(qǐng)到這里下載：
http://www.95time.cn/tech/program/2008/5665.asp

<?php
    $db_config["hostname"]    = "127.0.0.1";    //服務(wù)器地址
    $db_config["username"]    = "root";        //數(shù)據(jù)庫(kù)用戶名
    $db_config["password"]    = "root";        //數(shù)據(jù)庫(kù)密碼
    $db_config["database"]    = "wap_blueidea_com";        //數(shù)據(jù)庫(kù)名稱
    $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è)置頁(yè)面編碼
    $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>';
?>

當(dāng)表中的記錄總數(shù)在 10000條以上時(shí)，使用了 子查詢分頁(yè)，這樣效率會(huì)更高一些，數(shù)據(jù)量小的時(shí)候，直接查詢更快。這個(gè)是老王說的，參考這里：
http://hi.baidu.com/thinkinginlamp/blog/item/c5dea0ecdfef5e392697910f.html

經(jīng)典論壇交流：
http://bbs.blueidea.com/thread-2841374-1-1.html

本文鏈接：http://www.95time.cn/tech/program/2008/5767.asp　

出處：藍(lán)色理想
責(zé)任編輯：bluehearts

◎進(jìn)入論壇網(wǎng)絡(luò)編程版塊參加討論