php数据库操作实例

php;">
<?php
/*Created By RexLee MySQL类
**PHP file SQL.php 2012-8-13 
*/
class MySQL {
	private $host;
	private $name;
	private $password;
	private $dbname;		//数据库名
	private $db;			//数据库连接句柄
	private $link;			//连接名
	public  $errmsg;		//错误信息
	public function __construct($server,$dbuser,$psw){
		$this->open($server,$dbuser,$psw);
	}
	private function open($server,$dbuser,$psw){//连接主机
		$this->host=$server;
		$this->name=$dbuser;
		$this->password=$psw;
		$this->link=mysql_connect($this->host,$this->name,$this->password) or die("主机连接失败！");;
	}
 	public function to2DArray($result){
 		$_2DArray=Array();
 		$arr=new ArrayObject($_2DArray);
 		while($row=mysql_fetch_array($result)){
 			$arr->append($row);
 		}
 		return $arr ;
 	}
 	public function opendb($database,$charset){//连接数据库
		$this->dbname=$database;
		mysql_query("set names ".$charset);//设置字符集
		$this->db=mysql_select_db($this->dbname,$this->link);
		if (!$this->db) {
			$this->errmsg="连接数据库错误！";
		}
	}
	public function query($sql) {
		$result=mysql_query($sql);
		if (!$result) {
			$this->errmsg="语句运行错误！";
		}
		return $result;
	}
	private function __call($n,$v){//错误方法吸收
		return "不存在".$n."()方法";
	}
}


//Example
// $c=new MySQL("localhost","root","lijun");
// $c->opendb("demo", "utf8");
// $r=$c->query("select * from test");
// echo $r,'<br>';
// $ar=$c->to2DArray($r);
// print_r($ar[0]);
// echo '<br>';
// print_r($ar[1]);
// echo '<br>';
// echo $c->hi();

?>