php db库封装,封装一个数据库的操作类 db.php

/**

* 数据库连接封装

*/

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;

}

}

?>