解析用PHP操作MySql數據庫(3)_PHP教程
教程Tag:暫無Tag,歡迎添加,賺取U幣!
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;
}
//總頁數
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"];
}
}
/*
* 根據sql返回查詢數據
* 指定sql時,不必指定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);
}
相關PHP教程:
- 【PHP Munee】調整圖片尺寸 + 合并/壓縮CSS JS + 緩存等功能于一身的類
- Detector:檢測用戶瀏覽器環境的php類
- PHP Thumb:生成圖片縮略圖的類
- Hybrid Auth:通過微博/社交網站和ID來提供驗證功能實現同步登錄網站功能
- Geocoder:一個幫助我們建立地理感知應用程序的php類庫
- PHPFastCache:強大的開源PHP緩存庫
- PHP Error:解決開發過程中面臨的PHP錯誤信息
- Snoopy:模擬瀏覽器功能的php類庫
- php socket 發送郵件的庫
- mysql:分頁php類庫
- 簡單實用的php mysql數據庫連接類
- php生成excel文件的類庫
- 相關鏈接:
- 教程說明:
PHP教程-解析用PHP操作MySql數據庫(3)
。