Defining and using multiple DB connections

Multiple database connections are not used very often for new standalone web applications. However, when you are building an add-on application for an existing system, you will most probably need another database connection.

From this recipe you will learn how to define multiple DB connections and use them with DAO, query builder, and Active Record models.

Getting ready

1. Create a new application by using yiic webapp as described in the official guide at the following URL:

   http://www.yiiframework.com/doc/guide/en/quickstart.first-app

2. Create two MySQL databases named db1 and db2.

3. Create a table named post in db1 as follows:

   DROP TABLE IF EXISTS `post`;
   CREATE TABLE IF NOT EXISTS `post` (
     `id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
     `title` VARCHAR(255) NOT NULL,
     `text` TEXT NOT NULL,
     PRIMARY KEY  (`id`)
   );

4. Create a table named comment in db2 as follows:

   DROP TABLE IF EXISTS `comment`;
   CREATE TABLE IF NOT EXISTS `comment` (
     `id` INT(10) UNSIGNED...