how to make variables in pre_controller hooks global to all controllers?

[eluser]ajsie[/eluser]
in my pre_controller hook i have this code for doctrine:

$manager = Doctrine_Manager::getInstance();
$conn = Doctrine_Manager::connection($db[$active_group]['dsn']);

then in my controller i have this code to use doctrine connection i've created:

$conn->export->createTable('test', array('name' => array('type' => 'string')));
$conn->execute('INSERT INTO test (name) VALUES (?)', array('jwage'));

but $conn is undefined so it wont work. if i put the code in the pre_controller hook it will work.

how can i make variables i declare in hooks available for all controllers so that i dont have to create a new connection all the time?

[eluser]umefarooq[/eluser]
create a MY_Controller in library and extend you Controllers with you MY_Controller

Code:

class MY_Controller extends Controller{

  $manager;
  $conn;

  function MY_Controller(){
      $this->manager = Doctrine_Manager::getInstance();
      $this->conn = Doctrine_Manager::connection($db[$active_group][‘dsn’]);
  }

}

class your_Controller extends MY_Controller{
  $this->conn->export->createTable(‘test’, array(‘name’ => array(‘type’ => ‘string’)));
  $this->conn->execute(‘INSERT INTO test (name) VALUES (?)’, array(‘jwage’));
}

[eluser]ajsie[/eluser]
thanks. ill do that.

but what if i want to use it in a model or another class for some reasons?

[eluser]umefarooq[/eluser]
the also do the same thing it will work really fine for more information read this article will help you more

http://philsturgeon.co.uk/news/2010/02/C...ing-it-DRY