Thanks this is exactly what I was looking for!!! Is the config XML
preferred over the the config ini, or is this a personal prefrence?
-Tom
On Mon, 2008-06-30 at 10:41 +0200, Guillaume BABIK wrote:
> Hi,
>
> 1st Step:
> Store your DB parameters in a configuration file.
> Typically, I store theses parameters in a config.xml file (in
> /configs directory)
> The XML content could be :
> <database>
> <adapter>Pdo_Pgsql</adapter>
> <params>
> <host>localhost</host>
> <username>postgres</username>
> <password> </password>
> <dbname>db_name</dbname>
> </params>
> </database>
>
> 2nd Step:
> In your bootstrap, load the configuration file
> $frontofficeConfig = new Zend_Config_Xml('../../configs/config.xml', '');
> Zend_Registry::set('frontofficeConfig', $frontofficeConfig);
> => I often put this configuration in the Zend Registry in order to access
> everywhere in my application.
>
> Final Step: The connection
> In your bootstrap, create your connection, store it in the Zend Registry and
> you'll be able to use it everywhere in your application
> The code could be:
>
> try {
> $objDbSource = Zend_Db::factory($frontofficeConfig->database);
> $objDbSource->getConnection();
> $objDbSource->setFetchMode(Zend_Db::FETCH_OBJ);
> Zend_Registry::set('objDbSource', $objDbSource);
> } catch (Zend_Db_Adapter_Exception $e) {
> // perhaps a failed login credential, or perhaps the RDBMS is not
> running
> throw new Exception('Fatal Error : Unable to connect to Database
> Server', $e);
> } catch (Zend_Exception $e) {
> // perhaps factory() failed to load the specified Adapter class
> throw new Exception('Fatal Error : Unable to load the Adaptater',
> $e);
> }
>
> Kind regards,
>
> Guillaume BABIK
> INTERNIM
> 74, rue Baudin
> 92300 LEVALLOIS
> FRANCE
> Tel/Fax : 01.40.87.11.20
> Mobile : 06.80.21.90.29
> http://www.internim.com
>
> -----Message d'origine-----
> De : Tom Printy [mailto:[EMAIL PROTECTED]
> Envoyé : samedi 28 juin 2008 21:35
> À : [email protected]
> Objet : [fw-general] DB connection params
>
> Hello,
>
> I am just starting with the Zend framework. I am using the MVC
> fucntionality and would like to know the best practice for configuring
> and using DB connection paramaters. I don't think I want to this in
> every function that connects to a db.
>
> params = array(
> 'host' => 'localhost',
> 'username' => 'postgres',
> 'password' => '',
> 'dbname' => ''
> );
>
> $DB = Zend_Db::factory('pdo_pgsql', $params);
>
>
>
> Thanks
> -Tom Printy
>
