php模块参考

浏览数：33 / 时间：2015年06月09日

————————————————————————————————————————————————————————————————————————————

【转】php模块类参考

<?php
//数据库连接类
class ConnDB{

 var $dbtype;
 var $host;
 var $user;
 var $pwd;
 var $dbname;

 //构造方法
 function ConnDB($dbtype,$host,$user,$pwd,$dbname){
 $this->dbtype=$dbtype;
 $this->host=$host;
 $this->user=$user;
 $this->pwd=$pwd;
 $this->dbname=$dbname;
 }

 //实现数据库的连接并返回连接对象
 function GetConnId(){

 if($this->dbtype=="mysql" || $this->dbtype=="mssql"){
 $dsn="$this->dbtype:host=$this->host;dbname=$this->dbname";
 }else{
 $dsn="$this->dbtype:dbname=$this->dbname";
 }
 try {
 $conn = new PDO($dsn, $this->user, $this->pwd); //初始化一个PDO对象，就是创建了数据库连接对象$pdo
 $conn->query("set names utf8");
 return $conn;
 } catch (PDOException $e) {
 die ("Error!: " . $e->getMessage() . " ");
 }


 }
}

//数据库管理类
class AdminDB{


 function ExecSQL($sqlstr,$conn){

 $sqltype=strtolower(substr(trim($sqlstr),0,6));
 $rs=$conn->prepare($sqlstr); //准备查询语句
 $rs->execute(); //执行查询语句，并返回结果集
 if($sqltype=="select"){
 $array=$rs->fetchAll(PDO::FETCH_ASSOC); //获取结果集中的所有数据
 if(count($array)==0 || $rs==false)
 return false;
 else
 return $array;
 }elseif ($sqltype=="update" || $sqltype=="insert" || $sqltype=="delete"){
 if($rs)
 return true;
 else
 return false;
 }
 }
}
//分页类
class SepPage{
 var $rs;
 var $pagesize;
 var $nowpage;
 var $array;
 var $conn;
 var $sqlstr;
 function ShowData($sqlstr,$conn,$pagesize,$nowpage){ //定义方法
 if(!isset($nowpage) || $nowpage=="") //判断变量值是否为空
 $this->nowpage=1; //定义每页起始页
 else
 $this->nowpage=$nowpage;
 $this->pagesize=$pagesize; //定义每页输出的记录数
 $this->conn=$conn; //连接数据库返回的标识
 $this->sqlstr=$sqlstr; //执行的查询语句
 $offset=($this->nowpage-1)*$this->pagesize;
 $sql=$this->sqlstr." limit $offset, $this->pagesize";
 $result=$this->conn->prepare($sql); //准备查询语句
 $result->execute(); //执行查询语句，并返回结果集
 $this->array=$result->fetchAll(PDO::FETCH_ASSOC); //获取结果集中的所有数据
 if(count($this->array)==0 || $this->array==false)
 return false;
 else
 return $this->array;
 }

 function ShowPage($contentname,$utits,$anothersearchstr,$anothersearchstrs,$class){
 $str="";
 $res=$this->conn->prepare($this->sqlstr); //准备查询语句
 $res->execute(); //执行查询语句，并返回结果集
 $this->array=$res->fetchAll(PDO::FETCH_ASSOC); //获取结果集中的所有数据
 $record=count($this->array); //统计记录总数

 $pagecount=ceil($record/$this->pagesize); //计算共有几页
 $str.=$contentname." ".$record." ".$utits." 每页 ".$this->pagesize." ".$utits." 第 ".$this->nowpage." 页/共 ".$pagecount." 页";
 $str.="    ";
 if($this->nowpage!=1)
 $str.="<a href=".$_SERVER[‘PHP_SELF‘]."?page=1&page_type=".$anothersearchstr."&parameter2=".$anothersearchstrs." class=".$class.">首页</a>";
 else
 $str.="首页";
 $str.=" ";
 if($this->nowpage!=1)
 $str.="<a href=".$_SERVER[‘PHP_SELF‘]."?page=".($this->nowpage-1)."&page_type=".$anothersearchstr."&parameter2=".$anothersearchstrs." class=".$class.">上一页</a>";
 else
 $str.="上一页";
 $str.=" ";
 if($this->nowpage!=$pagecount)
 $str.="<a href=".$_SERVER[‘PHP_SELF‘]."?page=".($this->nowpage+1)."&page_type=".$anothersearchstr."&parameter2=".$anothersearchstrs." class=".$class.">下一页</a>";
 else
 $str.="下一页";
 $str.=" ";
 if($this->nowpage!=$pagecount)
 $str.="<a href=".$_SERVER[‘PHP_SELF‘]."?page=".$pagecount."&page_type=".$anothersearchstr."&parameter2=".$anothersearchstrs." class=".$class.">尾页</a>";
 else
 $str.="尾页";
 if(count($this->array)==0 || $this->array==false)
 return "无数据！";
 else
 return $str;
 }
}
//系统常用方法
class UseFun{

 function UnHtml($text){
 $content=(nl2br(htmlspecialchars($text)));
 $content=str_replace("[strong]","",$content);
 $content=str_replace("[/strong]","",$content);
 $content=str_replace("[em]","",$content);
 $content=str_replace("[/em]","",$content);
 $content=str_replace("[u]","",$content);
 $content=str_replace("[/u]","",$content);


 $content=str_replace("[font color=#FF0000]","",$content);
 $content=str_replace("[font color=#00FF00]","",$content);
 $content=str_replace("[font color=#0000FF]","",$content);

 $content=str_replace("[font face=楷体_GB2312]","",$content);
 $content=str_replace("[font face=宋体]","",$content);
 $content=str_replace("[font face=隶书]","",$content);
 $content=str_replace("[/font]","",$content);
 //$content=str_replace(chr(32)," ",$content);
 $content=str_replace("[font size=1]","",$content);
 $content=str_replace("[font size=2]","",$content);
 $content=str_replace("[font size=3]","",$content);
 $content=str_replace("[font size=4]","",$content);
 $content=str_replace("[font size=5]","",$content);
 $content=str_replace("[font size=6]","",$content);

 $content=str_replace("[FIELDSET][LEGEND]","<FIELDSET><LEGEND>",$content);
 $content=str_replace("[/LEGEND]","</LEGEND>",$content);
 $content=str_replace("[/FIELDSET]","</FIELDSET>",$content);
 return $content;
 }

}

?>