一个odbc连mssql分页的类

<!–二泉.net –>

<?

class pages{

var $cn;//连接数据库游标

var $d;//连接数据表的游标

var $result;//结果

var $dsn;//dsn源

var $ur;//用户名

var $pass;//密码

var $total;//记录总数

var $pages;//总页数

var $onepage;//每页条数

var $page;//当前页

var $fre;//上一页

var $net;//下一页

var $i;//控制每页显示

function getconnect($dsn,$ur,$pass){

$this->cn=@odbc_connect($dsn,$ur,$pass);

if(!$this->cn){

$生日卡片祝福语error=”连接数据库出错”;

$this->getmess($error);

}

}

function getdo($sql){//从表中查询数据

$this->d=@odbc_do($this->cn,$sql);

if(!$this->d){

$error=”查询时发生了小错误……”;

$this->getmess($error);

}

return $this->d;

}

function gettotal($sql){

$this->sql=$sql;

$dt=$this->getdo($this->sql);//求总数的游标

$this->total=odbc_result($dt,’total’);//这里为何不能$this->d呢？

return $this->total;

}

function getlist($sql,$onepage,$page){

$this->s=$sql;

$this->onepage=$onepage;

$this->page=$page;

$this->dlist=$this->getdo($this->s);//连接表的游标

$this->pages=ceil($this->total/$this->onepage);

if($this->pages==0)

$this->pages++; //不能取到第0页

if(!ist($this->page))

$this->page=1;

$this->fre = $this->page-1;//将显示的页数

$this->nxt = $this->page+1;

$this->nums=($this->page-1)*$this->onepage;

//if($this->nums!=0){

//for($this-&初三下学期班主任工作计划gt;i=0;$this->i<$pg->getnums();odbc_fetch_row($this->dd),$this->i++);//同上

//}

//$this->i=0;//为何这部分不能封装？

return $this->dlist;

}

function getfanye(){

$str=””;

if($this->page!=1)

$str.=”<a href=”.$php_lf.”手抄报五一劳动节 简单;?page=1> 首页 </a><a href=”.$php_lf.”?page=”.$this->fre.”> 前页 &l高中生物必修2教案t;/a>”;

el有理想

$str.=”<font color=999999>首页 前页</font>”;

if($this->page<$this->pages)

$str.=”<a href=”.$php_lf.”?page=”.$this->nxt.”> 后页 </a>”;

el

$str.=”<font color=999999> 后页 </font>”;

if($this->page!=$this->pages)

$str.=”<a href=”.$php_lf.”?page=”.$this->pages.”> 尾页 </a>”;

el

$str.=”<font color=999999> 尾页 </font>”;

$str.=”共”.$this->pages.”页”;

$str.=”您正浏览第<font color=red>”.$this->page.”</font>页”;

return $str;

}

function getnums(){

return $this->nums;

}

function getonepage(){//每页实际条数

return $this->onepage;

}

function geti(){

return $this->i;

}

function getpage(){

return $this->page;

}

function getmess($error){//定制消息

echo”<center>$error</center>”;

exit;

}

}

$pg=new pages();

$pg->getconnect(“lei”,”sa”,”star”);

$pg->gettotal(“lect count(*) as total from xs”);//连学生表求总数

$pg->getlist(“lect xs_name from xs order by xs_id”,8,$page);

if($pg->getnums()!=0){

for($i=0;$i<$pg->getnums();odbc_fetch_row($pg->dlist),$i++);//同上

}

$i=0;

while(odbc_fetch_row($pg->dlist)){

$name=odbc_result($pg->dlist,”xs_name”);

echo $name.”<br>”;

if($i==$pg->getonepage()){//跳出循环

break;

}

$i++;

}

echo$pg->getfanye();

?>