用PHP操作MySql数据库(分页)

欢迎您访问我爱IT技术网，今天小编为你分享的编程技术是：【用PHP操作MySql数据库(分页)】，下面是详细的分享！

用PHP操作MySql数据库(分页)

以下为引用的内容：
<?php


class pagelist{
var page; //分页页码
var sql; //分页sql
var img_path; //图标路径
var img; //图标名称
var img_btn; //图标地址
var page_size; //设置每页显示条数
var num_btn; //设置数字分页的显示个数
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=http://www.chinaz.com/program/2008/1021/’".this->img_path.this->img[0]."’ alt=’首页’ border=’0’ align=’absmiddle’/>";
this->img_btn[1]="<img src=http://www.chinaz.com/program/2008/1021/’".this->img_path.this->img[1]."’ alt=’上一页’ border=’0’ align=’absmiddle’/>";
this->img_btn[2]="<img src=http://www.chinaz.com/program/2008/1021/’".this->img_path.this->img[2]."’ alt=’下一页’ border=’0’ align=’absmiddle’/>";
this->img_btn[3]="<img src=http://www.chinaz.com/program/2008/1021/’".this->img_path.this->img[3]."’ alt=’末页’ border=’0’ align=’absmiddle’/>";
}
function set_show_page(){
this->set_img(); //设置翻页图片路径
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=http://www.chinaz.com/program/2008/1021/’".this->url."1"."’>".this->img_btn[0]."</a> "; //此处1为首页，page值为1
str.="<a href=http://www.chinaz.com/program/2008/1021/’".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=http://www.chinaz.com/program/2008/1021/’".this->url.(this->page+1)."’>".this->img_btn[2]."</a> ";
str.="<a href=http://www.chinaz.com/program/2008/1021/’".this->url.this->total_pages."’>".this->img_btn[3]."</a>";
}
return str;
}
function show_num_text(){
str=" 转到第 <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=http://www.chinaz.com/program/2008/1021/’#’ 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=http://www.chinaz.com/program/2008/1021/’".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;
}
//总页数
function set_total_pages(){
this->total_pages=ceil(this->total_records/this->page_size);
}
//总记录数
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"];
}
}

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);
}

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(), //记录数
"sum"=> this->total_records, //总记录数
);
return arr;
}

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;
}
}
?>

 

如果您加了新功能，或者是有改进，请与大家一起分享。

测试代码如下，db.php 请到这里下载：

http://dwww.cn/news/2008-6/2008662043517349.shtml

<?php
db_config["hostname"]="127.0.0.1"; //服务器地址
db_config["username"]="root"; //数据库用户名
db_config["password"]="root"; //数据库密码
db_config["database"]="wap_blueidea_com"; //数据库名称
db_config["charset"]="utf8";
config["charset"]="utf-8"; //网站编码

include(’db.php’);
include(’pagelist.php’);
db=new db();
db->connect(db_config);
header("content-type:text/html;charset=".config["charset"]);//设置页面编码
pl=new pagelist();
arr=pl->get_rows(’table_name’);
unset(pl);
echo ’<pre style="text-align:left">’;
print_r(arr);
echo ’</pre>’;
//指定特殊 sql 时候
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>’;
?>

以上所分享的是关于用PHP操作MySql数据库(分页)，下面是编辑为你推荐的有价值的用户互动：

　　相关问题：怎么做php数据库调取数据分页显示，要php的

　　答： >>详细

　　相关问题：PHP显示很多数据库信息，如何自动分页呢？代码

　　答：PHP代码如下: /* Author:默默 Date :2006-12-03 */ $page=isset($_GET['page'])?intval($_GET['page']):1; //这句就是获取page=18中的page的值，假如不存在page，那么页数就是1。 $num=10; //每页显示10条数据 $db=mysql_connect("host","name",... >>详细

　　相关问题：php使用mysql数据库分页显示100页，怎么只输出前后...

　　答：这个得用程序去判断，根据每页显示的记录条数和记录总数做处理，给你个思路吧。 function getTotalPagesStr ( $total ,$maxPageItems ){ $totalPages = 0; if ( $total % $maxPageItems == 0 ){ $totalPages = $total/$maxPageItems ; if ( $tot... >>详细