Problem executing SQL query in Zend?

Question

I was executing sql query in zend something like this and it was working:

$front = Zend_Controller_Front::getInstance();
$bootstrap = $front->getParam('bootstrap');
$resource = $bootstrap->getPluginResource('db');
$dbAdapter = $resource->getDbAdapter();
$statement = $dbAdapter->query("SELECT * from tablename");
$results = $statement->fetchAll();

At that time my application.ini was something like this:

resources.db.adapter = "Mysqli"
resources.db.params.host = "localhost"
resources.db.params.username = "username"
resources.db.params.password = "password"
resources.db.params.dbname = "dbname"

Question:

Now I changed my application.ini to:

resources.multidb.local.adapter = "Mysqli"
resources.multidb.local.host = "localhost"
resources.multidb.local.username = "username"
resources.multidb.local.password = "passwod"
resources.multidb.local.dbname = "dbname"
resources.multidb.local.default = true

Now above zend code is producing following error:

Fatal error: Call to a member function getDbAdapter() on a non-object in Mapper.php  on line 297

How to fix my code according to new application.ini settings ?

Thanks

Have a look here: jaybill.com/2007/09/12/…

ChrisH
– ChrisH

2011-05-31 12:12:54 +00:00
Commented May 31, 2011 at 12:12 — ChrisH
– ChrisH, Commented May 31, 2011 at 12:12

Yeroon · Accepted Answer · 2011-05-31 12:40:28Z

1

To retrieve the default Database Adapter use the following code:

$bootstrap = Zend_Controller_Front::getInstance()->getParam('bootstrap');
$resource = $bootstrap->getPluginResource('multidb');
$db = $resource->getDb();

edited May 31, 2011 at 12:40

answered May 31, 2011 at 12:19

Yeroon

3,2312 gold badges25 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Student · Accepted Answer · 2011-05-31 12:34:58Z

0

Following code is working for me with multidb configuration in application.ini

$bootstrap = Zend_Controller_Front::getInstance()->getParam('bootstrap');
$resource = $bootstrap->getPluginResource('multidb');
$db = $resource->getDb();
$statement = $db->query("SELECT * from tablename");
$results = $statement->fetchAll();

answered May 31, 2011 at 12:34

Student

1,8739 gold badges37 silver badges50 bronze badges

Collectives™ on Stack Overflow

Problem executing SQL query in Zend?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related