单例mysql链接方式_单例模式连接数据库的方法

这篇文章主要介绍了关于单例模式连接数据库的方法，有着一定的参考价值，现在分享给大家，有需要的朋友可以参考一下

<?php

class Db {

static private $_instance;

static private $_connectSource;

private $_dbConfig = array(

'host' => '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);*/

以上就是本文的全部内容，希望对大家的学习有所帮助，更多相关内容请关注PHP中文网！

相关推荐：