public function fetchAll($sql, $bind = array(), $fetchMode = null){}
public function fetchRow($sql, $bind = array(), $fetchMode = null){}
public function fetchAssoc($sql, $bind = array()){}
public function fetchCol($sql, $bind = array()){}
public function fetchPairs($sql, $bind = array()){}
public function fetchOne($sql, $bind = array()){}

public function insert($table, array $bind)
public function update($table, array $bind, $where = '')
public function delete($table, $where = '')

; multirwdb Databse setting
autoloadernamespaces[] = "Mudb"
pluginPaths.Mudb_Application_Resource = "Mudb/Application/Resource"
resources.multirwdb.model = "Rw"
resources.multirwdb.master[] = "db1"
resources.multirwdb.master[] = "db5"
resources.multirwdb.slave[] = "db2"
resources.multirwdb.slave[] = "db3"
resources.multirwdb.slave[] = "db4"
resources.multirwdb.db.db1.adapter = "pdo_mysql"
resources.multirwdb.db.db1.host     = "localhost"
resources.multirwdb.db.db1.username = "wacow"
resources.multirwdb.db.db1.password = "123456"
resources.multirwdb.db.db1.dbname   = "wacow"
resources.multirwdb.db.db1.charset  = "UTF8"
resources.multirwdb.db.db1.profiler.enabled = true
resources.multirwdb.db.db1.profiler.class = "Zend_Db_Profiler_Firebug"
 
resources.multirwdb.db.db2.adapter = "pdo_mysql"
resources.multirwdb.db.db2.host     = "localhost"
resources.multirwdb.db.db2.username = "wacow"
resources.multirwdb.db.db2.password = "123456"
resources.multirwdb.db.db2.dbname   = "wacow"
resources.multirwdb.db.db2.charset  = "UTF8"
resources.multirwdb.db.db2.profiler.enabled = true
resources.multirwdb.db.db2.profiler.class = "Zend_Db_Profiler_Firebug"
resources.multirwdb.db.db2.default = true
 
resources.multirwdb.db.db3.adapter = "pdo_mysql"
resources.multirwdb.db.db3.host     = "localhost"
resources.multirwdb.db.db3.username = "wacow"
resources.multirwdb.db.db3.password = "123456"
resources.multirwdb.db.db3.dbname   = "wacow"
resources.multirwdb.db.db3.charset  = "UTF8"
resources.multirwdb.db.db3.profiler.enabled = true
resources.multirwdb.db.db3.profiler.class = "Zend_Db_Profiler_Firebug"
resources.multirwdb.db.db3.default = true
 
resources.multirwdb.db.db4.adapter = "pdo_mysql"
resources.multirwdb.db.db4.host     = "localhost"
resources.multirwdb.db.db4.username = "wacow"
resources.multirwdb.db.db4.password = "123456"
resources.multirwdb.db.db4.dbname   = "wacow"
resources.multirwdb.db.db4.charset  = "UTF8"
resources.multirwdb.db.db4.profiler.enabled = true
resources.multirwdb.db.db4.profiler.class = "Zend_Db_Profiler_Firebug"
resources.multirwdb.db.db4.default = true
 
resources.multirwdb.db.db5.adapter = "pdo_mysql"
resources.multirwdb.db.db5.host     = "localhost"
resources.multirwdb.db.db5.username = "wacow"
resources.multirwdb.db.db5.password = "123456"
resources.multirwdb.db.db5.dbname   = "wacow"
resources.multirwdb.db.db5.charset  = "UTF8"
resources.multirwdb.db.db5.profiler.enabled = true
resources.multirwdb.db.db5.profiler.class = "Zend_Db_Profiler_Firebug"
resources.multirwdb.db.db5.default = true

