PHP数据库单例连接封装

最新推荐文章于 2024-10-01 18:22:37 发布

97小码农

最新推荐文章于 2024-10-01 18:22:37 发布

阅读量152

点赞数

分类专栏： PHP工具文章标签： php

本文链接：https://blog.csdn.net/weixin_39413049/article/details/106287520

版权

PHP工具专栏收录该内容

7 篇文章 0 订阅

订阅专栏

PHP数据库单例连接封装

<?php
/**
 * Created by PhpStorm.
 * User: ZTK
 * Date: 2020/5/22
 * Time: 15:29
 */
//单例模式数据库
class Db{

    private static $_instance;//
    private static $_dbConnect;
    private $_dbConfig = array(
        'host' => '127.0.0.1',
        'user' => 'root',
        'password' => '123456',
        'database' => 'test',
        'port' => 3306,
        'charset' => 'utf8mb4'
    );

    private function __construct()
    {
    }

    public function __clone()
    {
        //当用户clone操作时产生一个错误信息
        echo "禁止克隆".PHP_EOL;
        // 函数创建用户级别的错误消息。
        trigger_error("Can't clone object",E_USER_ERROR);
    }

    //获取单列
    public static function getInstance(){
        if(!(self::$_instance instanceof self)){  //如果当前实例不存在，创建
            echo "获取new新实例".PHP_EOL;
            self::$_instance = new self();
        }
//        var_dump(self::$_instance);
        self::$_instance->connect();
        return self::$_instance;
    }

    //连接数据库
    public function connect(){
        $host = $this->_dbConfig['host'];
        $user = $this->_dbConfig['user'];
        $pwd = $this->_dbConfig['password'];
        $dbname = $this->_dbConfig['database'];
        $port = $this->_dbConfig['port'];
        $charset = $this->_dbConfig['charset'];
        $dsn = "mysql:host=$host;dbname=$dbname;port=$port";
        $pdo = new PDO ( $dsn, $user, $pwd );
        $pdo->query("set names {$charset};");
        $pdo->setAttribute(PDO::ATTR_EMULATE_PREPARES, false);
        $pdo->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        self::$_dbConnect = $pdo;
        if(!self::$_dbConnect){
            throw new Exception('mysql connnect');
        }
        return self::$_dbConnect;
    }

    public function query($sql=null, $params=array() ){
        $stmt = Db::$_dbConnect->prepare($sql);
        if( is_array($params) && !empty($params) ){
            foreach($params as $k=>&$v){
                $stmt->bindParam($k, $v);
            }
        }
        if( $stmt->execute() )
            //查询多条数据
            return $stmt->fetchAll(PDO::FETCH_ASSOC);
        $err = $stmt->errorInfo();
        throw new Exception('Database SQL: "' . $sql. '". ErrorInfo: '. $err[2], 1);
    }

}
$a = Db::getInstance();//获取
$b = Db::getInstance();
try{
    $data = $a->query("select * from users");
    var_dump($data);
}catch (Exception $e){
    echo "sorry,error was happend.".$e->getMessage();
}

结果如下：

array(2) {
  [0]=>
  array(3) {
    ["id"]=>
    int(1)
    ["username"]=>
    string(2) "nn"
    ["pass"]=>
    NULL
  }
  [1]=>
  array(3) {
    ["id"]=>
    int(2)
    ["username"]=>
    string(2) "mm"
    ["pass"]=>
    NULL
  }
}