解析用PHP操作MySql數(shù)據(jù)庫(kù)

2024-07-24 12:43:08

字體：大中小

供稿：網(wǎng)友

<?php
/*
* mysql數(shù)據(jù)庫(kù) 分頁(yè)類
* @package pagelist
* @author yytcpt(無(wú)影)
* @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;
}
}

共4頁(yè)上一頁(yè)1234下一頁(yè)

上一篇：揭秘PHP+MySQL動(dòng)態(tài)網(wǎng)站開發(fā)基礎(chǔ)實(shí)例教程

下一篇：解析用PHP操作MySql數(shù)據(jù)庫(kù)(DB類)