How to connect to the database in singleton mode

This article mainly introduces the method of connecting to the database in singleton mode. It has certain reference value. Now I share it with you. Friends in need can refer to it

 '127.0.0.1',
        'user' => 'root',
        'password' => '',
        'database' => 'video',
    );

    private function __construct() {
    }

    static public function getInstance() {
        if(!(self::$_instance instanceof self)) {
            self::$_instance = new self();
        }
        return self::$_instance;
    }

    public function connect() {
        if(!self::$_connectSource) {
            self::$_connectSource = @mysql_connect($this->_dbConfig['host'], $this->_dbConfig['user'], $this->_dbConfig['password']);    

            if(!self::$_connectSource) {
                throw new Exception('mysql connect error ' . mysql_error());
                //die('mysql connect error' . mysql_error());
            }
            
            mysql_select_db($this->_dbConfig['database'], self::$_connectSource);
            mysql_query("set names UTF8", self::$_connectSource);
        }
        return self::$_connectSource;
    }
}
/*$connect = Db::getInstance()->connect();

$sql = "select * from video";
$result = mysql_query($sql, $connect);
echo mysql_num_rows($result);
var_dump($result);*/

The above is the entire content of this article. I hope it will be helpful to everyone's study. For more related content, please pay attention to the PHP Chinese website!

Related recommendations:

How to use fastcgi_finish_request to improve page response speed

The above is the detailed content of How to connect to the database in singleton mode. For more information, please follow other related articles on the PHP Chinese website!