Zend Framework 2 - How to access DB adapter in controller

Question

Despite several hits on Google I still couldn't find out how to access the db adapter I configured in my global.php in any controller.

I found this:

$db = $this->getParam('bootstrap')->getPluginResource('db')->getDbAdapter();

But it's giving me a ServiceNotFoundException.

Could anybody be so kind to just tell me a quick way to get to the db adapter for making an raw SQL query? (yes, I know that it shouldn't to this but its just temporary)

Thanks!

Try getting with `$db = Zend_Db_Table::getDefaultAdapter();`. — Rikesh, May 23 '13 at 10:31

score 9 · Accepted Answer · edited May 23 '13 at 10:52

9

You'd access these kind of things through the ServiceManager. Try the following:

$this->getServiceLocator()->get('Zend\Db\Adapter\Adapter'); 
// replace 'Zend\Db\Adapter\Adapter' with name of adapter if different

edited May 23 '13 at 10:52

Sam

16,435
6
55
89

answered May 23 '13 at 10:38

pjabang

199
1
2

Zend Framework 2 - How to access DB adapter in controller

1 Answers1