/**
* 数据库连接封装
*/
class Db {
//存储类的实例的静态成员变量
private static $_instance;
//数据库链接静态变量
private static $_connectSource;
//连接数据库配置
private $_dbConfig = array(
'host' => '127.0.0.1',
'user' => 'root',
'password' => '',
'database' => 'mooc_cms'
);
private function __construct() {}
/**
* 实例化
*/
public static 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_select_db($this->_dbConfig['database'], self::$_connectSource);
//设置字符编码
mysql_query("set names UTF8", self::$_connectSource);
}
//返回资源链接
return self::$_connectSource;
}
}
?>