PHP mysql封装

       PHP  ------mysql封装

<?php
class Mysql{
	private $host;
	private $user;
	private $pwd;
	private $dbName;
	private $charset;
    private $conn;


	public function __construct(){
        // 应该在构造方法里读取配置文件。
        // 然后根据配置文件来设置私有属性，
        // 此处还没有配置文件，就直接赋值，
		$this->host="localhost";
        $this->user="root";
        $this->pwd="toor";
        $this->dbName="test";
        $this->charset="utf8";
        //连接
        $this->connect($this->host,$this->user,$this->pwd);
        
        //切换库
        $this->switchDb($this->dbName);

        //设置字符集
        $this->setChar($this->charset);

    }
    //负责连接
	private function connect($n,$v,$p){
        $conn=mysqli_connect($n,$v,$p);
        $this->conn=$conn;

	}
    //负责切换数据库，网站大的时候可能，可能用到不止一个库
    public function switchDb($dbName){
        $sql='use   '.$dbName;
        $this->query($sql);
    }

    public function setChar($char){
        $sql="set names  ".$char;
        $this->query($sql);
    }
    //负责发送sql查询
	public function query($sql){
        return  mysqli_query($this->conn,$sql);
        
	}
    //负责获取多行多列的select结果
	public function getAll($sql){
        $list=array();
        $rs=$this->query($sql);
        if(!$rs){
            return false;
        }
        while($row=mysqli_fetch_assoc($rs)){
            $list[]=$row;
        }
        return $list;

	}
    public function getRow($sql){
        $rs=$this->query($sql);
        if(!$rs){
            return false;
        }
        return  mysqli_fetch_assoc($rs);
    }
    public function getOne($sql){
        $rs=$this->query($sql);
        if(!$rs){
            return false;
        }
        $row=mysqli_fetch_row($rs);
        return $row[0];
    }
    public function close(){
        mysqli_close($this->conn);
    }
    
}
echo '<pre>';
$mysql=new Mysql();
print_r($mysql);

// $sql="insert into stu(name,email,content) values ('langren','lr@123','123456')";

// if($mysql->query($sql)){
//     echo "success";
// }else{
//     echo "failure";
// }
echo "<br>";
$sql="select *  from stu";
$arr=$mysql->getAll($sql);
print_r($arr);

$sql="select * from stu where id=3";
print_r($mysql->getRow($sql));

$sql="select count(*) from stu ";
print_r($mysql->getOne($sql));


?>