Multiple Database connection

Yii 1.1 General Discussion
1

Hi Any body Know How connect multiple database connection

2

in your config




'db2' => array(

    'class' => 'CDBConnection',

    'connectionString' => 'mysql:host=localhost;dbname=db2',

    'username' => 'root',

    'password' => '',

    'charset' => 'utf8'

)

then anywhere




$command = Yii::app()->db2->createCommand($sql);
3

thanks for your info

4

Also note that you can set the database in the model by overriding the getDbConnection() method. This allows you to transparently use multiple databases without your controllers and such having to be aware.

5

Thanks I solved that problem