Zend framework之数据库连接

在application/configs/目录下创建一个文件db.ini

 

 

[general]

db.adapter = PDO_MYSQL

db.config.host = localhost

db.config.username =

db.config.password =

db.config.dbname = first_php

 

或在application.ini里加入

 

resources.db.adapter = PDO_MYSQL   

resources.db.params.host = localhost   

resourcesresources.db.params.username =  

resources.db.params.password =  

resources.db.params.dbname = first_php

 

在Bootstrap.php里添加如下代码

 

    protected function _initDBconn() {
        $configFile = APPLICATION_PATH . '/configs/db.ini';
        $config = new Zend_Config_Ini($configFile, null, true);
        Zend_Registry::set('config', $config);
        $dbAdapter = Zend_Db::factory($config->general->db->adapter, 
            $config->general->db->config->toArray());
        $dbAdapter->query("SET NAMES gb2312");
        Zend_Db_Table::setDefaultAdapter($dbAdapter);
        Zend_Registry::set('dbAdapter', $dbAdapter);
    }

 

数据库查询的几种方式：Zend_Db_Table, Zend_Db_Adapter, Zend_Db_Statement, Zend_Db_Select:动态创建select语句