On the first article about the Zend Framework series, i have covered out the Setup of the Development Environment, on this article i will cover the Zend Framework configuration files and the database connection.
I will try to guide you on a brief and short path to start using the database in your Zend Framework project.
First Task – The configuration file
Our first task for today is to create the configurations file, i prefer to use php .ini files to save configuration settings, due to it’s clean and functional organization.
On your /public/config/ folder, create a file named configurations.ini with the following content.
[production] database.adapter = pdo_mysql database.params.host = localhost database.params.username = root database.params.password = xpto database.params.dbname = restaurant [development : production ] database.params.host = 127.0.0.1 database.params.username= root database.params.password= ypto
I am defining my database settings to use PDO_Mysql driver and all the database needed settings, as you can see i am using two sections, the first one named [production] and the second one named [development:production] the : separation means that we are inheriting our development section from um previous production, and we will override some of the definitions. You can read more about this on the Zend Framework Config instructions.
Second Task: Load the configuration settings on your bootstrap file
Now that you have created the configuration file, you need to give some use tho it, lets go to the previously created bootstrap file, on your path /public/bootstrap.php, after the line that contains “Zend_Loader::registerAutoload();“, add the following content:
/** * Loading configuration from ini file */ $configuration = new Zend_Config_Ini( './config/configurations.ini', 'development' );
We are reading the configuration file into a Zend_Config Object, to access the object you could by example do:
Third Task: Creating the database handler
Now that we have the configurations needed on a Zend_Config object we are ready to create the database connection. In order to do that, just after the previous code on bootstrap.php file, add the content.
/** * Creating the database handler from the loaded ini file */ $dbAdapter = Zend_Db::factory($configuration->database); /** * Lets define the newly created handler as our default database handler */ Zend_Db_Table_Abstract::setDefaultAdapter($dbAdapter);
Fourth Task: Using the Zend Registry to save the values
Now that we have our application using the database handler, and we are connected to the database, i will save the $configurations values and the $dbAdapter on the Registry for further usage.
/** * Lets add the configurations and the database handler to Registry * to use in future */ $registry = Zend_Registry::getInstance(); $registry->configuration = $configuration; $registry->dbAdapter = $dbAdapter; /** * Now that we have the values on the Registry, lets cleanuo the variables * from the script scope */ unset($dbAdapter, $registry,$configuration);
You can read more about Zend Registry on the framework manual.
On this article, i have approached the Zend Config, Zend_Db and Zend_Registry usage, i are now able to deal with each one of this components, on my next article on this series, i will help you to create a Model extending the Zend_Db_Table.