关于分页的问题
一个分页的源码,原来只有上页\下页的连接.先在我想再加个首页和尾页的连接.加完报错.请朋友指教:
代码如下:
<?php
class TOracleViewPage {
var $Table; //表名
var $MaxLine; //每页显示行数
var $LinkId; //数据库连接号
var $Id; //排序参考字段
var $Offset; //记录偏移量
var $Total; //记录总数
var $Number; //本页读取的记录数
var $TopNumber;//读新记录时实际取出的记录数
var $Result; //读出的结果
var $TopResult;//读新记录时的结果
var $Linkpage;//分页联结
var $TheFirstPage;//特殊指定第一页的链接
var $StartRec; //指定第二页的起始记录号
var $TPages; //总页数
var $CPages; //当前页数
var $TGroup;
var $PGroup; //每页显示的页号个数
var $CGroup;
var $Condition; //显示条件 如:where id='$id' order by id desc
var $PageQuery; //分页显示要传递的参数
//-------------------------------------
// 以下构造函数、析构函数及初始化函数
//-------------------------------------
//构造函数
//参数:表名、最大行数、分页参考的字段、每页显示的页号数
function TOracleViewPagel($TB,$MAL,$id){
global $offset;
$this->Table=$TB;
$this->MaxLine=$MAL;
$this->Id=$id;
$this->StartRec=0;
if(isset($offset)) $this->Offset=$offset;
else $this->Offset=0;
$this->Condition="";
$this->TheFirstPage=NULL;
$this->PageQury=NULL;
}
//初始化
//参数:用户名、密码、数据库
function InitDB(){
//if (PHP_OS == "WINNT") $dllid=dl("php_oci80.dll");
global $USER,$PASSWORD,$DATAHOST,$SID;
$this->LinkId = OCILogon("$USER", "$PASSWORD", "(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=$DATAHOST)(port=1521))(connect_data=(sid=$SID)))");
}
//断开
function Destroy(){
OCILogoff($this->LinkId);
}
//-------------------------
// Set 函数
//-------------------------
//设置显示条件
//如:where id='$id' order by id desc
//要求是字串,符合SQL语法(本字串将加在SQL语句后)
function SetCondition($s){
$this->Condition=$s;
}
//设置每组的显示个数
function SetNumGroup($pg){
$this->PGroup=$pg;
}
//设置首页,如无则为NULL
function SetFirstPage($fn){
$this->TheFirstPage=$fn;
}
//设置起始记录,如无则取默认0
function SetStartRecord($org){
$this->StartRec=$org;
}
//设置传递参数
// key参数名 value参数值
// 如:setpagequery("id",$id);如有多个参数要传递,可多次调用本函数。
function SetPageQuery($key,$value){
$tmp[key]=$key; $tmp[value]=$value;
//cho $key,$tmp[value];
$this->PageQuery[]=$tmp;
}
//--------------------------------
// Get 函数
//--------------------------------
//取记录总数
function GetTotalRec(){
$SQL="SELECT Count(*) AS total FROM ".$this->Table." ".$this->Condition;
$stmt = OCIParse($this->LinkId,$SQL);
$bool = OCIExecute($stmt);
if (!$bool) {
echo "连接失败!";
OCILogoff($this->LinkId);
exit;
}
else {
OCIFetch($stmt);
$this->Total=OCIResult($stmt,1);
}
OCIFreeStatement($stmt);
return $this->Total;
}
//取总页数、当前页
function GetPage(){
$this->TPages=ceil($this->Total/$this->MaxLine);
$this->CPages=ceil($this->Offset/$this->MaxLine)+1;
}
//取总组数、当前组
function GetGroup() {
$this->TGroup=ceil($this->TPages/$this->PGroup);
$this->CGroup=ceil($this->CPages/$this->PGroup);
}
function ReadList($T_name) {
$SQL="SELECT $T_name FROM ".$this->Table." ".$this->Condition." ORDER BY ".$this->Id." ";
$stmt = OCIParse($this->LinkId,$SQL);
$bool = OCIExecute($stmt);
if (!$bool) {
echo "连接失败!";
OCILogoff($this->LinkId);
exit;
}
else {
$ncols = OCINumCols($stmt);
for ( $i = 1; $i <= $ncols; $i++ )
$column_name[$i] = OCIColumnName($stmt,$i);
$k=0;
for($j=0;$j<$this->StartRec+$this->Offset;$j++) OCIFetch($stmt);
for($j=0;$j<$this->MaxLine;$j++){
if(OCIFetch($stmt)){
$k++;
for($i=1;$i<=$ncols;$i++)
$templist[$j][$i]=OCIResult($stmt,$i);
}
else break;
}
$this->Number=$k;
}
OCIFreeStatement($stmt);
return $templist;
}
//读最新的记录
//topnum指定要读出的记录数
function ReadTopList($topnum){
$SQL="SELECT * FROM ".$this->Table." ".$this->Condition." ORDER BY ".$this->Id." DESC";
$stmt = OCIParse($this->LinkId,$SQL);
$bool = OCIExecute($stmt);
if (!$bool) {
echo "连接失败!";
OCILogoff($this->LinkId);
exit;
}
else {
$ncols = OCINumCols($stmt);
for ( $i = 1; $i <= $ncols; $i++ )
$column_name[$i] = OCIColumnName($stmt,$i);
$k=0;
for($j=0;$j<$topnum;$j++){
if(OCIFetch($stmt)){
$k++;
for($i=1;$i<=$ncols;$i++)
$temp[$j][$i]=OCIResult($stmt,$i);
$this->TopResult[]=$temp;
}
else break;
}
$this->TopNumber=$k;
}
OCIFreeStatement($stmt);
return $TopResult;
}
//---------------------------
// 分页相关
//---------------------------
//显示当前页及总页数
//本函数在GetPage()后调用。
function ThePage() {
$this->thepage= "第".$this->CPages."页/共".$this->TPages."页";
return $this->thepage;
}
//显示翻页按钮
//此函数要在GetPage()函数之后调用
//显示下页、上页,并加上要传递的参数
function Page() {
$k=count($this->PageQuery);
$strQuery=""; //生成一个要传递参数字串
for($i=0;$i<$k;$i++){
$strQuery.="&".$this->PageQuery[$i][key]."=".$this->PageQuery[$i][value];
}
return $strQuery;
}
function FistPage($strQuery){
$this->FistPage ="<A href=$PHP_SELF?offset=0".$strQuery."&Ok=1 class=newslink>首页</A>";
retrun $this->FistPage;
}
function PrePage($strQuery){
$prev=$this->Offset-$this->MaxLine;
if($prev>=0)
$this->prepg= "<A href=$PHP_SELF?offset=".$prev.$strQuery."&Ok=1 class=newslink>上一页</A>";
else if($this->TheFirstPage!=NULL)
$this->prepg= "<A href=".$this->TheFirstPage." class=newslink>上一页</A>";
else $this->prepg= "上一页";
return $this->prepg;
}
function NexPage($strQuery){
$next=$this->Offset+$this->MaxLine;
$k=$this->Total-$this->StartRec;
if($next<$k)
$this->Nextpg= "<A href=$PHP_SELF?offset=".$next.$strQuery."&Ok=1 class=newslink>下一页</A>";
else
$this->Nextpg= "下一页";
return $this->Nextpg;
}
function LastPage($strQuery){
$last=$this->MaxLine *($this->TPages-1);
$this->Lastpg="<A href=$PHP_SELF?offset=".$last.$strQuery."&Ok=1 class=newslink>尾页</A>";
retrun $this->Lastpg;
}
//------------------------------------
// 记录分组
//----------------------------------
//显示分组
function NumPage() {
$first=($this->CGroup-1)*($this->PGroup)+1;
$last=($first+$this->PGroup > $this->TPages)? ($this->TPages+1):($first+$this->PGroup);
$pr=($this->CGroup-2>=0)?( ($this->CGroup-2)*($this->PGroup)+1 ):(-1);
$prev=($pr!=-1)?( ($pr-1)*$this->MaxLine):(0);
$ne=($this->CGroup*$this->PGroup+1<=$this->TPages)?($this->CGroup*$this->PGroup+1):(-1);
$next=($ne!=-1)?( ($ne-1)*$this->MaxLine):(0);
$k=count($this->PageQuery);
$strQuery=""; //生成一个要传递参数字串
for($i=0;$i<$k;$i++){
$strQuery.="&".$this->PageQuery[$i][key]."=".trim($this->PageQuery[$i][value]);
}
if($first!=1)
$this->Linkpage[0]="<A href=$PHP_SELF?offset=".$prev.$strQuery."&Ok=1 ><<</a>";
for($i=$first;$i<$last;$i++) {
if($this->CPages!=$i){
$current=($i-1)*$this->MaxLine;
$this->Linkpage[$i]= "<A href=$PHP_SELF?offset=".$current.$strQuery."&Ok=1 >".$i."</a> ";
}
else $this->Linkpage[$i]= "<font color=#e00729>".$i."</font> ";
}
if($ne!=-1)
$this->Linkpage[$i+1]="<A href=$PHP_SELF?offset=".$next.$strQuery."&Ok=1 >>> </a>";
return $this->Linkpage;
}
//******end class
}
?>
__________________
其中我自己加的首页部分报错:Parse error: parse error, unexpected T_VARIABLE in D:\zhangxc\multpage.php on line 234
function FistPage($strQuery){
$this->FistPage ="<A href=$PHP_SELF?offset=0".$strQuery."&Ok=1 class=newslink>首页</A>";
retrun $this->FistPage;
}