一个odbc连mssql分页的类

!–二泉.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++);//同上//}//$this-i=0;//为何这部分不能封装?return
$this-dList; }function getFanye(){$str=;if($this-page!=1)$str.=a
href=.$PHP_SELF.?page=1 首页 /aa href=.$PHP_SELF.?page=.$this-fre.
前页 /a;else$str.=font color=999999首页
前页/font;if($this-page$this-pages)$str.=a
href=.$PHP_SELF.?page=.$this-nxt. 后页 /a;else$str.=font color=999999
后页 /font;if($this-page!=$this-pages)$str.=a
href=.$PHP_SELF.?page=.$this-pages. 尾页 /a;else$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){//定制消息echocenter$error/center;exit;}}$pg=new
Pages();$pg-getConnect(lei,sa,star);$pg-getTotal(select count(*) as
total from xs);//连学生表求总数$pg-getList(select 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();?

cn=@odbc_connect;if{$error=”连接数据库出错”;$this->getMess;}
}function
getDo{//从表中查询数据$this->d=@odbc_do;if{$error=”查询时发生了小错误……”;$this->getMess;}return
$this->d;}function
getTotal{$this->sql=$sql;$dT=$this->getDo;//求总数的游标$this->total=odbc_result;//这里为何不能$this->d呢?return
$this->total; }function
getList{$this->s=$sql;$this->onepage=$onepage;$this->page=$page;$this->dList=$this->getDo;//连接表的游标$this->pages=ceil($this->total/$this->onepage);if
$this->pages++; //不能取到第0页if $this->page=1;$this->fre =
$this->page-1;//将显示的页数$this->nxt = $this->page+1;
$this->nums=*$this->onepage;
//if{//for($this->i=0;$this->igetNums();odbc_fetch_row,$this->i++);//同上//}//$this->i=0;//为何这部分不能封装?return
$this->dList; }function
getFanye(){$str=””;if$str.=”首页fre.”>
前页”;else$str.=”首页
前页”;if($this->pagepages)$str.=”nxt.”>
后页”;else$str.=”
后页 “;if($this->page!=$this->pages)$str.=”pages.”>
尾页”;else$str.=”
尾页
“;$str.=”共”.$this->pages.”页”;$str.=”您正浏览第”.$this->page.”页”;return
$str;}function getNums(){return $this->nums;}function
getOnepage(){//每页实际条数return $this->onepage;}function
getI(){return $this->i;}function getPage(){return
$this->page;}function getMess{//定制消息echo”$error”;exit;}}$pg=new
Pages();$pg->getConnect(“lei”,”sa”,”star”);$pg->getTotal as total
from xs”);//连学生表求总数$pg->getList(“select xs_name from xs order
by xs_id”,8,$page);
if{for($i=0;$igetNums();odbc_fetch_row;//同上}$i=0;while(odbc_fetch_row{$name=odbc_result($pg->dList,”xs_name”);echo
$name.”
“;if){//跳出循环break;}$i++;}echo$pg->getFanye();?>

? require “config.php”; dl(“extensions/php_mssql70.dll”); if
(!isset($page)) { $page=1; } if ($page=0) { $page=1; }
$db=mssql_connect($local,$user,$pass); mssql_select_db($name,$db);
$query=mssql_query(“select count(*) as date from news”,$db);
$query=mssql_fetch_array($query);
$pages=ceil($query[0]/$userperpage); if ($page$pages) { $page=$pages;}
if ($query[0]$userperpage) { $userperpage=$query[0]; }
$dangqian=($page-1)*$userperpage; echo “titleNews/title”; echo “style
type=text/css”; echo “!–“; echo “A{text-decoration:none}”; echo
“A:hover{color:blue;; text-decoration: underline}”; echo “td {font-size:
9pt}”; echo “–/style”; echo “div align=centercenter”; echo “table
border=0 width=100% cellspacing=0 cellpadding=0 height=19”; echo “tr”;
echo ” td width=52% colspan=5img src=xw.gif width=100%/td/tr”; echo
“tr”; echo “td width=52% height=19 valign=bottom bgcolor=#B5C6B0p
align=centerfont”; echo “color=#408080新闻标题/font/td”; echo “td
width=14% height=19 valign=bottom align=center bgcolor=#B5C6B0font”;
echo “color=#408080发表日期/font/td”; echo “td width=19% height=19
valign=bottom align=center bgcolor=#B5C6B0font”; echo
“color=#408080发表部门/font/td”; echo “td width=7% height=19
valign=bottom align=center bgcolor=#B5C6B0font”; echo
“color=#408080阅读/font/td”; echo “td width=8% height=19 valign=bottom
align=center bgcolor=#B5C6B0font”; echo “color=#408080图像/font/td”;
echo “/tr”; echo “/table”; echo “/center/div”; echo “div
align=centercenter”; echo “table border=0 width=100% cellspacing=0
cellpadding=0 height=19”; $db=mssql_connect($local,$user,$pass);
mssql_select_db($name,$db); $query=mssql_query(“select * from news
order by date desc”,$db); $roro=mssql_num_rows($query); if ($roro==0)
{ echo “brbrp align=”center”font color=”#FF0000″ size=”2″marquee
behavior=”alternate” border=”0″ width=”300″ height=”16″
scrolldelay=”70″目前数据库中无任何记录!/marquee/font/p”; exit; }
mssql_data_seek($query,$dangqian); $i=0; while
($arr=mssql_fetch_array($query)) { if ($i=$userperpage) { break;} echo
“tr”; echo “td width=52% bgcolor=#F3F3F3 height=19 valign=bottomp
align=lefta href=”readnews.php?id=$arr[date]” target=”_blank”font
color=#3D5449$arr[title]/font/a/td”;
$datee=date(“Y-m-d”,$arr[date]); echo “td width=14% bgcolor=#F3F3F3
height=19 valign=bottom align=centerfont color=#3D5449$datee/font/td”;
echo “td width=19% bgcolor=#F3F3F3 height=19 valign=bottom
align=centerfont color=#3D5449$arr[type]/font/td”; echo “td width=7%
bgcolor=#F3F3F3 height=19 valign=bottom align=centerfont
color=#808080$arr[click]/font/td”; echo “td width=8% bgcolor=#F3F3F3
height=19 valign=bottom align=center”;
$arr[photo]=trim($arr[photo]); if (($arr[photo]””) ||
(file_exists($arr[photo]))) { echo “img src=picture.gif”; } else {
echo “nbsp;”; } echo “/td”; echo “/tr”; $i++; }//while echo “tr”; echo
“td width=100% height=20 colspan=5/td”; echo “/tr”; echo “trtd
width=100% colspan=5center”; if ($page1) { echo “a
href=$PHP_SELF?page=1font color=#408080首页/font/a”; } if ($page1) {
$upage=$page-1; echo “a href=$PHP_SELF?page=$upagefont
color=red/font/a”; } for($y=1;$y=$pages;$y++) { echo “a
href=$PHP_SELF?page=$y$y/a”; } if ($page$pages) { $npage=$page+1; echo
“a href=$PHP_SELF?page=$npagefont color=red/font/a”; } if
($page$pages){ echo “a href=$PHP_SELF?page=$pagesfont
color=#408080尾页/font/a”; } echo “/center/td”; echo “/tr”; echo
“/table”; echo “/center/div”; ?

You can leave a response, or trackback from your own site.

Leave a Reply

网站地图xml地图