PHP数据库管理封装

封装代码

header("Content-type: text/html; charset: utf-8");
class DBManager{
    public $mysqli=null;
    public $result=null;
    public $dsn = null;
    public $pdo = null;
    function __construct(){
        $dbms = 'mysql'; //选择mysql数据库
        $user = 'root';
        $pass = 'root';
        $host = 'localhost';
        $port = '3306';
        $dbname = 'one';
        $charset = 'utf8';
        $this->dsn = "$dbms:host=$host;port=$port;dbname=$dbname;charset=$charset";
        try {
            return $this->pdo  = new PDO($this->dsn,$user,$pass);
            $this->dsn = null;
        } catch (PDOException $e) {
            die ("error!: " . $e->getMessage() . "<br/>");
        }
    }
		function getResult($query){
                return $this->result=$this->pdo->query($query);
		}

		function insert($query){
            return   $this->pdo->exec($query);
		}

		function delete($query){
            return   $this->pdo->exec($query);

		}

		function update($query){
            return   $this->pdo->exec($query);
		}

    function autocommitS(){
        //开启一个事务
        $this->pdo->beginTransaction();
    }

    function commitS(){
        //执行
        $this->pdo->commit();
    }

    function rollbackS(){
        //回滚事务
        $this->pdo->rollback();
    }

    function error_unlock(){
        $this->pdo->setAttribute(PDO::ATTR_CASE,PDO::CASE_NATURAL); //强制转换列名为小写
        $this->pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);
    }

    function lastInsertIdlast($e){
        echo $e->getMessage()."<br/>"; //错误信息
        echo $e->getCode()."<br/>"; //错误代码
        echo $e->getFile()."<br/>"; //错误脚本
        echo $e->getLine()."<br/>"; //错误行号
        die("error");
    }
    function dbclose(){
        $pdo = null;
        //unset($pdo); 删除对象
    }

}