mysql php 类_PHP操作mysql类

class Mysql{

//数据库连接句柄

private $link;

//返回结果集

private $result;

//返回查询数据

private $data;

//执行的SQL语句

private $query;

public function __construct(){

$this->link = @new mysqli("127.0.0.1","root","chenshuo90909","frame");

if($this->link->connect_errno > 0){

echo "数据库连接失败！"; exit;

}

$this->link->set_charset("utf8");

}

//查询

public function select($query){

$this->result = $this->link->query($query);

while($row = $this->result->fetch_assoc()){

$this->data[] = $row;

}

$this->result->free();

return $this->data;

}

//写入

public function insert($query){

$this->result = $this->link->query($query);

return $this->result;

}

//获取最后一次添加记录的主键值

public function insertid(){

return $this->link->insert_id;

}

//修改

public function update($query){

$this->result = $this->link->query($query);

return $this->result;

}

//删除

public function delete($query){

$this->result = $this->link->query($query);

return $this->result;

}

//返回服务器端MySQl版本

public function version(){

return $this->link->server_info;

}

//返回数据库所属服务器信息

public function hostinfo(){

return $this->link->host_info;

}

//关闭mysql连接

public function __destruct(){

$this->link->close();

}

}

?>