Saturday, October 15, 2011

MySQL configuration for Zend Framework

To use MySql database in your zend project u should add the following code to application/configs/application.ini under "[production]":


resources.db.adapter = "PDO_MYSQL"
resources.db.params.host = "localhost"
resources.db.params.username = "USERNAME"
resources.db.params.password = "PASSWORD"
resources.db.params.dbname = "DATABASE_NAME"
// for Arabic or other language you should add this lines below  //
resources.db.params.charset = "utf8"
resources.db.params.driver_options.1002 = "SET NAMES utf8"