php实现比较全的数据库操作类
本文实例讲述了php实现比较全的数据库操作类。分享给大家供大家参考。具体如下：
<?php
classdatabase
{
private$hostname;
private$user;
private$pass;
private$dbname;
private$linkflag;
private$charset;
function__construct()
{
$this->hostname="localhost";
$this->user="root";
$this->pass="111";
$this->dbname="";
$this->charset="utf8";//gb2312GBKutf8
$this->linkflag=mysql_connect($this->hostname,$this->user,$this->pass);
mysql_select_db($this->dbname,$this->linkflag)ordie($this->error());
mysql_query("setnames".$this->charset);
}
function__set($property_name,$value)
{
return$this->$property_name=$value;
}
function__get($property_name)
{
if(isset($this->$property_name))
{
return$this->$property_name;
}
elsereturnnull;
}
function__call($function_name,$args)
{
echo"<br><fontcolor=#ff0000>你所调用的方法$function_name不存在</font><br>\n";
}
functionquery($sql)
{
$res=mysql_query($sql)ordie($this->error());
return$res;
}
functionfetch_array($res)
{
returnmysql_fetch_array($res);
}
functionfetch_object($res)
{
returnmysql_fetch_object($res);
}
functionfetch_obj_arr($sql)
{
$obj_arr=array();
$res=$this->query($sql);
while($row=mysql_fetch_object($res))
{
$obj_arr[]=$row;
}
return$obj_arr;
}
functionerror()
{
if($this->linkflag)
{
returnmysql_error($this->linkflag);
}
elsereturnmysql_error();
}
functionerrno()
{
if($this->linkflag)
{
returnmysql_errno($this->linkflag);
}
elsereturnmysql_errno();
}
functionaffected_rows()
{
returnmysql_affected_rows($this->linkflag);
}
functionnum_rows($sql)
{
$res=$this->execute($sql);
returnmysql_num_rows($res);
}
functionnum_fields($res)
{
returnmysql_num_fields($res);
}
functioninsert_id()
{
$previous_id=mysql_insert_id($this->linkflag);
return$previous_id;
}
functionresult($res,$row,$field=null)
{
if($field===null)
{
$res=mysql_result($res,$row);
}
else$res=mysql_result($res,$row,$field);
return$res;
}
functionversion()
{
returnmysql_get_server_info($this->linkflag);
}
functiondata_seek($res,$rowNum)
{
returnmysql_data_seek($res,$rowNum);
}
function__destruct()
{
//mysql_close($this->linkflag);
}
}
?>
希望本文所述对大家的php程序设计有所帮助。