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();
}
}
?>