<?php
/* class sys_conf{
public static $DBHOST="localhost";
public static $DBUSER="root";
public static $DBPWD="";
public static $DBNAME="dbname";
} sy5_conf.inc 文件 */
require("sys_conf.inc");
class database {
private $host;
private $user;
private $pwd;
private $name;
private $conn;
function __get($property_name) { //__get()获取属性值;
if(isset($this->$property_name)){
return($this->$proerty_name);
}else{
return(NULL);
}
function __set($property_name,$value) { //__set()设置属性值;
$this->$property_name=$value;
}
}
function __construct() { //通过构造函数 __construct() 建立数据库连接;
$this->host=sys_conf::$DBHOST; //使用sys_conf类的静态属性;
$this->user=sys_conf::$DBUSER;
$this->pwd=sys_conf::$PWD;
$this->name=sys_conf::$DBNAME;
$this->conn=mysql_connect($this->host,$this->user,$this->pwd); //建立连接;
mysql_select_db($this->name,$this->conn);
}
function __destruct() { //通过柝构函数 __destruct() 断开数据库连接;
mysql_close($this->conn);
}
function execute($sql) { //execute():使用mysql_query()函数执行非查询语句;
mysql_query($slq);
//增删改查:参数$sql为Insert语句;
}
function query($sql) { //query:使用mysql_fetch_object()获取SQL查询,并将返回的对象集合放入数组;
$result_array=array(); //返回数组;
$i=0;
$query_result=mysql_query($sql,$this->conn);
while($row=mysql_fetch_object($query_result)){
$query_result[$i++]=$row;
}
return $query_result;
}
}
?>