making $db variable available

[eleach]

I initialized a new Zend Framework project from within Zend Studio.

In bootstrap.php I set a db adapter:

$db = new Zend_Db_Adapter_Pdo_Mysql(array(
'host' => 'localhost',
'username' => 'user',
'password' => 'pass',
'dbname' => 'mydb'
));

In my controller file, I'm creating a new object that extends Zend_Db_Table:

include '/var/www/html/ztest/application/default/models/Browse.php'; (extends Zend_Db_Table)
$mytab = new Browse(array('db' => $db));

I'm getting the error $db is undefined. What is the right way to define the adapter so that it is available to the controller files?

Thanks

[ericritchie]

Hi Eleach,

The cleanest way would be to use the singleton design pattern to connect to your database. However this would also work (extract copied from the Framework documentation):

Code: Select all

Example 11.83. Example of constructing a Table using a Registry key
$db = Zend_Db::factory('PDO_MYSQL', $options);
Zend_Registry::set('my_db', $db);
// Later...
$table = new Bugs(array('db' => 'my_db'));

Reagrds,
Eric Ritchie.

[rampog]

@ericritchie


what is the differences if i using zend_registry & using global keyword

Code: Select all

global $db

thanks before