四虎精品视频-四虎精品成人免费网站-四虎黄色网-四虎国产视频-国产免费91-国产蜜臀97一区二区三区

php mssql 分頁SQL語句優化 持續影響

復制代碼 代碼如下:
<?php
/**
* @Filename :page.sql.class.php
* @CreatTime :2009-01-06
* @Descrition :此類為SQL語句處理類。
* @UpdateTime-1 :null
* @Version :jswweb1.0.0
* @Author :fkedwgwy
* @Dome :
$sql//SQL語句
$allcount//總記錄數
$pagesize//頁面顯示記錄條數
$page//當前頁
$sqlc= new sqlpage($sql,$allcount,$pagesize,$page);
$sql=$sqlc->getsql();
優化后的語句:
SELECT * FROM (SELECT TOP 10 * FROM (SELECT TOP 270 Lsh,Ztm,Dyzrsm,Dyzzfs,Cbsm,Cbny,Ssh,Fbsl,jcsl from ts_gcb where Ssh like 'C%' order by Lsh asc) AS inner_tbl ORDER BY Lsh DESC) AS outer_tbl ORDER BY Lsh asc
*/
class sqlpage{
function sqlpage($sql,$allcount,$pagesize,$page){
$this->sql= $sql;//查詢語名
$this->allcount= intval($allcount);//總記錄數
$this->pagesize= intval($pagesize);//頁面大小(顯示記錄數)
$this->page= intval($page);//當前頁
$this->getpage();
$this->gettop();
}
function getpage(){ //獲取當前頁
$this->allpage=ceil( $this->allcount/$this->pagesize);//去當前小數的最大整數
if ($this->page=="" or $this->page>$this->allpage or $this->page<0 or $this->page==0){
$this->page2=1;
}else{
$this->page2=intval($this->page);//將頁碼轉換為數字
}
}
function gettop(){ //獲取子查詢2的TOP大小
if ($this->page2<$this->allpage){
$this->top2=$this->pagesize;
}else{
$this->top2=$this->allcount-$this->pagesize*($this->allpage-1);
}
}
/* function getsql(){//獲取SQL語句
$this->s=preg_replace("/select/i","",$this->sql);
$this->top1=$this->pagesize*$this->page2;
$this->sql1="SELECT TOP $this->top1 $this->s";
if (strpos($this->sql,"asc")){//升序
$this->sql_e="select * from ( select TOP $this->top2 * FROM ( $this->sql1 ) as aSysTable ORDER BY $this->order DESC ) as bSysTable ORDER BY $this->order ASC";
}else
//$this->sql_e="select * from ( select TOP $this->top2 * FROM ( $this->sql1 ) as aSysTable ORDER BY $this->order DESC ) as bSysTable ORDER BY $this->order ASC";
if (strpos($this->sql,"desc")){//降序
$this->sql_e="select * from ( select TOP $this->top2 * FROM ( $this->sql1 ) as aSysTable ORDER BY $this->order asc ) as bSysTable ORDER BY $this->order desc";
}else{//不處理排序的情況
$this->sql_e="select * from ( select TOP $this->top2 * FROM ( $this->sql1 ) as aSysTable ORDER BY $this->order DESC ) as bSysTable ORDER BY $this->order ASC";
}
// echo $this->sql_e;
return $this->sql_e;
}*/
function getsql()
{
$sql=$this->sql;
$this->top1=$this->pagesize*$this->page2;
$orderby = stristr($sql, 'ORDER BY');
if ($orderby !== false) {
$sort = (stripos($orderby, ' desc') !== false) ? 'desc' : 'asc';
$order = str_ireplace('ORDER BY', '', $orderby);
$order = trim(preg_replace('//bASC/b|/bDESC/b/i', '', $order));
}
$sql = preg_replace('/^SELECT/s/i', 'SELECT TOP ' . ($this->top1) . ' ', $sql);
$sql = 'SELECT * FROM (SELECT TOP ' . $this->top2 . ' * FROM (' . $sql . ') AS inner_tbl';
if ($orderby !== false) {
$sql .= ' ORDER BY ' . $order . ' ';
$sql .= (stripos($sort, 'asc') !== false) ? 'DESC' : 'ASC';
}
$sql .= ') AS outer_tbl';
if ($orderby !== false) {
$sql .= ' ORDER BY ' . $order . ' ' . $sort;
}
echo $sql;
return $sql;
}
}
?>

php技術php mssql 分頁SQL語句優化 持續影響,轉載需保留來源!

鄭重聲明:本文版權歸原作者所有,轉載文章僅為傳播更多信息之目的,如作者信息標記有誤,請第一時間聯系我們修改或刪除,多謝。

主站蜘蛛池模板: 黑帮大佬365天| 成品直播大全免费观看| 伺机偏宠短剧免费观看| 四川经济频道节目表| 火柴人游戏机怎么做| 感谢有你简谱| 女人高潮私密按摩视频| 孕检时间表和项目| 张少| 我的宇宙| 打开双腿扒开打屁股羞辱惩罚视频 | jenna haze| 秦皇岛电视台| 二年级100个词语| 黄造时个人简历| 显示驱动| 红电视剧演员表| 电影《48天》免费观看全集| 白璐个人简介照片| 秀人网门户网免费| 第一财经直播电视直播 现场直播| 世界轮廓图| 小矮人的一级毛片| 拉雅| 白上之黑| 啊嗯啊| 2014春节联欢晚会| 暮光之城1高清完整版| 罗比威廉姆斯| 五上竖式计算300道及答案| 凯特·玛拉| 学生基本情况分析| 丰满少妇a级片| 无涯:杜琪峰的电影世界 电影| 黑帆第三季电视剧完整免费观看高清| 速度与激情9| 红剪花| 汪汪队完整版全集免费 | 母亲电影韩国完整版免费观看| 雪山飞狐 1991 孟飞| 六年级下册语文书50页内容|