-- 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
> >
>
--
Matthew Weier O'Phinney
Software Architect | [EMAIL PROTECTED]
Zend Framework | http://framework.zend.com/
