php封装mysql管理,PHP连接MYSQL简易封装

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);

}

}