zend framework DB封装类

最新推荐文章于 2021-02-07 07:14:23 发布
原创 最新推荐文章于 2021-02-07 07:14:23 发布 · 803 阅读 · 0 ·
CC 4.0 BY-SA版权
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。

本文介绍了如何在zend framework中创建一个数据库操作的封装类，包括连接配置、查询执行、事务处理等关键功能，旨在提高代码复用性和数据库操作的安全性。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >




zend framework DB封装类



<?php
abstract class Base_DataBase_Pdo_Abstract{
	const CASE_FOLDING = 'caseFolding';
	const AUTO_QUOTE_IDENTIFIERS = 'autoQuoteIdentifiers';
	protected $_config = array();
	protected $_connection = null;
	protected $_caseFolding = PDO::CASE_NATURAL;
	protected $_autoQuoteIdentifiers = true;
	protected $_fetchMode = PDO::FETCH_ASSOC;
	protected $_transactionLevel = 0;
	protected $_curdb = null;
	
	protected function __construct($connection = 'default'){
	    global $CONFIG;
	    $this->_curdb = $connection;
		$options = array(
            self::CASE_FOLDING           => $this->_caseFolding,
            self::AUTO_QUOTE_IDENTIFIERS => $this->_autoQuoteIdentifiers
        );
        
	    $driverOptions = array();
		if (array_key_exists('options', $CONFIG->database['database'])) {
            foreach ((array) $CONFIG->database['database']['options'] as $key => $value) {
                $options[$key] = $value;
            }
        }
	    if (array_key_exists('driver_options', $CONFIG->database['database'])) {
            if (!empty($CONFIG->database['database']['driver_options'])) {
                foreach ((array) $CONFIG->database['database']['driver_options'] as $key => $value) {
                    $driverOptions[$key] = $value;
                }
            }
        }
        
        $this->_config['options'] = $options;
        $this->_config['driver_options'] = $driverOptions;
		
	    if (array_key_exists(self::CASE_FOLDING, $options)) {
        	$case = (int) $options[self::CASE_FOLDING];
        	switch ($case) {
                case PDO::CASE_LOWER:
                case PDO::CASE_UPPER:
                case PDO::CASE_NATURAL:
                    $this->_caseFolding = $case;
                    break;
                default:
                    throw new DBException('Case must be one of the following constants: '
                        . 'PDO::CASE_NATURAL, PDO::CASE_LOWER, PDO::CASE_UPPER');
            }
        }
		if (array_key_exists(self::AUTO_QUOTE_IDENTIFIERS, $options)) {
            $this->_autoQuoteIdentifiers = (bool) $options[self::AUTO_QUOTE_IDENTIFIERS];
        }
	}
	
	protected function setdatabase($config){
		if(!is_array($config)){
			throw new DBException('DB exception');
		}
		
		$this->_checkRequiredOptions($config);
		
		if (!isset($config['charset'])) {
            $config['charset'] = null;
        }
        $this->_config = array_merge($this->_config, $config);
        
        //设置字符集
        $initCommand = "SET NAMES '" . $this->_config['charset'] . "'";
        $this->_config['driver_options'][1002] = $initCommand; // 1002 = PDO::MYSQL_ATTR_INIT_COMMAND       
	}
	
