php常用功能封装-Mysql操作

class DBconn
{
    public $link;
    public function __construct($user = "", $pass = "", $dbName = "", $host = "localhost")
    {
        $this->link = mysqli_connect($host, $user, $pass, $dbName);
        mysqli_query($this->link, "SET NAMES utf-8");
    }

    public function find($sql) //单个查询

    {
        return $res = mysqli_fetch_array(mysqli_query($this->link, $sql));
    }
    public function findAll($sql) //多个查询

    {
        return $res = mysqli_fetch_all(mysqli_query($this->link, $sql));
    }
    public function query($sql) //执行普通SQL

    {

        return $res = mysqli_query($this->link, $sql);

    }

    public function showErr() //返回最近的错误信息

    {
        return array(
            "code" => mysqli_errno($this->link),
            "msg"  => mysqli_error($this->link),
        );
    }
}