<?php
class Bootstrap extends Zend_Application_Bootstrap_Bootstrap
{
	protected $_defaultDb = null;
	protected $_CacheDB = null;
	protected $_View = null;
	protected $_Customer = null;
	protected function _initDatabase() {
		if ($this->_defaultDb === null) {
			if ($this->hasPluginResource('multirwdb')) {
				$this->bootstrap('multirwdb');
				$resource = $this->getPluginResource('multirwdb');
				$this->_defaultDb = $resource->getDefaultDb();
			}elseif($this->hasPluginResource('db')){
				$this->bootstrap('db');
				$this->_defaultDb = $this->getPluginResource('db')->getDbAdapter();
			}
		}
		Zend_Registry::set('db',$this->_defaultDb);
	}
     protected function _initZFDebug() {
    if ($this->_defaultDb === null) {
			$this->_initDatabase();
    }
		$options = array(
	    	'plugins' => array(
				'Html',
				'Variables',
				'Memory',
				'Time',
				'Database' => ($this->hasPluginResource('multirwdb')) ? array('adapter' => MuDB_Db::getAllDb()) : array('adapter' => array('default' => $this->_defaultDb)),
				'File' => array('base_path' => realpath(APPLICATION_PATH . '/../')),
				'Registry',
				'Exception',
	 	));
    $debug = new ZFDebug_Controller_Plugin_Debug($options);
		$this->bootstrap('frontController');
		$frontController = $this->getResource('frontController');
		$frontController->registerPlugin($debug);
 
	}

<?php
class IndexController extends Zend_Controller_Action
{
    public function init()
    {
        $this->db=Zend_Registry::get('db');
    }
 
