本文实例讲述了PHP实现比较全的数据库操作类。分享给大家供大家参考。具体如下:
PHP;">
hostname="localhost";
$this->user="root";
$this->pass="111";
$this->dbname="";
$this->charset="utf8"; //gb2312 GBK utf8
$this->linkflag=@R_502_198@_connect($this->hostname,$this->user,$this->pass);
@R_502_198@_select_db($this->dbname,$this->linkflag) or die($this->error());
@R_502_198@_query("set names ".$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;
}
else return null;
}
function __call($function_name,$args)
{
echo "
你所调用的方法 $function_name 不存在
\n"; } function query($sql) { $res=@R_502_198@_query($sql) or die($this->error()); return $res; } function fetch_array($res) { return @R_502_198@_fetch_array($res); } function fetch_object($res) { return @R_502_198@_fetch_object($res); } function fetch_obj_arr($sql) { $obj_arr=array(); $res=$this->query($sql); while($row=@R_502_198@_fetch_object($res)) { $obj_arr[]=$row; } return $obj_arr; } function error() { if($this->linkflag) { return @R_502_198@_error($this->linkflag); } else return @R_502_198@_error(); } function errno() { if($this->linkflag) { return @R_502_198@_errno($this->linkflag); } else return @R_502_198@_errno(); } function affected_rows() { return @R_502_198@_affected_rows($this->linkflag); } function num_rows($sql) { $res=$this->execute($sql); return @R_502_198@_num_rows($res); } function num_fields($res) { return @R_502_198@_num_fields($res); } function insert_id() { $prevIoUs_id=@R_502_198@_insert_id($this->linkflag); return $prevIoUs_id; } function result($res,$row,$field=null) { if($field===null) { $res=@R_502_198@_result($res,$row); } else $res=@R_502_198@_result($res,$field); return $res; } function version() { return @R_502_198@_get_server_info($this->linkflag); } function data_seek($res,$rowNum) { return @R_502_198@_data_seek($res,$rowNum); } function __destruct() { //@R_502_198@_close($this->linkflag); } } ?>
你所调用的方法 $function_name 不存在
\n"; } function query($sql) { $res=@R_502_198@_query($sql) or die($this->error()); return $res; } function fetch_array($res) { return @R_502_198@_fetch_array($res); } function fetch_object($res) { return @R_502_198@_fetch_object($res); } function fetch_obj_arr($sql) { $obj_arr=array(); $res=$this->query($sql); while($row=@R_502_198@_fetch_object($res)) { $obj_arr[]=$row; } return $obj_arr; } function error() { if($this->linkflag) { return @R_502_198@_error($this->linkflag); } else return @R_502_198@_error(); } function errno() { if($this->linkflag) { return @R_502_198@_errno($this->linkflag); } else return @R_502_198@_errno(); } function affected_rows() { return @R_502_198@_affected_rows($this->linkflag); } function num_rows($sql) { $res=$this->execute($sql); return @R_502_198@_num_rows($res); } function num_fields($res) { return @R_502_198@_num_fields($res); } function insert_id() { $prevIoUs_id=@R_502_198@_insert_id($this->linkflag); return $prevIoUs_id; } function result($res,$row,$field=null) { if($field===null) { $res=@R_502_198@_result($res,$row); } else $res=@R_502_198@_result($res,$field); return $res; } function version() { return @R_502_198@_get_server_info($this->linkflag); } function data_seek($res,$rowNum) { return @R_502_198@_data_seek($res,$rowNum); } function __destruct() { //@R_502_198@_close($this->linkflag); } } ?>
希望本文所述对大家的PHP程序设计有所帮助。