欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  php教程

php mysql分页实现代码

程序员文章站 2022-03-30 08:31:07
...
这算是一款比较完美的分页类了,支持表单输入跳转,也支持select跳转分页,同时还支持上10页,下10页偏移分页哦。 */

这算是一款比较完美的分页类了,支持表单输入跳转,也支持select跳转分页,同时还支持上10页,下10页偏移分页哦。
*/

class wind_page
{
var $page;
//现在所在页
var $total;
//记录总条数
var $totalpage;
//总页树
var $pagesize;
//每页显示条数
var $offset;
//偏移量
var $result;
//记录集合
var $thispage;
//记录总条数 //记录总条数 //记录总条数
var $link;
//连接(记录$_get变量)
var $bar_mun;
//bar显示的页数
var $starttime;
//开始时间
var $bar_last;
//导航条的持续页数
var $bar_mid;
//导航条中间页
var $minpage;
//导航条最小页
var $maxpage;
//导航条最大页
var $key;
//标识分页(一个页面多个分页时用与区分)
var $style;
//输出的风格
var $pre_page_char;
//上一页
var $pre_page_image;
//上一页图形
var $pre_page_char_color;
//上一页字体颜色
var $next_page_char;
//下一页
var $next_page_image;
//下一页图形
var $next_page_char_color;
//下一页字体颜色
var $pre_groud_char;
//上翻中间页数
var $pre_groud_char_color;
//上翻中间页数字体颜色
var $next_groud_char;
//下翻中间页数
var $next_groud_char_color;
//下翻中间页数字体颜色
var $first_page_char;
//首页
var $first_page_char_color;
//首页字体颜色
var $last_page_char;
//尾页
var $last_page_char_color;
//尾页字体颜色
var $html_page_val;
//html当前的页码值

function wind_page($sql, $pagesize = 20, $bar_mun = 10, $style = 1,$this_page = 1,$html_page_val=1,$key = "") //构造函数()
{
$this->starttime = microtime();
$this->pagesize = $pagesize;
//每页显示条数
$this->key = trim($key);
$this->bar_mun = $bar_mun;
$this->style = $style;
$this->html_page_val = $html_page_val;
//html当前的页码值
$this->bar_last = $bar_mun-1;
$this->bar_mid = floor($bar_mun/2);
$this->sql = $sql;
$result = mysql教程_query($this->sql);
$this->total = mysql_num_rows($result);
//记录总条数
$this->totalpage = ceil($this->total/$this->pagesize);
//总页数
//$this->page = ceil($_get[$this->key."page"]);
$this->page = $this_page;
//现在所在页
if ($this->page == "" || $this->page 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 = "php mysql分页实现代码";
$this->next_page_char = "下一页";
$this->next_page_image = "php mysql分页实现代码";
$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 totalpage) {

return "page+1).".html" class="ab">".$this->next_page_char."";

} else {

return "".$this->next_page_char."";
}
}

function pre_groud($char = " {
if ($this->page bar_mid+1)) {
return "".$this->pre_groud_char."";
//return $this->pre_groud_char;
} else {
$pre_gpage = ($this->page-$this->bar_mid $this->page-$this->bar_mid;
return "".$this->pre_groud_char."";
}
}

function next_groud($char = ">>", $color = "#909090") //下一组
{
if (($this->totalpage-$this->page) bar_mid-1)) {
return "".$this->next_groud_char."";
} else {
$next_gpage = ($this->page+$this->bar_mid totalpage)?$this->page+$this->bar_mid:
$this->totalpage;
return "".$this->next_groud_char."";
}
}

function mun($lcolor = "#ff6633", $acolor = "#ff6633", $left = "&nbsp", $right = "&nbsp") //数字导航栏
{
$link = "";
$this->minpage = ($this->page-$this->bar_mid 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 maxpage-$this->bar_last;
}
for($i = $this->minpage; $i 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() //整条数字导航栏 [][>>]
{
//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()
{ //整条数字导航栏 []
//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 [][>>]
function page_bar($coloro = "#000000", $colorn = "red") {
return "









".$this->total_bar()." ".$this->mun_bar()." ".$this->jump_bar()."
".$this->mm_jumpmenu();
}

function taketime($color = "#000000") //计算执行时间
{
return "
本页执行时间".abs((microtime()-$this->starttime) * 1000)."毫秒
";
}

function style() //输出分页的样式
{
$style_num = $this->style;

if ($this->totalpage != 0) //如果总页数=0 ,表示无分页
{
switch($style_num) {
case 1:
return $this->page_bar();
//页次:1/4310 每页:20 共计:4310页 本页:20 [][>>]
break;
case 2:
echo $this->mun_bar();
//整条数字导航栏 [][>>]
break;
case 3:
echo $this->page_button();
//整条数字导航栏 []
break;
}
}
}

function mm_jumpmenu() //网页特效的跳转
{
//window.open(selobj.options[selobj.selectedindex].value,targ);
return "";
}

function first_groud($char = " if ($this->page == 1) {
return "".$char."";
} else {
//$pre_gpage=($this->page-$this->bar_midpage-$this->bar_mid;
$pre_gpage = 1;
return "key."page=".$pre_gpage.$this->link."" title="上一组">".$char."";
}
}

function last_groud($char = " >>", $color = "#000000") {
if ($this->page == $this->totalpage) {
return "".$char."";
} else {
//$pre_gpage=($this->page-$this->bar_midpage-$this->bar_mid;
$pre_gpage = $this->totalpage;
return "key."page=".$pre_gpage.$this->link."" title="上一组">".$char."";
}
}
}