php mysql paging implementation code_PHP tutorial
This is a relatively perfect paging class. It supports form input jump and select jump paging. It also supports offset paging for the previous 10 pages and the next 10 pages. */
This is a relatively perfect paging class. It supports form input jump and select jump paging. It also supports offset paging for the previous 10 pages and the next 10 pages.
*/
class wind_page
{
var $page;
//The current page
var $total;
//Total number of records
var $totalpage;
//Total page tree
var $pagesize;
//Number of items displayed on each page
var $offset;
//Offset
var $result;
//Record collection
var $thispage;
//Total number of records //Total number of records //Total number of records
var $link;
//Connect (record $_get variable)
var $bar_mun;
//Number of pages displayed by bar
var $starttime;
//Start time
var $bar_last;
//The number of continuous pages of the navigation bar
var $bar_mid;
//Navigation bar middle page
var $minpage;
//Navigation bar minimum page
var $maxpage;
//Maximum page of navigation bar
var $key;
//Identify pagination (used to distinguish multiple paginations on one page)
var $style;
//Output style
var $pre_page_char;
//Previous page
var $pre_page_image;
//Previous page graphics
var $pre_page_char_color;
//Font color of previous page
var $next_page_char;
//Next page
var $next_page_image;
//Next page graphics
var $next_page_char_color;
//Next page font color
var $pre_groud_char;
//Turn up the middle page
var $pre_groud_char_color;
//Number font color of the middle page when turning up
var $next_groud_char;
//Turn down the middle page
var $next_groud_char_color;
//Number font color when turning down the middle page
var $first_page_char;
//Home
var $first_page_char_color;
//Home page font color
var $last_page_char;
//Last page
var $last_page_char_color;
//Last page font color
var $html_page_val;
//html current page number value
Function wind_page($sql, $pagesize = 20, $bar_mun = 10, $style = 1,$this_page = 1,$html_page_val=1,$key = "") //Constructor ()
{
$this->starttime = microtime();
$this->pagesize = $pagesize;
//Number of items displayed on each page
$this->key = trim($key);
$this->bar_mun = $bar_mun;
$this->style = $style;
$this->html_page_val = $html_page_val;
//html current page number value
$this->bar_last = $bar_mun-1;
$this->bar_mid = floor($bar_mun/2);
$this->sql = $sql;
$result = mysql tutorial_query($this->sql);
$this->total = mysql_num_rows($result);
//Total number of records
$this->totalpage = ceil($this->total/$this->pagesize);
//Total number of pages
//$this->page = ceil($_get[$this->key."page"]);
$this->page = $this_page;
//现在所在页
if ($this->page == "" || $this->page < 1 || !is_numeric($this->page))$this->page = 1;
$this->page = min($this->page, $this->totalpage);
$this->thispage = $this->pagesize;
if ($this->page * $this->pagesize > $this->total) {
$this->thispage = $this->total-($this->page-1) * $this->pagesize;
};
$this->sql .= " limit ".($this->pagesize * ($this->page-1)).", ".$this->pagesize;
//开始读取的条数
//echo "
";
$this->result = mysql_query($this->sql);
$this->getvar();
$this->pre_page_char = "上一页";
$this->pre_page_image = "";
$this->next_page_char = "下一页";
$this->next_page_image = "";
$this->pre_groud_char = "上一组";
$this->next_groud_char = "下一组";}
function getvar() //取得除page外的其他get变量
{
$this->link = "";
foreach($_get as $key => $vaule) {
if (strtolower($key) !== $this->key."page") $this->link .= "&$key=$vaule";
}
}
function pre_page($color="#909090",$sign=0) //上一页
{
if ($this->page > 1) {
return "page-1).".html" class="ab">pre_page_char_color."">".$this->pre_page_char."";
} else
{
return "".$this->pre_page_char."";
}
}
function next_page($color="#909090",$sign=0) //下一页
{
if ($this->page < $this->totalpage) {
return "page+1).".html" class="ab">".$this->next_page_char."";
} else {
return "".$this->next_page_char."";
}
}
function pre_groud($char = "<<", $color = "#909090") //上一组
{
if ($this->page <= ($this->bar_mid+1)) {
return "".$this->pre_groud_char."";
//return $this->pre_groud_char;
} else {
$pre_gpage = ($this->page-$this->bar_mid < 0)?1:
$this->page-$this->bar_mid;
return "".$this->pre_groud_char."";
}
}
function next_groud($char = ">>", $color = "#909090") //下一组
{
if (($this->totalpage-$this->page) <= ($this->bar_mid-1)) {
return "".$this->next_groud_char."";
} else {
$next_gpage = ($this->page+$this->bar_mid < $this->totalpage)?$this->page+$this->bar_mid:
$this->totalpage;
return "".$this->next_groud_char."";
}
}
function mun($lcolor = "#ff6633", $acolor = "#ff6633", $left = " ", $right = " ") //数字导航栏
{
$link = "";
$this->minpage = ($this->page-$this->bar_mid < 1) ? 1:($this->page-$this->bar_mid);
$this->maxpage = $this->minpage+$this->bar_last;
if ($this->maxpage > $this->totalpage) {
$this->maxpage = $this->totalpage;
$this->minpage = ($this->maxpage-$this->bar_last < 1) ? 1: $this->maxpage-$this->bar_last;
}
for($i = $this->minpage; $i <= $this->maxpage; $i++)
{
/* 循环输出页码 */
$i = sprintf("%02d",$i);
//不足两位的前面补0
$char = $left.$i.$right;
//导航条左右两边加窄
if ($i == $this->page)
{
/* 假如是当前页则不加链接 */
$link.= "".$char."";
}
else
{
//$link .= "key."page=".$i.$this->link."" >".$char."";
$link.= "".$char."";
//关键把$link 加在新资料加入之后
}
}
echo "
";
return $link;
}
function jump_bar($class = "jump_bar") //下拉跳转
{
$link = "";
return $link;
}
function mun_bar() //整条数字导航栏 [<<][<][01][02][03][04][05][06][07][08][09][10][>][>>]
{
//return $this->first_groud().$this->pre_groud().$this->pre_page().$this->mun().$this->next_page().$this->next_groud().$this->last_groud();
return $this->pre_groud()." ".$this->pre_page().$this->mun().$this->next_page()." ".$this->next_groud();
}
function page_button()
{ //整条数字导航栏 [<][01][02][03][04][05][06][07][08][09][10][>]
//return $this->first_groud().$this->pre_groud().$this->pre_page().$this->mun().$this->next_page().$this->next_groud().$this->last_groud();
return $this->pre_page('#909090',1).$this->mun().$this->next_page('#909090',1);
}
function total_bar($coloro = "#000000", $colorn = "red") //统计数字 页次:1/4310 每页:20 共计:4310页 本页:20
{
return "页次:$this->page/$this->totalpage 每页:$this->pagesize 共计:$this->totalpage页 本页:$this->thispage";
}
// 整条导航栏
//页次:1/4310 每页:20 共计:4310页 本页:20 [<<][<][01][02][03][04][05][06][07][08][09][10][>][>>]
function page_bar($coloro = "#000000", $colorn = "red") {
return "".$this->mm_jumpmenu();
".$this->total_bar()."
".$this->mun_bar()."
".$this->jump_bar()."
}
function taketime($color = "#000000") //计算执行时间
{
return "本页执行时间".abs((microtime()-$this->starttime) * 1000)."毫秒";
}
Function style() //Output paging style
{
$style_num = $this->style;
If ($this->totalpage != 0) //If the total number of pages = 0, it means no paging
{
switch($style_num) {
case 1:
return $this->page_bar();
//Page: 1/4310 Each page: 20 Total: 4310 pages This page: 20 [<<][<][01][02][03][04][05][06][07 ][08][09][10][>][>>]
break;
case 2:
echo $this->mun_bar();
//The entire digital navigation bar [<<][<][01][02][03][04][05][06][07][08][09][10][> ][>>]
break;
case 3:
echo $this->page_button();
//The entire digital navigation bar [<][01][02][03][04][05][06][07][08][09][10][>]
break;
}
}
}
Function mm_jumpmenu() //Jump of web page special effects
{
//window.open(selobj.options[selobj.selectedindex].value,targ);
return "
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
AI Hentai Generator
Generate AI Hentai for free.
Hot Article
R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌Hello Kitty Island Adventure: How To Get Giant Seeds1 months ago By 尊渡假赌尊渡假赌尊渡假赌How Long Does It Take To Beat Split Fiction?4 weeks ago By DDDR.E.P.O. Save File Location: Where Is It & How to Protect It?4 weeks ago By DDDTwo Point Museum: All Exhibits And Where To Find Them1 months ago By 尊渡假赌尊渡假赌尊渡假赌Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
PHP 8.4 Installation and Upgrade guide for Ubuntu and Debian
Dec 24, 2024 pm 04:42 PM
PHP 8.4 brings several new features, security improvements, and performance improvements with healthy amounts of feature deprecations and removals. This guide explains how to install PHP 8.4 or upgrade to PHP 8.4 on Ubuntu, Debian, or their derivati
How To Set Up Visual Studio Code (VS Code) for PHP Development
Dec 20, 2024 am 11:31 AM
Visual Studio Code, also known as VS Code, is a free source code editor — or integrated development environment (IDE) — available for all major operating systems. With a large collection of extensions for many programming languages, VS Code can be c
How to fix mysql_native_password not loaded errors on MySQL 8.4
Dec 09, 2024 am 11:42 AM
One of the major changes introduced in MySQL 8.4 (the latest LTS release as of 2024) is that the "MySQL Native Password" plugin is no longer enabled by default. Further, MySQL 9.0 removes this plugin completely. This change affects PHP and other app
How do you parse and process HTML/XML in PHP?
Feb 07, 2025 am 11:57 AM
This tutorial demonstrates how to efficiently process XML documents using PHP. XML (eXtensible Markup Language) is a versatile text-based markup language designed for both human readability and machine parsing. It's commonly used for data storage an
Midea launches its first DeepSeek air conditioner: AI voice interaction can achieve 400,000 commands!
Mar 12, 2025 pm 12:18 PM
Midea will soon release its first air conditioner equipped with a DeepSeek big model - Midea fresh and clean air machine T6. The press conference is scheduled to be held at 1:30 pm on March 1. This air conditioner is equipped with an advanced air intelligent driving system, which can intelligently adjust parameters such as temperature, humidity and wind speed according to the environment. More importantly, it integrates the DeepSeek big model and supports more than 400,000 AI voice commands. Midea's move has caused heated discussions in the industry, and is particularly concerned about the significance of combining white goods and large models. Unlike the simple temperature settings of traditional air conditioners, Midea fresh and clean air machine T6 can understand more complex and vague instructions and intelligently adjust humidity according to the home environment, significantly improving the user experience.
PHP Program to Count Vowels in a String
Feb 07, 2025 pm 12:12 PM
A string is a sequence of characters, including letters, numbers, and symbols. This tutorial will learn how to calculate the number of vowels in a given string in PHP using different methods. The vowels in English are a, e, i, o, u, and they can be uppercase or lowercase. What is a vowel? Vowels are alphabetic characters that represent a specific pronunciation. There are five vowels in English, including uppercase and lowercase: a, e, i, o, u Example 1 Input: String = "Tutorialspoint" Output: 6 explain The vowels in the string "Tutorialspoint" are u, o, i, a, o, i. There are 6 yuan in total
7 PHP Functions I Regret I Didn't Know Before
Nov 13, 2024 am 09:42 AM
If you are an experienced PHP developer, you might have the feeling that you’ve been there and done that already.You have developed a significant number of applications, debugged millions of lines of code, and tweaked a bunch of scripts to achieve op
Top 10 PHP CMS Platforms For Developers in 2024
Dec 05, 2024 am 10:29 AM
CMS stands for Content Management System. It is a software application or platform that enables users to create, manage, and modify digital content without requiring advanced technical knowledge. CMS allows users to easily create and organize content
