作者:飘泊的牛小盆友 | 来源:互联网 | 2018-03-19 02:45
<?php*CreatedByRexLeeMySQL类**PHPfileSQL.php2012-8-13*classMySQL{private$host;private$name;private$password;private$dbname;数据库名priva
&#65279;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();
?>