Zend database adapter - register in bootstrap.php?

Question

I am trying to register my default database adapter in my bootstrap.php file so that I can access it where ever I am. This is my code so far:

//bootstrap.php
protected function _initDb()
{
    $dbAdapter = Zend_Db::factory(Zend_Registry::get('configuration')
                                       ->resources->db->adapter, 
                                  Zend_Registry::get('configuration')
                                       ->resources->db->params->toArray());

    Zend_Registry::set('dbAdapter', $dbAdapter);
    Zend_Db_Table_Abstract::setDefaultAdapter($dbAdapter);
}

I am then trying to call it in one of my models by saying:

//exampleModel.php
$select = $this->_getDbAdapter()
                ->select()
                ->from(array('t' => $this->_getTable()->getName()), 
                       array('name'))....

However I am just getting the error:

Call to undefined method Application_Model_Example::_getdbAdapter() in...

So obviously it is looking for it within my current class and can't find it...

Have you tried doing this in application.ini? I think that's a better place to do it. — vascowhite
– vascowhite, Commented Aug 10, 2011 at 13:50
doing what???? i have declared my db host, name and password etc in application ini but i am noe trying to create the adapter — Pjn2020
– Pjn2020, Commented Aug 10, 2011 at 13:51
it's already created. have you read this? framework.zend.com/manual/en/… — vascowhite
– vascowhite, Commented Aug 10, 2011 at 13:54

yokoloko · Accepted Answer · 2011-08-10 13:54:53Z

1

You need this in your Model_Example

public function _getSqlAdapter()
{
    return Zend_Registry::get('dbAdapter');
}

Or directly call Zend_Db_Table::getDefaultAdapter() instead of $this->_getDbAdapter()

answered Aug 10, 2011 at 13:54

yokoloko

2,8703 gold badges23 silver badges27 bronze badges

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

2 Comments

Pjn2020 Over a year ago

thanks man so obvious now i see... is there somewhere i can put this method so that i dont have to have it in every model and i can just say $select = $this->_getDbAdapter()?

yokoloko Over a year ago

You can create an Abstract Model and extend it inside all your models or just call Zend_Db_Table::getDefaultAdapter()

piddl0r · Accepted Answer · 2011-08-10 13:56:33Z

0

In the code provided you don't appear to be calling it the adapter from the registry. You would need to use Zend_Registry::get('dbAdapter');

What class does Application_Model_Example extend?

answered Aug 10, 2011 at 13:56

piddl0r

2,4492 gold badges23 silver badges36 bronze badges

Comments

ChrisA · Accepted Answer · 2011-08-10 13:58:41Z

0

I have Zend_Db_Table::setDefaultAdapter($dbAdapter); in my bootstrap (notice its Zend_Db_Table, not Zend_Db_Table_Abstract).

Then in my models, I would just use

$select = $this->->select()
    ->from(array('t' => $this->_getTable()->getName()), array('name'))....

assuming your model extends Zend_Db_Table?

answered Aug 10, 2011 at 13:58

ChrisA

2,1011 gold badge14 silver badges23 bronze badges

Collectives™ on Stack Overflow

Zend database adapter - register in bootstrap.php?

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

2 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related