    public function indexAction()
    {
		$select_test = $this->db->select()->from('system_permissions', '*')->limit(100);
		$result = $this->db->fetchAll($select_test);
		$result = $this->db->fetchAll($select_test);
		$result = $this->db->fetchAll($select_test);
		$result = $this->db->fetchAll($select_test);
		$data= array('test' => rand(5, 15));
		$this->db->insert('test', $data);
    }
}

autoloadernamespaces[] = "Smarty3"
pluginPaths.Smarty3_Application_Resource = "Smarty3/Application/Resource"
resources.smarty.script_path = APPLICATION_PATH "/"
resources.smarty.view_suffix = "tpl.htm"
resources.smarty.params.left_delimiter = "<%"
resources.smarty.params.right_delimiter = "%>"
resources.smarty.params.plugins_dir = APPLICATION_PATH "/lib/My/Smarty/plugins"
resources.smarty.params.compile_dir = APPLICATION_PATH "/../tmp/compiled"
resources.smarty.helper_dirs.key[] = "Zend/View/Helper"
resources.smarty.helper_dirs.value[] = "Zend_View_Helper_"
;如果將來需要自己的 View Helper ，可以放在這裡
resources.smarty.helper_dirs.key[] = "My/View/Helper"
resources.smarty.helper_dirs.value[] = "My_View_Helper_"

autoloadernamespaces[] = "Smarty2"

<?php
class Bootstrap extends Zend_Application_Bootstrap_Bootstrap
{
		protected function _initView(){
	        $view = new Smarty2_View_Smarty (array(
			            'scriptPath' => APPLICATION_PATH . '/',
			            'params' => array(
			                'left_delimiter' => '<%', // 改成你慣用的
			                'right_delimiter' => '%>', // 改成你慣用的
			                'plugins_dir' => APPLICATION_PATH . '/library/Smarty2/Smarty/plugins', // 自訂的 Smarty plugins 可以放這裡
			                'compile_dir' => APPLICATION_PATH . '/../tmp/compiled',
			            ),
			            'helper_dirs' => array(
			                //'My/View/Helper' => 'My_View_Helper_', // 如果將來需要自己的 View Helper ，可以放在這裡
			                'Zend/View/Helper' => 'Zend_View_Helper_'
			            ),
			        ));
 
 
	        // Controller Plugin
	        Zend_Controller_Front::getInstance()->registerPlugin(new Smarty2_Controller_Plugin_Smarty());
 
	        // View Renderer
	        Zend_Controller_Action_HelperBroker::getStaticHelper('ViewRenderer')
	            ->setViewSuffix('tpl.htm') // 可以改成慣用的樣版副檔名
	            ->setView($view);
 
	        // Zend Layout
	        $view->layout = Zend_Layout::startMvc(array(
	            'inflectorTarget' => 'layouts/scripts/:script.:suffix',
	            'layout' => 'layout',
	            'viewSuffix' => 'tpl.htm', // 可以改成慣用的樣版副檔名
	        ))->setView($view);
	    }
}

autoloadernamespaces[] = "Smarty3"

<?php
class Bootstrap extends Zend_Application_Bootstrap_Bootstrap
{
		protected function _initView(){
	        $view = new Smarty3_View_Smarty (array(
			            'scriptPath' => APPLICATION_PATH . '/',
			            'params' => array(
			                'left_delimiter' => '<%', // 改成你慣用的
			                'right_delimiter' => '%>', // 改成你慣用的
			                'plugins_dir' => APPLICATION_PATH . '/library/Smarty3/Smarty/plugins', // 自訂的 Smarty plugins 可以放這裡
			                'compile_dir' => APPLICATION_PATH . '/../tmp/compiled',
			            ),
			            'helper_dirs' => array(
			                //'My/View/Helper' => 'My_View_Helper_', // 如果將來需要自己的 View Helper ，可以放在這裡
			                'Zend/View/Helper' => 'Zend_View_Helper_'
			            ),
			        ));
 
 
	        // Controller Plugin
	        Zend_Controller_Front::getInstance()->registerPlugin(new Smarty3_Controller_Plugin_Smarty());
 
	        // View Renderer
	        Zend_Controller_Action_HelperBroker::getStaticHelper('ViewRenderer')
	            ->setViewSuffix('tpl.htm') // 可以改成慣用的樣版副檔名
	            ->setView($view);
 
	        // Zend Layout
	        $view->layout = Zend_Layout::startMvc(array(
	            'inflectorTarget' => 'layouts/scripts/:script.:suffix',
	            'layout' => 'layout',
	            'viewSuffix' => 'tpl.htm', // 可以改成慣用的樣版副檔名
	        ))->setView($view);
	    }
}

[production]
phpSettings.display_startup_errors = 0
phpSettings.display_errors = 0
includePaths.library = APPLICATION_PATH "/../library"
bootstrap.path = APPLICATION_PATH "/Bootstrap.php"
bootstrap.class = "Bootstrap"
appnamespace = "Application"
resources.frontController.controllerDirectory = APPLICATION_PATH "/controllers"
resources.frontController.params.displayExceptions = 0
;resources.frontController.noViewRenderer = 1
 
autoloadernamespaces[] = "ZFDebug"
;Stand Databse setting
resources.db.adapter         = "pdo_mysql"
resources.db.params.host     = "localhost"
resources.db.params.username = "wacow"
resources.db.params.password = "123456"
resources.db.params.dbname   = "wacow"
resources.db.params.charset  = "UTF8"
resources.db.params.profiler = true
;resources.db.isDefaultTableAdapter = true
; Multidb Databse setting
resources.multidb.db1.adapter = "pdo_mysql"
resources.multidb.db1.host     = "localhost"
resources.multidb.db1.username = "wacow"
resources.multidb.db1.password = "123456"
resources.multidb.db1.dbname   = "wacow"
resources.multidb.db1.charset  = "UTF8"
resources.multidb.db1.params.profiler.enabled = true
resources.multidb.db1.params.profiler.class = "Zend_Db_Profiler_Firebug"
 
resources.multidb.db2.adapter = "pdo_mysql"
resources.multidb.db2.host     = "localhost"
resources.multidb.db2.username = "wacow"
resources.multidb.db2.password = "123456"
resources.multidb.db2.dbname   = "wacow"
resources.multidb.db2.charset  = "UTF8"
resources.multidb.db2.params.profiler.enabled = true
resources.multidb.db2.params.profiler.class = "Zend_Db_Profiler_Firebug"
;resources.multidb.db2.default = true
 
[staging : production]
 
[testing : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
 
[development : production]
phpSettings.display_startup_errors = 1
phpSettings.display_errors = 1
resources.frontController.params.displayExceptions = 1

<?php
 
class Bootstrap extends Zend_Application_Bootstrap_Bootstrap
{
	protected $_defaultDb = null;
	protected function _initDatabase() {
		if ($this->_defaultDb === null) {
		if ($this->hasPluginResource('multidb')) {
			$this->bootstrap('multidb');
			$resource = $this->getPluginResource('multidb');
			$this->_defaultDb = $resource->getDefaultDb();
		}elseif($this->hasPluginResource('db')){
			$this->bootstrap('db');
			$this->_defaultDb = $this->getPluginResource('db')->getDbAdapter();
		}}
	}
	protected function _initZFDebug() {
		$options = array(
	    	'plugins' => array(
	    	'Html',
				'Variables',
				'File' => array('base_path' => realpath(APPLICATION_PATH . '/../')),
				'Memory',
				'Time',
				'Registry',
				'Exception',
	 	));
		if ($this->_defaultDb === null) {
            $this->_initDatabase();
        }
		$options['plugins']['Database']['adapter'] = $this->_defaultDb;
		$debug = new ZFDebug_Controller_Plugin_Debug($options);
 
		$this->bootstrap('frontController');
		$frontController = $this->getResource('frontController');
		$frontController->registerPlugin($debug);
	}
}