Ezeelive Technologies

Codeigniter is a PHP framework which uses the MVC pattern for the development and gives the many flexible way to do the coding and make the project. It has many in build library which helps a lot for the development and immediate using these things also make the project development time less which also saves your lots of timing and money. Codeigniter contains the many folders and file after installation in that only we have to make the changes the do the coding. It makes the development in less coding and also reduces the duplicate code methods so it makes the execution fast and perfect. Click to read full article :  http://www.ezeelive.com/blog/10-reason-codeigniter-mvc-framework-better-php-frameworks/

Recently in one of Ireland based project client has requirement to use existing Microsoft SQL Server database and implement new feature and store data into MySQL database with Yii Framework. First we have  install and implement microsoft sql server driver in wamp server  to make in localhost environment. Now we have to connect both the Database in Yii Framework. Following is steps to implement in Yii Framework : 1. In protected/config folder open main.php and add below code in component for mysql and sql server connection 'db'=>array(  // default mysql connection 'connectionString' => 'mysql:host=localhost;port=3306;dbname=db_name', 'emulatePrepare' => true, 'username' => 'db_username', 'password' => 'db_password', 'charset' => 'utf8', 'tablePrefix' =>'tbl_',  // if have prefix in database tables ), 'msdb'=>array( // microsoft sql server connection