Zend Framework多資料庫設定

因為在ZF中資料庫是以資源的方式提供
所以在application.ini中設置

[production]

resources.multidb.db1.adapter = "pdo_mysql"

resources.multidb.db1.host = "localhost"

resources.multidb.db1.username = "webuser"

resources.multidb.db1.password = "XXXX"

resources.multidb.db1.dbname = "db1"

resources.multidb.db2.adapter = "pdo_pgsql"

resources.multidb.db2.host = "example.com"

resources.multidb.db2.username = "dba"

resources.multidb.db2.password = "notthatpublic"

resources.multidb.db2.dbname = "db2"

resources.multidb.db2.default = true

再由Bootstrap取得資料庫

$resource = $bootstrap->getPluginResource('multidb');

$db1 = $resource->getDb('db1');

$db2 = $resource->getDb('db2');

$defaultDb = $resource->getDb();