	protected function _checkRequiredOptions($config){
		if (! array_key_exists('dbname', $config)) {
            throw new DBException("Configuration array must have a key for 'dbname' that names the database instance");
        }
		if (! array_key_exists('password', $config)) {
            throw new DBException("Configuration array must have a key for 'password' that names the database instance");
        }
		if (! array_key_exists('password', $config)) {
            throw new DBException("Configuration array must have a key for 'password' that names the database instance");
        }
	}
	protected function _dsn()
    {
        $dsn = $this->_config;
        unset($dsn['username']);
        unset($dsn['password']);
        unset($dsn['options']);
        unset($dsn['charset']);
        unset($dsn['persistent']);
        unset($dsn['driver_options']);
        foreach ($dsn as $key => $val) {
            $dsn[$key] = "$key=$val";
        }
        $c=$this->_pdoType . ':' . implode(';', $dsn);
        return $this->_pdoType . ':' . implode(';', $dsn);
    }
    protected function _connect(){
   	    global $CONFIG;	
    	if(isset($this->_connection)){
    		return;
    	}
    	$this->setdatabase($CONFIG->database[$this->_curdb]); 
    	$dsn = $this->_dsn();
    	if(!extension_loaded('pdo')){
    		new DBException('The PDO extension is required for this adapter but the extension is not loaded');
    	}
    	
    	//$drivers = PDO::getAvailableDrivers(); $dricers 共5个 sqlite,mysql,pgsql,sqlite2,oci
    	if (!in_array($this->_pdoType, PDO::getAvailableDrivers())) {
    		throw new DBException('The ' . $this->_pdoType . ' driver is not currently installed');
    	}
    	if (isset($this->_config['persistent']) && ($this->_config['persistent'] == true)) {
            $this->_config['driver_options'][PDO::ATTR_PERSISTENT] = true;
        }
    	if (isset($this->_config['timeout']) ) {
            $this->_config['driver_options'][PDO::ATTR_TIMEOUT] = $this->_config['timeout'];
        }
    	try {
            $this->_connection = new PDO(
                $dsn,
                $this->_config['username'],
                $this->_config['password'],
                $this->_config['driver_options']
            );
            $this->_connection->setAttribute(PDO::ATTR_CASE, $this->_caseFolding);
            $this->_connection->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
        } catch (PDOException $e) {
            throw new DBException($e->getMessage());
        }
    }
    protected function _beginTransaction()
    {
        $this->_connect();
        $this->_connection->beginTransaction();
    }
    protected function _commit()
    {
        $this->_connect();
        $this->_connection->commit();
    }
    protected function _rollBack() {
        $this->_connect();
        $this->_connection->rollBack();
    }
	public function getConnection()
    {
        $this->_connect();
        return $this->_connection;
    }
	public function getConfig()
    {
        return $this->_config;
    }
	public function beginTransaction()
    {
        if ($this->_transactionLevel===0) {
          $this->_connect();
          $this->_beginTransaction();
        }
        $this->_transactionLevel++;
        return $this;
    }
	public function commit()
    {
    	if ($this->_transactionLevel===1) {
           $this->_connect();
           $this->_commit();
    	}
    	$this->_transactionLevel--;
        return $this;
    }
	public function rollBack()
    {
    	if ($this->_transactionLevel===1) {
          $this->_connect();
          $this->_rollBack();
    	}
        $this->_transactionLevel--;
        return $this;
    }
	public function prepare($sql)
    {
        $this->_connect();
        $stmt = $this->_connection->prepare($sql);
        $stmt->setFetchMode($this->_fetchMode);
        return $stmt;
    }
    public function query($sql, $bind = array()){
    	if (!is_array($bind)) {
            $bind = array($bind);
        }
        $this->_connect();
        $stmt = $this->prepare($sql);
        $stmt->execute($bind);
        $stmt->setFetchMode($this->_fetchMode);
        return $stmt;
	}
	//如果插入的记录中有一个或多个是时间的字段，可以将列名的小写放进数组做为第三个参数
	//如果有一个时间字段，且名字是daytime可以省去第三个参数。
	public function insert($table, array $bind,$datecol = array('daytime'))
    {
        $cols = array();
        $vals = array();
        foreach ($bind as $col => $val) {
            $cols[] = $this->_quoteIdentifier($col, true);
       /*     if(in_array($tempcol, array('create_time','update_time','check_time'))){
            	 $vals[] = time();
            	 unset($bind[$col]);
            }elseif(in_array($tempcol, array('start_time','end_time'))){
            	 $vals[] = trim($val);
            }else{
            	 $vals[] = '?';
            }*/
             $vals[] = '?';
             //$bind[$col] = addcslashes($val, "\n\r\\'\"\032");
        }
        $sql = "INSERT INTO "
             . $this->_quoteIdentifier($table, true)
             . ' (' . implode(', ', $cols) . ') '
             . 'VALUES (' . implode(', ', $vals) . ')';
        $stmt = $this->query($sql, array_values($bind));
        $result = $stmt->rowCount();
        return $result;
    }
	public function update($table, array $bind, $where = '')
    {
        $set = array();
        $i = 0;
        foreach ($bind as $col => $val) {
            $set[] = $this->_quoteIdentifier($col, true) . ' = ?' ;
        }
        $sql = "UPDATE "
             . $this->_quoteIdentifier($table, true)
             . ' SET ' . implode(', ', $set)
             . (($where) ? " WHERE $where" : '');
        $stmt = $this->query($sql, array_values($bind));
        $result = $stmt->rowCount();
        return $result;
    }
	public function delete($table, $where = '')
    {
       // $where = $this->_whereExpr($where); 
        $sql = "DELETE FROM "
             . $this->_quoteIdentifier($table, true)
             . (($where) ? " WHERE $where" : '');
        $stmt = $this->query($sql);
        $result = $stmt->rowCount();
        return $result;
    }
	public function fetchAll($sql, $bind = array(), $fetchMode = null)
    {
        if ($fetchMode === null) {
            $fetchMode = $this->_fetchMode;
        }
        $stmt = $this->query($sql, $bind);
        
        $result = $stmt->fetchAll($fetchMode);
        return $result;
    }
	public function fetchAssoc($sql, $bind = array())
    {
        $stmt = $this->query($sql, $bind);
        $data = array();
        while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
            $tmp = array_values(array_slice($row, 0, 1));
            $data[$tmp[0]] = $row;
        }
        return $data;
    }
	public function fetchOne($sql, $bind = array())
    {
        $stmt = $this->query($sql, $bind);
        $result = $stmt->fetchColumn(0);
        return $result;
    }
    public function fetchPairs($sql, $bind = array())
    {
        $stmt = $this->query($sql, $bind);
        $data = array();
        while ($row = $stmt->fetch(Zend_Db::FETCH_NUM)) {
            $data[$row[0]] = $row[1];
        }
        return $data;
    }
    public function fetchCol($sql, $bind = array())
    {
        $stmt = $this->query($sql, $bind);
        $result = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
        return $result;
    }
    public function fetchRow($sql, $bind = array(), $fetchMode = null)
    {
        if ($fetchMode === null) {
            $fetchMode = $this->_fetchMode;
        }
        $stmt = $this->query($sql, $bind);
        $result = $stmt->fetch($fetchMode);
        return $result;
    }
	public function exec($sql)
    {
        try {
            $affected = $this->getConnection()->exec($sql);            
            if ($affected === false) {
                $errorInfo = $this->getConnection()->errorInfo();
                throw new DBException($errorInfo[2]);
            }
            return $affected;
        } catch (PDOException $e) {
            throw new DBException($e->getMessage());
        }
    }
	protected function _quoteIdentifier($value, $auto=false)
    {
        if ($auto === false || $this->_autoQuoteIdentifiers === true) {
            $q = $this->getQuoteIdentifierSymbol();
            return ($q . str_replace("$q", "$q$q", $value) . $q);
        }
        return $value;
    }
	public function getQuoteIdentifierSymbol()
    {
        return '"';
    }
	public function foldCase($key)
    {
        switch ($this->_caseFolding) {
            case PDO::CASE_LOWER:
                $value = strtolower((string) $key);
                break;
            case PDO::CASE_UPPER:
                $value = strtoupper((string) $key);
                break;
            case PDO::CASE_NATURAL:
            default:
                $value = (string) $key;
        }
        return $value;
    }
	public function setFetchMode($mode)
    {
        if (!extension_loaded('pdo')) {
            throw new DBException('The PDO extension is required for this adapter but the extension is not loaded');
        }
        switch ($mode) {
            case PDO::FETCH_LAZY:
            case PDO::FETCH_ASSOC:
            case PDO::FETCH_NUM:
            case PDO::FETCH_BOTH:
            case PDO::FETCH_NAMED:
            case PDO::FETCH_OBJ:
                $this->_fetchMode = $mode;
                break;
            default:
                throw new DBException("Invalid fetch mode '$mode' specified");
                break;
        }
    }
	public function isConnected()
    {
        return ((bool) ($this->_connection instanceof PDO));
    }
	public function lastInsertId($tableName = null, $primaryKey = null)
    {
        $this->_connect();
        return $this->_connection->lastInsertId();
    }
    public function closeConnection()
    {
        $this->_connection = null;
        $this->_dbobject['slave'] = null;
        $this->_dbobject['master'] = null;
    }
	protected function _quote($value)
    {
        if (is_int($value) || is_float($value)) {
            return $value;
        }
        $this->_connect();
        return $this->_connection->quote($value);
    }
	public function getServerVersion()
    {
        $this->_connect();
        try {
            $version = $this->_connection->getAttribute(PDO::ATTR_SERVER_VERSION);
        } catch (PDOException $e) {
            return null;
        }
        $matches = null;
        if (preg_match('/((?:[0-9]{1,2}\.){1,3}[0-9]{1,2})/', $version, $matches)) {
            return $matches[1];
        } else {
            return null;
        }
    }
    
    public function getEdt(){
        return $this->ismaster.'-'.$this->_curtarget;
    }
    
    abstract public function listTables();
    abstract public function describeTable($tableName, $schemaName = null);
    abstract public function limit($sql, $count, $offset = 0);
}


