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;//错误信息
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,'
';
// $ar=$c->to2DArray($r);
// print_r($ar[0]);
// echo '
';
// print_r($ar[1]);
// echo '
';
// echo $c->hi();
?>