ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 我的一个php_mysql分页类(转)

我的一个php_mysql分页类(转)

原创 Linux操作系统 作者:jcszjswkzhou 时间:2019-04-21 09:09:06 0 删除 编辑
我的一个php_mysql分页类:


class RSPage {
var $Debug = 0;
var $sqoe = 1; // sqoe= show query on error
var $Link_ID = 0;
var $Record = array();
var $Row;
var $numRow;
var $Parse;
var $Error = "";
var $m_timeFmt = "YYYY-MM-DD HH24:MI:SS";

var $m_num=-1;
var $m_sql;
var $m_pageSize=10;
var $m_cmt;
var $m_curPage=1;
function open($DB_Link)
{
$this->Link_ID = $DB_Link;
}

function query($Query_String,$page=1,$cnt=-1,$size=10) {
if($Query_String=="")
{
echo "执行语句不能为空!";
return false;
}
if(!$page)
$page = 1;
if(!$cnt)
$cnt = -1;
$this->m_pageSize = $size;

if($this->Parse){
mysql_free_result($this->Parse);
}

if($cnt!=-1){
$this->m_num = $cnt;
}
else{
$result = mysql_query($Query_String, $this->Link_ID);
if(!$result){
$this->Error=mysql_error($this->Link_ID);
}
else{
$this->m_num = mysql_num_rows($result);
}
/*
$cntsql = "select count(*) max_num from ($Query_String)";
$maxnum = 0;
$result = mysql_query($sqlstr,$this->Link_ID);
$ret = mysql_fetch_array($result);
mysql_free_result($result);
if(!$ret) {
$this->Error=mysql_error($this->Link_ID);
}
else {
$this->m_num = $ret["max_num"];
}
*/

}
$pageCount = $this->getPageCount();
$pageSize = $this->getPageSize();
if($page>$pageCount)$page=$pageCount;
if($page<1)$page=1;
$this->m_curPage=$page;
$posBegin = ($page-1)*$pageSize;
$posEnd = $posBegin + $pageSize;
$Query_String = "$Query_String LIMIT $posBegin,$posEnd";
$this->Parse=mysql_query($Query_String,$this->Link_ID);

if(!$this->Parse) {
$this->Error=mysql_error($this->Link_ID);
}
$this->Row=0;

if($this->Debug) {
printf("Debug: query = %s
", $Query_String);
}

if ($this->Error && $this->sqoe)
echo "
".$this->Error["message"]."
Query :"$Query_String"
";
$numRow=mysql_num_rows($this->Parse);
return $this->Parse;
}
function setTimeFormat($timestr){
$this->m_timeFmt = $timestr;
}
function next_record() {
if(!($row = mysql_fetch_array($this->Parse))) {
mysql_free_result($this->Parse);
$this->Parse = false;
$stat=0;
}
else {
while(list($key,$val)=each($row)) {
$colreturn=strtolower($key);
$this->Record[ "$colreturn" ] = $val;
if($this->Debug) echo"[$key]:".$val."
";
}
$stat=1;
}

return $stat;
}

function record_exist() {
if(0 == mysql_num_rows($this->Parse)) {
return 0;
} else {
return 1;
}

return $stat;
}

function seek($pos) {
$this->Row=$pos;
}

function affected_rows() {
return mysql_affected_rows($this->Parse);
}

function num_rows() {
return mysql_num_rows($this->Parse);
}

function f($Name) {
return $this->Record[$Name];
}

function p($Name) {
print $this->Record[$Name];
}

function close() {
if($this->Debug) {
//printf("Disconnecting...
");
}
if($this->Parse){
mysql_free_result($this->Parse);
}
//mysql_close($this->Link_ID);
}

//---public 得到当前页
function getCurPage(){return $this->m_curPage;}
//---public 设定页长
function setPageSize($page_size){$this->m_pageSize = $page_size;}
//---public 得到页长
function getPageSize(){return $this->m_pageSize;}
//---public 得到纪录总数
function getCount(){return $this->m_num;}
//---public 得到页总数
function getPageCount(){
$page=floor($this->getCount()/$this->getPageSize());
if($this->getCount()%$this->getPageSize()>0)$page++;
return $page;
}
// 显示导航条。
// 参数说明: $url 调用页面ex:http://hello.php?showtype=main
function show_navibar($recname="条记录",$first="首页",$pre="上页",$next="下页",$last="末页"){
$showurl = getenv("REQUEST_URI");
$tmppos = strpos($showurl,"&rscnt=");
if(!$tmppos)
$tmppos = strpos($showurl,"?rscnt=");
if($tmppos)
$showurl = substr($showurl,0,$tmppos);
$url = $showurl;
$page = $this->getCurPage();
$pagecnt = $this->getPageCount();
$cnt = $this->getCount();
if($cnt < 0) // 没有分页,不显示任何东西。
return;

if(!strrchr($url,"?"))
$url = $url."?";
else // url已经带了参数。
$url = $url."&";

$url = $url."rscnt=".$cnt."&page=";

if($page>1){
?>
1> >
}
else{
?>

}

if($page<$pagecnt){
?>
> >
}
else{
?>

}
?>
共有 ,当前/ 
>页



}
}


来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/10294527/viewspace-122793/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2007-08-29

  • 博文量
    2820
  • 访问量
    2076571