The way I have done it (rightly or wrongly) and it works is:
Index.php
---------
$db = Zend_Db::factory('PDO_SQLITE', array('dbname' => 'myDb.db3'));
Zend_Db_Table_Abstract::setDefaultAdapter($db);
Then in my models directory I have
Users.php
---------
<?php
/**
* Manage users table
*
*/
class Users extends Zend_Db_Table_Abstract
{
/**
* Table name
*
* @var string
*/
protected $_name = 'users';
/**
* Load current user data
*
* @param string $user
*/
public function getUser($user)
{
$where = $this->getAdapter()->quoteInto('username = ?', $user);
return $this->fetchRow($where);
}
}
Then in my controller I have
IndexController.php
-------------------
$userTable = new Users();
$getUser = $user->getUser($currentUsername);
$this->view->name = $getUser->name;
$this->view->age = $getUser->age;
Etc......
Hope this helps.
- Robert
-----Original Message-----
From: Joseph Crawford [mailto:[EMAIL PROTECTED]
Sent: 15 May 2008 14:17
To: [email protected]
Subject: [fw-general] Dumb Question
In my index.php bootstrap file I setup the database connection into a
variable $db. Now I need to access this in other controllers. This seems
like a dumb question to me but do I need to global $db; before I can access
it in the indexAction method of the controller or is it in the global scope
by default?
Thanks,
Joseph Crawford
________________________________________________________________________
This email has been scanned for all known viruses by the MessageLabs Email
Security Service and the Macro 4 plc internal virus protection system.
________________________________________________________________________
________________________________________________________________________
This email has been scanned for all known viruses by the MessageLabs Email
Security Service and the Macro 4 plc internal virus protection system.
________________________________________________________________________
