How to get resource in controller action?

Question

How to get resource in controller action? Resource db was initialized in application.ini.

class IndexController extends Zend_Controller_Action
{

    public function init()
    {
        /* Initialize action controller here */
    }

    public function indexAction()
    {
        // I want db resource here
    }
}

Answer 1

Try and see if this works:

$this->getFrontController()->getParam('bootstrap')->getResource('db') 

Answer 2

UPDATE : While this solution works, it is NOT a recommended practice. Please, read comment by @Brian M. below.

You can use Zend_Registry. Initialize the database connection in the bootstrap and store it in the registry:

// set up the database handler
// (...)
Zend_Registry::set('dbh', $dbh);

Then you can retireve it from anywhere else:

$dbh = Zend_Registry::get('dbh');