Dynamically Change The Cdbauthmanager Connectionid

joao.costa · October 16, 2013, 11:35am

Hi.

I’m opening this topic to ask if someone can help me in a problem that i have.

I have the following on my "config/main.php" file:




(...)

'authManager'=>array(

'class'=>'CDbAuthManager',

        'connectionID'=>'db',

                    

),


          

'db'=>array(

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

	'emulatePrepare' => true,

	'username' => 'root',

	'password' => '',

	'charset' => 'utf8',

),

(...)

My question is, how can i change dynamically the connectionID from ‘authManager’ component?

Any help is much appreciated.

Thank You.

chandrantwins · October 16, 2013, 3:15pm

Hi,

You can have two database like below main.php

	'db'=&gt;array(


		'connectionString' =&gt; 'mysql:host=localhost;dbname=e-learning',


		'emulatePrepare' =&gt; true,

[size=2] [/size][size=2]‘username’ => ‘root’,[/size]

		'password' =&gt; '',


		'charset' =&gt; 'utf8',


	),


	'addressdb'=&gt;array(


		'connectionString' =&gt; 'mysql:host=127.0.0.1;dbname=address',


		'emulatePrepare' =&gt; true,


		'username' =&gt; 'root',


		'password' =&gt; '',


		'charset' =&gt; 'utf8',


		'class'   =&gt; 'CDbConnection'


	),

In model

access like this…u have to overide this method…if you dont override . u can access db directly

/**

 * @return CDbConnection


 */


public function getDbConnection(){


	return Yii::app()-&gt;addressdb;


}

In this way u can dynamically access db or addressdb…

I hope it will help to solve your problem…