mysql pdo in_封装:PDO与MySQL之间的无缝切换

* 封装PDODB类*/

//加载接口

include './I_DB.interface.php';class PDODB implementsI_DB {/**

* 定义相关属性*/

private $host; //主机地址

private $port; //端口号

private $user; //用户名

private $pass; //密码

private $dbname; //数据库名

private $charset;//字符集

private $dsn; //数据源名称

private $pdo; //用于存放PDO的一个对象

// 静态私有属性用于保存单例对象

private static $instance;/**

* [__construct 构造方法]

* @param [array] $config [配置数组]*/

private function __construct($config) {//初始化属性

$this->initParams($config);//初始化dsn

$this->initDSN();//实例化PDO对象

$this->initPDO();//初始化PDO对象的属性

$this->initAttribute();

}/**

* [getInstance 获取PDO单例对象的公开方法]

* @param [array] $config [description]

* @return [PDOobject] self::$instance [pdo对象]*/

public static function getInstance($config) {if (!self::$instanceinstanceof self) {

self::$instance = new self($config);

}return self::$instance;

}/**

* [initParams 初始化属性]

* @param [array] $config [配置数组]*/

private function initParams($config) {$this->host = isset($config['host'])?$config['host']:'localhost';$this->port = isset($config['port'])?$config['port']:'3306';$this->user = isset($config['user'])?$config['user']:'root';$this->pass = isset($config['pass'])?$config['pass']:'';$this->dbname = isset($config['dbname'])?$config['dbname']:'';$this->charset = isset($config['charset'])?$config['charset']:'utf8';

}/**

* [initDSN 初始化dsn]*/

private functioninitDSN() {$this->dsn = "mysql:host=$this->host;port=$this->port;dbname=$this->dbname;charset=$this->charset";

}/**

* [initPDO 实例化PDO对象]

* @return [boolean] [false|none]*/

private functioninitPDO() {//在实例化PDO对象的时候自动的走异常模式(也是唯一走异常模式的地方)

try{$this->pdo = new PDO($this->dsn,$this->user,$this->pass);

}catch(PDOException $e) {$this->my_error($e);

}

}/**

* [initAttribute 初始化PDO对象属性]

* @return [boolean] [false|none]*/

private functioninitAttribute() {//修改错误模式为异常模式

$this->pdo->setAttribute(PDO::ATTR_ERRMODE,PDO::ERRMODE_EXCEPTION);

}/**

* [my_error 输出异常信息]

* @param [PDOException] $e [异常对象]

* @return [boolean] [false|none]*/

private function my_error($e) {echo "执行sql语句失败!
";echo "错误的代码是:",$e->getCode(),"
";echo "错误的信息是:",$e->getMessage(),"
";echo "错误的脚本是:",$e->getFile(),"
";echo "错误的行号是:",$e->getLine(),'
';return false;

}/**

* [my_query 执行一条sql语句，实现增删改]

* @param [string] $sql [sql语句]

* @return [array] $result [资源结果集]*/

public function my_query($sql) {//其实就是调用pdo对象中的exec方法

try{$result = $this->pdo->exec($sql);

}catch(PDOException $e) {$this->my_error($e);

}return $result;

}/**

* [fetchAll 查询所有]

* @param [string] $sql [sql语句]

* @return [arry] $result [资源结果集]*/

public function fetchAll($sql) {//其实就是调用PDOStatment对象里面的fetchAll方法

try{$stmt = $this->pdo->query($sql);$result = $stmt->fetchAll(PDO::FETCH_ASSOC);//关闭游标，释放结果集

$stmt->closeCursor();

}catch(PDOException $e) {$this->my_error($e);

}return $result;

}/**

* [fetchRow 查询一条]

* @param [string] $sql [sql语句]

* @return [arry] $result [资源结果集]*/

public function fetchRow($sql) {//其实就是调用PDOStatment对象里面的fetch方法

try{$stmt = $this->pdo->query($sql);$result = $stmt->fetch(PDO::FETCH_ASSOC);//关闭游标，释放结果集

$stmt->closeCursor();

}catch(PDOException $e) {$this->my_error($e);

}return $result;

}/**

* [fetchColumn 查询单行单列]

* @param [string] $sql [sql语句]

* @return [arry] $result [资源结果集]*/

public function fetchColumn($sql) {//其实就是调用PDOStatment对象里面的fetchColumn方法

try{$stmt = $this->pdo->query($sql);$result = $stmt->fetchColumn();//关闭游标，释放结果集

$stmt->closeCursor();

}catch(PDOException $e) {$this->my_error($e);

}return $result;

}/**

* [__clone 私有化克隆方法，保护单例模式]*/

private function__clone() {}/**

* [__set 为一个不可访问的属性赋值的时候自动触发]

* @param [string] $name [属性名]

* @param [mixed] $value [属性值]*/

public function __set($name,$value) {$allow_set = array('host','port','user','pass','dbname','charset');if(in_array($name,$allow_set)) {//当前属性可以被赋值

$this->$name = $value;

}

}/**

* [__get *获得一个不可访问的属性的值的时候自动触发]

* @param [string] $name [属性名]

* @return [string] $name的value [该属性名的值]*/

public function __get($name) {$allow_get = array('host','port','user','pass','dbname','charset');if (in_array($name,$allow_get)) {return $this->$name;

}

}/**

* [__call 访问一个不可访问的对象方法的时候触发]

* @param [string] $name [属性名]

* @param [array] $argument [参数列表]*/

public function __call($name, $argument) {echo "对不起,您访问的".$name."()方法不存在!
";

}/**

* [__callstatic 访问一个不可访问的类方法(静态方法)的时候触发]

* @param [string] $name [属性名]

* @param [array] $argument [参数列表]*/

public static function __callStatic($name, $argument) {echo "对不起,您访问的".$name."()静态方法不存在!
";

}

}