Zend Framework2 DB操作
xihuangwutong的专栏
01-07 1163
adapter  是数据库配置的抽象，主要是把数据库的各种配置信息抽象出来 $adapter = new Zend\Db\Adapter\Adapter($configArray); 可以配置驱动，用户名，密码，端口，字符集 $adapter = new Zend\Db\Adapter\Adapter(array( 'driver' => 'Mysqli', '
zend framework2.0 连接 oracle 方法 PDO连接
newsera
01-22 932
[pdo设置]  ;修改php.ini extension=php_oci8.dll                ; 使用 Oracle 10gR2 客户端请开启 ;extension=php_oci8_11g.dll      ; 使用 Oracle 11gR2 客户端请开启 extension=php_pdo_oci.dll         ; 开启 php_pdo_oci.dll
zend framework入门3
企鹅菜鸟的成长过程
05-29 1805
Zend_Db::factory()来做的数据库连接等，返回一个数据库适配器，就 可以进行各种操作了 为什么会找到总控？ 如果是404，必走过总控和bootstrap .htaccess重写机制？ 有一句话： RewriteRule ^.*$ index.php [NC,L]    改写成 http://www.zf1.com/index.php
ZendFrameset 数据库CURD操作
乱晃的脑袋
04-15 418
CurdController.php<?php/** * Created by PhpStorm. * User: Administrator * Date: 2016/4/6 * Time: 15:57 * 某表格CURD操作 */ require_once 'DBController.php'; require_once APPLICATION_PATH . '/models/stu
ZendFramework2学习笔记 “单表多对象”的CRUD操作、“多表单对象”的CRUD操作
相忘于江湖的专栏
10-27 1473
“单表多对象”的CRUD操作、“多表单对象”的CRUD操作
Zend Framework框架教程之Zend_Db_Table_Rowset用法实例分析
12-19
在本教程中，我们将深入探讨Zend Framework框架中的`Zend_Db_Table_Rowset`组件，这是一个用于管理数据库查询结果的集合类。`Zend_Db_Table_Rowset`是`Zend_Db_Table_Row`对象的集合，它实现了迭代器接口，使得我们...
Zend Framework教程之Zend_Db_Table_Row用法实例分析
12-19
总结起来，`Zend_Db_Table_Row`是Zend Framework中用于数据库操作的强大工具，通过面向对象的方式封装了数据行，简化了数据库交互。了解并熟练使用这些方法，可以提高代码的可读性和维护性，同时有效地管理数据库...
Zend Framework连接Mysql数据库实例分析
10-22
完成配置后，我们可以通过`Zend_Db`类来建立数据库连接。在`index.php`文件中，我们创建一个数组`$params`来存储数据库连接参数，包括主机名、用户名、密码和数据库名称。然后，我们使用`Zend_Db::factory()`方法来...
Zend framework处理一个http请求的流程分析
12-18
Zend Framework支持自动加载类，通过配置可以方便地管理类库和模块，使得开发过程中无需手动包含文件。此外，框架还提供了对文件上传、数据库操作、分页等功能的支持，以及文件重命名等实用方法。 总结来说，Zend ...
深入理解Zend Framework：Zend_Db_Table使用教程
"这篇教程详细介绍了在Zend Framework中如何使用Zend_Db_Table进行数据库操作，包括其功能、使用方法以及相关的注意事项。" 在 Zend Framework 中，`Zend_Db_Table` 是一个非常重要的组件，它允许开发者方便地与...
Zend Framework2 入门教程
weixin_34037173的博客
02-19 537
2019独角兽企业重金招聘Python工程师标准>>> ...
mysql db类_避免使用Zend_Db类进行MySQL注入
weixin_33712536的博客
02-07 137
小编典典当我是该项目的团队负责人(直到1.0版)时，我在Zend Framework中编写了很多用于数据库参数和引用的代码。我尽力鼓励最佳做法，但必须在易用性之间取得平衡。请注意，您始终可以检查Zend_Db_Select对象的字符串值，以了解其决定引用的方式。print $select; // invokes __toString() method您也可以使用Zend_Db_Profiler来检...
简单的PDO数据库操作类
zendFrameWork的小打小闹
07-19 1129
<?php /** * * @todo easy pdo db class * @author ggbound * * */ class BaseModel{ private $_connect = null; //全局链接 private $_PDOStatement = null; //全局pdoStatement private
Zend Framework教程-Zend_Db-数据库操作3-Zend_Db_Table 、Zend_Db_Table_Row 、Zend_Db_Table_Rowset
梦想摆渡的专栏
08-11 4218
Zend_Db_Table  Zend_Db_Table集成了Zend_Db_Table_Abstract抽象基类。实现了对数据表操作的相关方法。要使用Zend_Db_Table。需要将Zend_Db_Table设置为默认的适配器。 使用举例如下： 项目一/db_demos1为例。用zend studio创建默认的应用项目即可 数据库为test。表为user表。大概如下： C
ZendFramework3数据库操作zend-db
newlooc的博客
10-07 2843
一. zend-db(2.8^)介绍 zend-db是ZendFramework3的数据库操作模块,支持常见的数据库.官方文档对其的介绍很粗略,没有详细介绍其子句,链式操作.文本将做部分补全.并简单介绍一个开源程序,对zend-db的操作进行简化. 1. Zend\Db\Sql\Sql(以下简称Sql) Sql是zend-db的核心,封装了INSERT,DELETE,UPDATE,SELECT这四
微信公众平台开发之MySql数据库+关键词回复-php语言（三）
afanxingzhou的专栏
02-23 9398
2019-3-28 15:09:02更新: 感谢各位的支持。最早发帖是在大四毕业论文期间，所以针对第一次接触微信公众号的学生。时过境迁，4年过去了，在微信上遇到了方方面面的问题，这里贡献些自己的学习资料，供大家更上一层楼！ 一，初学者：可以买《方倍工作室-微信公众号开发php版》（非广告），php简单易学好上手，我的php是幕课网自学的（php由入门到精通）。按照书里的内容稳步研究。期间需要学...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值