multiple DB connection types

tthai1980 · February 28, 2009, 10:09pm

Lets say I have a local, test, and live database for my app.

is there a way to specify which db connection to use?

qwerty · February 28, 2009, 10:23pm

Hi,

i thing that you should modify connectionString, username and password from CDbConnection in your controller class.

tthai1980 · March 1, 2009, 12:45am

Yes I am aware that is how you specificy db settings.

What I'm referring to is, can there be support for

'db'=>array('local' => array(

		&#039;class&#039; =&gt; &#039;CDbConnection&#039;,


		&#039;connectionString&#039;=&gt;&#039;mysql:host=localhost;dbname=yii_flocms&#039;,


		&#039;username&#039; =&gt; &#039;root&#039;,


		&#039;password&#039; =&gt; &#039;&#039;

),

'test' => array(…),

'live' => array(…),

),

qiang · March 1, 2009, 12:49am

You may refer to this article written by Jonah:

http://php-thoughts…configuring-it/

umutau · March 2, 2009, 12:57am

I would like to extend to question

I would like read from one database and when I write I would like to use another database for security issue. Is there an way I can define 2. or 3 database connection settings in one config file or I have to use other config file ?

qiang · March 2, 2009, 1:03am

You can configure an additional DB application component, for example, 'db2'. Then you can use Yii::app()->db2 to access this new DB connection.