Thanks again.... I am just seeking the "Best Practices" while building
my application.
Thanks
-Tom
On Mon, 2008-06-30 at 10:43 -0400, Matthew Weier O'Phinney wrote:
> -- Tom Printy <[EMAIL PROTECTED]> wrote
> (on Monday, 30 June 2008, 09:19 AM -0500):
> > 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?
>
> Merely a personal preference. Some of us even like using arrays to feed
> our Zend_Config objects. :-)
>
>
> > 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
> > >
> >
>
