multiple database connection with Zend framework 2

[gaurangrajvir]

Hello All,

I want to connect two database in one application.

One database from Mysql and another from Sql server.

How can I do this in ZF 2 ?

Has anyone know about this then please suggest.

Thanks in advance.
Gaurang

[hczo8uk9prrpljya12x]

first setting file application.ini, ex:
resources.multidb.db1.adapter = "mysqli"
resources.multidb.db1.isDefaultTableAdapter = true
resources.multidb.db1.host = "localhost"
resources.multidb.db1.username = "xx"
resources.multidb.db1.password = "xx"
resources.multidb.db1.dbname = "zftutorial"

resources.multidb.db2.adapter = "mysqli"
resources.multidb.db2.isDefaultTableAdapter = false
resources.multidb.db2.host = "localhost"
resources.multidb.db2.username = "xx"
resources.multidb.db2.password = "xx"
resources.multidb.db2.dbname = "bboard"

setting bootstrap.php, ex:
protected function _initDatabase ()
{
$resource = $this->getPluginResource('multidb');
$resource->init();

Zend_Registry::set('db1', $resource->getDb('db1'));
Zend_Registry::set('db2', $resource->getDb('db2'));
}

then you can call by doing like this :
$db = Zend_Registry::get('db1');
$result = $db->fetchAll ( "select * from mytable", array ());

hope it helps

[saruniiit]

is it working. i am getting error

Fatal error: Uncaught exception 'Zend_Db_Adapter_Exception' with message 'Configuration array must have a key for 'dbname' that names the database instance' in E:\zend\Apache2\htdocs\twitter\library\Zend\Db\Adapter\Abstract.php:287 Stack trace: #0 E:\zend\Apache2\htdocs\twitter\library\Zend\Db\Adapter\Abstract.php(183): Zend_Db_Adapter_Abstract->_checkRequiredOptions(Array) #1 E:\zend\Apache2\htdocs\twitter\library\Zend\Db.php(270): Zend_Db_Adapter_Abstract->__construct(Array) #2 E:\zend\Apache2\htdocs\twitter\library\Zend\Application\Resource\Multidb.php(99): Zend_Db::factory('PDO_MYSQL', Array) #3 E:\zend\Apache2\htdocs\twitter\application\Bootstrap.php(9): Zend_Application_Resource_Multidb->init() #4 E:\zend\Apache2\htdocs\twitter\library\Zend\Application\Bootstrap\BootstrapAbstract.php(669): Bootstrap->_initDatabase() #5 E:\zend\Apache2\htdocs\twitter\library\Zend\Application\Bootstrap\BootstrapAbstract.php(622): Zend_Application_Bootstrap_BootstrapAbstract->_executeResource('database') #6 E:\zend\Apache2\htdocs\twitt in E:\zend\Apache2\htdocs\twitter\library\Zend\Db\Adapter\Abstract.php on line 287

[saruniiit]

finally got it.


in the application.ini

dont put params


so it will be like this

resources.multidb.db1.adapter = PDO_MYSQL
resources.multidb.db1.isDefaultTableAdapter = true
resources.multidb.db1.host = "localhost"
resources.multidb.db1.username = "root"
resources.multidb.db1.password = ""
resources.multidb.db1.dbname = ""

resources.multidb.db2.adapter = PDO_MYSQL
resources.multidb.db2.isDefaultTableAdapter = false
resources.multidb.db2.host = "localhost"
resources.multidb.db2.username = "root"
resources.multidb.db2.password = ""
resources.multidb.db2.dbname = ""

[pragnesh]

Good article..!!