>CurrentPage;
$this->PageSize=ceil(abs(@$pagesize+0));
(emptyempty($this->PageSize))?$this->PageSize=5:$this->PageSize=$this->PageSize;
$this->LeftOffSet=ceil(abs(@$leftoffset+0));
(emptyempty($this->LeftOffSet))?$this->LeftOffSet=2:$this->LeftOffSet=$this-
>LeftOffSet;
$this->RightOffSet=ceil(abs(@$rightoffset+0));
(emptyempty($this->RightOffSet))?$this->RightOffSet=7:$this->RightOffSet=$this-
>RightOffSet;
$this->PageUrl=$pageurl;
$this->SetDefaultTagValue();
}
//
取得记录总数
//$sql="select count(id) as n from table";
function GetRecordCount($sql,$conn){
$query=@mysql_query($sql,$conn);
if(!$query){echo "执行 sql 语句失败";exit();}
while($rs=mysql_fetch_row($query)){
$this->RecordCount=$rs[0];//
取得记录总数
}
$this->TotalPage=ceil($this->RecordCount / $this->PageSize);//
计算总页数
if($this->CurrentPage > $this->TotalPage){$this->CurrentPage=$this->TotalPage;}//判断当
前页是否大于总页数
mysql_free_result($query);
}
//select * from tb p->setlimit();
function SetLimit(){
$limit="LIMIT ".($this->CurrentPage-1)*$this->PageSize;
$limit.=",$this->PageSize";
return $limit;
}
function ExecuteSql($sql,$conn){
if(!$sql||!$conn){echo "参数传递错误";return false;}
$this->SqlQuery=mysql_query($sql,$conn);
if(!$this->SqlQuery){echo "执行 sql 语句失败";return false;}
}
function RecordSet(){
return mysql_fetch_array($this->SqlQuery);
}