在yii中登录后使用额外的数据库

Question

Does anyone know of a way in which I can add an extra database connection field to the yii configuration file after I've successfully logged in a user to my site?

We've got a global System Database where we configure our users and save a field with their database name. I would like to create another connection to that database after authenticating the user. Thus referencing it like Yii::app()->clientDB. Is this possible?

Every client on our system have their own respective database with tables.

Answer 1

You can achieve it by this code (not tested, but should work):

$connection = new CDbConnection($dsn, $username, $password);
$connection->active = true;
Yii::app()->setComponent('clientDB', $connection);