php模块参考
2024-09-29 00:53:33
<?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() . "<br/>");
} }
} //数据库管理类
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."¶meter2=".$anothersearchstrs." class=".$class.">首页</a>";
else
$str.="<font color='#555555'>首页</font>";
$str.=" ";
if($this->nowpage!=1)
$str.="<a href=".$_SERVER['PHP_SELF']."?page=".($this->nowpage-1)."&page_type=".$anothersearchstr."¶meter2=".$anothersearchstrs." class=".$class.">上一页</a>";
else
$str.="<font color='#555555'>上一页</font>";
$str.=" ";
if($this->nowpage!=$pagecount)
$str.="<a href=".$_SERVER['PHP_SELF']."?page=".($this->nowpage+1)."&page_type=".$anothersearchstr."¶meter2=".$anothersearchstrs." class=".$class.">下一页</a>";
else
$str.="<font color='#555555'>下一页</font>";
$str.=" ";
if($this->nowpage!=$pagecount)
$str.="<a href=".$_SERVER['PHP_SELF']."?page=".$pagecount."&page_type=".$anothersearchstr."¶meter2=".$anothersearchstrs." class=".$class.">尾页</a>";
else
$str.="<font color='#555555'>尾页</font>";
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]","<strong>",$content);
$content=str_replace("[/strong]","</strong>",$content);
$content=str_replace("[em]","<em>",$content);
$content=str_replace("[/em]","</em>",$content);
$content=str_replace("[u]","<u>",$content);
$content=str_replace("[/u]","</u>",$content); $content=str_replace("[font color=#FF0000]","<font color=#FF0000>",$content);
$content=str_replace("[font color=#00FF00]","<font color=#00FF00>",$content);
$content=str_replace("[font color=#0000FF]","<font color=#0000FF>",$content); $content=str_replace("[font face=楷体_GB2312]","<font face=楷体_GB2312>",$content);
$content=str_replace("[font face=宋体]","<font face=新宋体>",$content);
$content=str_replace("[font face=隶书]","<font face=隶书>",$content);
$content=str_replace("[/font]","</font>",$content);
//$content=str_replace(chr(32)," ",$content);
$content=str_replace("[font size=1]","<font size=1>",$content);
$content=str_replace("[font size=2]","<font size=2>",$content);
$content=str_replace("[font size=3]","<font size=3>",$content);
$content=str_replace("[font size=4]","<font size=4>",$content);
$content=str_replace("[font size=5]","<font size=5>",$content);
$content=str_replace("[font size=6]","<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;
} } ?>
最新文章
- libev学习（一）
- swift 附属脚本
- tomcat发布项目时，localhost可以访问，用ip地址不能访问，同时其他电脑也不能访问。
- win10下安装centOS 7 U盘
- 去ECSHOP版权，去官方后门
- MySQL性能分析脚本
- python笔记之ZipFile模块
- MYSQL 注释的 3 方法
- 【knockoutjs】 Computed VS Pure Computed 区别
- 【java设计模式】【创建模式Creational Pattern】建造模式Builder Pattern
- (转载)SVM-基础(二)
- Ubuntu下使用Sublime Text 3配置Python开发环境
- CentOS6.5 下在Nginx中添加SSL证书
- 【java】Java组件概览（1）
- 转：ArcGIS中利用ArcMap将地理坐标系转换成投影坐标系（从WKID=4326到WKID=102100）
- java 注释annotation学习---两篇不错的blog
- Java 遍历类中的属性
- iTunes Connect开发者指南中的一个疑问
- perl(ExtUtils::Embed)依赖包
- 快速幂取模_C++