PHP使用类对mysql的使用进行封装

<?php
header("content-type:text/html;
charset=utf8");
//Mysql数据库连接
class Mysql {
public $db_host;
public $db_user;
public $db_pass;
public $db_charset;
public $db_name;
public function __construct($db_host,$db_user,$db_pass,$db_charset,$db_name) {
$this->db_host=$db_host;
$this->db_user=$db_user;
$this->db_pass=$db_pass;
$this->db_charset=$db_charset;
$this->db_name=$db_name;
$this->connect();
}
public function connect() {
@mysql_connect($this->db_host,$this->db_user,$this->db_pass);
mysql_set_charset($this->db_charset);
mysql_select_db($this->db_name);
}
public function getAll($sql) {
$res =mysql_query($sql);
$rows=[];
while($row=mysql_fetch_assoc($res)) {
$rows[]=$row;
}
return $rows;
}
public function __destruct() {
mysql_close();
}
}
$mysql=new Mysql('127.0.0.1','root','root','utf8','cms');
$arr=$mysql->getAll("select *from cms_user");
var_dump($arr);
?>