封装mysql类

class Mysql{
    private $host;
    private $user;
    private $pwd;
    private $charset;
    private $dbname;
    private $conn;

    public function __construct()
    {
        $this->host = 'localhost';
        $this->user = 'root';
        $this->pwd = '';
        $this->dbname = 'test';
        $this->charset = 'set names utf8';
    }

    // 链接数据库
    public function connect(){
        $conn = mysqli_connect($this->host,$this->user,$this->pwd);
        if (!$conn){
            die('could not connect:'.mysqli_error($conn));
        }
        echo '数据库链接成功','<br>';
        $this->conn = $conn;
    }
    // 设置编码 选择数据库
    public function set(){
        mysqli_query($this->conn,$this->charset);
        mysqli_select_db($this->conn,$this->dbname);
    }
    // 查询数据
    public function query($sql){      // 打通资源
        $rs = mysqli_query($this->conn,$sql);
        if(!$rs )
        {
            die('无法读取数据: ' . mysqli_error($this->conn));
        }
        while ($row = mysqli_fetch_assoc($rs)){     // 读取
            print_r($row);
            echo '<br>';
        }

    }
}

$zz = new Mysql();
$zz->connect();
$zz->set();
$zz->query('select * from msg');