<!--二泉.net --> <? class Pages{ var $cn; //连接数据库游标 var $d; //连接数据表的游标 var $result; //结果 var $dsn; //dsn源 var $user; //用户名 var $pass; //密码 var $total; //记录总数 var $pages; //总页数 var $onepage; //每页条数 var $page; //当前页 var $fre; //上一页 var $net; //下一页 var $i; //控制每页显示 function getConnect($dsn,$user,$pass){ $this->cn=@odbc_connect($dsn,$user,$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(!isset($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->i=0;$this->i<$pg->getNums();odbc_fetch_row($this->dd),$this->i++);//同上 /
查看更多关于一个odbc连mssql分页的类-PHP实例的详细内容...