一起来完善
<?php
/**
* 通用数据库操作类 PHP4
* @author 34298824@qq.com
*/
class DataManager
{
var $hostName='localhost';
var $userName='root';
var $password='34298824';
var $dbName='rss_feed';
function DataManager(){}
//打开数据链接
function open()
{
$conn= mysql_connect($this->hostName,$this->userName,$this->password)or die("connection failure");
mysql_select_db($this->dbName);
return $conn;
}
//打开数据链接
function xOpen()
{
$conn= mysql_connect($this->hostName,$this->userName,$this->password)or die("connection failure");
return $conn;
}
//关闭与数据库的链接
function close($_conn_){
mysql_close($_conn_);
}
//参数过滤
function filter($param){
return mysql_real_escape_string($param);
}
//通用选择查询
function select($sql){
$MapList=array();
$conn=$this->open();
$result= mysql_query($sql,$conn) or die(mysql_error());
while($row= mysql_fetch_array($result,MYSQL_ASSOC)){
$MapList[]=$row;
}
$this->close($conn);
return $MapList;
}
//通用更新
function update($sql){
$conn=$this->open();
mysql_query($sql,$conn) or die(mysql_error());
$rowNum=mysql_affected_rows();
$this->close($conn);
if($rowNum>-1)
{
return true;
}
return false;
}
/**
* 分页相关函数
*/
//得到当前页码
function pagecode($code){
$page_code=1;
if(isset($_GET[$code]))
{
$page_code=intval($_GET[$code]);
}
return $page_code;
}
//得到下一页查询记录的起始位置
function offset($code,$size){
$page_code=$this->pagecode($code);
return $size*($page_code-1);
}
//计算总页数
function pagecount($rowsnum,$pagesize){
$pages=intval($rowsnum/$pagesize);
if($rowsnum%$pagesize){
$pages++;
}
return $pages;
}
//查询记录集的总行数
function rowcount($sql,$key){
$MapList =$this->select($sql);
$len=count($MapList);
if($len>0){
return $MapList[0][$key];
}
return 0;
}
}
?>