class mysql{
private $_host = 'localhost';//数据库地址
private $_user = 'root';//数据库帐号
private $_pass = 'root';//数据库密码
private $_dbName = 'test'; //数据库名
private $_charset = 'utf8'; //数据库字符集
private $link = null; //连接入口
private $result = null;
private $ary = array();
private function dbconn(){
$this->link = mysqli_connect($this->_host,$this->_user,$this->_pass,$this->_dbName);
if(!$this->link){ //入口连接失败时
echo '数据库连接失败!'.mysqli_connect_error();
}
mysqli_set_charset($this->link,$this->_charset);
}
private function getResult($sql){
if(!(is_string($sql))){ //判断传的语句是不是字符串
mysqli_close($this->link);
die('你传的Sql不符合要求!');
}
$this->result = mysqli_query($this->link,$sql);
if(!$this->result){ //语法错误时
die('你传的Sql语法有问题!');
}
return $this->result;
}
public function row($result){ //把数据处理成索引数组
while ($val = mysqli_fetch_row($result)){
$this->ary[]=$val;
}
mysqli_close($this->link);
return $this->ary;
}
public function assoc($result){ //把数据处理成关联数组
while ($val = mysqli_fetch_assoc($result)){
$this->ary[]=$val;
}
mysqli_close($this->link);
return $this->ary;
}
public function init($sql){
$this->dbconn();
return $this->getResult($sql);
}
}