php实现比较全的数据库操作类

本文实例讲述了php实现比较全的数据库操作类。分享给大家供大家参考。具体如下：<?

本文实例讲述了php实现比较全的数据库操作类。分享给大家供大家参考。具体如下：

<?php
 class database
 {
 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"; //gb2312 GBK utf8
 $this->linkflag=mysql_connect($this->hostname,$this->user,$this->pass);
 mysql_select_db($this->dbname,$this->linkflag) or die($this->error());
 mysql_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 "<br><font color=#ff0000>你所调用的方法 $function_name 不存在</font><br>\n";
 }
 function query($sql)
 {
 $res=mysql_query($sql) or die($this->error());
 return $res;
 }
 function fetch_array($res)
 {
 return mysql_fetch_array($res);
 }
 function fetch_object($res)
 {
 return mysql_fetch_object($res);
 }
 function fetch_obj_arr($sql)
 {
 $obj_arr=array();
 $res=$this->query($sql);
 while($row=mysql_fetch_object($res))
 {
 $obj_arr[]=$row;
 }
 return $obj_arr;
 }
 function error()
 {
 if($this->linkflag)
 {
 return mysql_error($this->linkflag);
 }
 else return mysql_error();
 }
 function errno()
 {
 if($this->linkflag)
 {
 return mysql_errno($this->linkflag);
 }
 else return mysql_errno();
 }
 function affected_rows()
 {
 return mysql_affected_rows($this->linkflag);
 }
 function num_rows($sql)
 {
 $res=$this->execute($sql);
 return mysql_num_rows($res);
 }
 function num_fields($res)
 {
 return mysql_num_fields($res);
 }
 function insert_id()
 {
 $previous_id=mysql_insert_id($this->linkflag);
 return $previous_id;
 }
 function result($res,$row,$field=null)
 {
 if($field===null)
 {
 $res=mysql_result($res,$row);
 }
 else $res=mysql_result($res,$row,$field);
 return $res;
 }
 function version()
 {
 return mysql_get_server_info($this->linkflag);
 }
 function data_seek($res,$rowNum)
 {
 return mysql_data_seek($res,$rowNum);
 }
 function __destruct()
 {
 //mysql_close($this->linkflag);
 }
 }
?>

希望本文所述对大家的php程序设计有所帮助。