电脑安全

您当前的位置:主页 > 电脑安全 >

php经典分页类-网络编程

来源:[db:来源]标题:   分页    编辑:电脑技术全能网 时间:2019-09-19 18:28

原标题:php经典分页类-网络编程
   php典范分页类<?phpclass db{public $conn,$db,$table,$user,$host,$unm,$pwd;public $res;public $char;public $linkType;function __construct($linkType=false,$char="gb2312"){ $this->linkType=$linkType;//设定衔接范例 $this->char=$char;//设定衔接校订字符 $this->db=DB; $this->user=USER; $this->host=HOST; $this->unm=UNM; $this->pwd=PWD; if($this->linkType) { $this->conn=mysql_pconnect($this->host,$this->unm,$this->pwd) or die("Database connection failure"); } else { $this->conn=mysql_connect($this->host,$this->unm,$this->pwd) or die("Database connection failure"); } mysql_select_db($this->db); mysql_query("set names ".$this->char); }function query($sql,$type="true"){ //$type:默许的操纵。 指代select操纵 $this->res=mysql_query($sql) or die("SQL Statement error !Please check it again"); $row=$type?mysql_num_rows($this->res):mysql_affected_rows(); $result["res"]=$this->res; $result["row"]=$row; return $result;}//fetch()方式:猎取全部的记载,并写入数组function fetch($sql){ $res=self::query($sql); while ($rs=mysql_fetch_array($res["res"])) { $result[]=$rs; } return $result;}//猎取下一笔记录function fetchNext($filed,$currenID,$table){ $sql="select * from $table where $filed>$currenID limit 0,1 "; return self::fetch($sql);}//猎取前一笔记录function fetchPre($filed,$currenID,$table){ $sql="select * from $table where $filed<$currenID limit 0,1 "; return self::fetch($sql);} }class page extends db {public $currentPage,$totalRecord,$totalPage,$pageSize;public $start;public $flag;public $sql;function __construct($sql,$pagesize=5,$flag="page"){ $this->sql=$sql; $this->pageSize=$pagesize; $this->flag=$flag;//设定翻页链接标识符 $row=parent::query($sql); $this->totalRecord=$row["row"]; $this->totalPage=ceil($this->totalRecord/$this->pageSize); $page=$_REQUEST[$this->flag]; if($page<0||$page=="") { $this->currentPage=1; } else { $page>$this->totalPage?$this->currentPage=$this->totalPage:$this->currentPage=$page; } $this->start=($this->currentPage-1)*$this->pageSize; }//表现分页列表function show($page=10){ $str.='<div class="pages_btns"><div class="pages">'; $str.="<em> ".$this->totalRecord." </em>"; $pre=$this->currentPage-1; if($pre!=0) { $str.='<a href=?'.$this->flag.'='.$pre.' class=next><<</a>'; } if($this->currentPage>=$page) { if($this->totalPage-$this->currentPage<10) { $start=$this->currentPage-($this->currentPage%10); $end=$this->totalPage; } else { $start=$this->currentPage-2; $end=$start+$page-1; } } else { $start=1; $end=10; } for ($i=$start;$i<=$end;$i++) { if($i==$this->currentPage) { $str.="<strong>".$i."</strong>"; } else { $str.="<a href=?".$this->flag."=$i>$i</a>"; } } $next=$this->currentPage+1; $str.='<a href=?'.$this->flag.'='.$next.' class=next>>></a>'; $str.="<a href=?".$this->flag."=".$this->totalPage." class=last>...".$this->totalPage."</a>"; $str.="<kbd><input type='text' name='custompage' size='3' onkeydown=/"if(event.keyCode==13) {window.location='{$_SERVER['PHP_SELF']}?{$this->flag}='+this.value; return false;}/" /></kbd>"; $str.="</div></div>"; return $str;}}?><?phpdefine("HOST","localhost");define("UNM","root");define("PWD","root");define("DB","test");require_once('db.class.php');$db=new db();$sql="select * from yy"; $page=new page($sql,10); $sql.=" limit $page->start,$page->pageSize";$rs = $db->fetch($sql);?><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="#FF0000"> <tr> <td height="25" bgcolor="#FFFFFF">ID</td> <td bgcolor="#FFFFFF">UNM</td> </tr> <?php for($i=0;$i<count($rs);$i++) { ?> <tr> <td height="25" bgcolor="#FFFFFF"><?=$rs[$i][0]?></td> <td bgcolor="#FFFFFF"><?=$rs[$i][1]?></td> </tr> <?php } ?> <tr> <td height="25" colspan="2" bgcolor="#FFFFFF"><?=$page->show()?></td> </tr></table>

上一篇:smarty结合xajax检测用户名-网络编程

下一篇:没有了