Yii2 set db connection at runtime

Question

In my Yii2 (basic application) web.php I configure a NULL db connection as 2nd database connection.

This needs to be filled with valid parameters which are coming from a record on the main db connection:

'db' => require(__DIR__ . '/db.php'),
'db2' => [
    'class' => 'yii\db\Connection',
    'dsn' => NULL,
    'username' => NULL,
    'password' => NULL,
    'charset' => 'utf8',
],

After initializing the app() i need to fill out the NULL parameters with values that i retrieve from another database to further use it in models.

How can i achieve this in Yii2?

Thao Ngo · Accepted Answer · 2017-01-15 02:38:39Z

11

No problem, it is supported

\Yii::$app->db2->close(); // make sure it clean
\Yii::$app->db2->dsn= 'yourdsn';
\Yii::$app->db2->username = 'username';
\Yii::$app->db2->password = 'password';

Done, now you can use it

Yii::$app->db2->...

Another way:

$connection = new \yii\db\Connection([
    'dsn' => $dsn,
    'username' => $username,
    'password' => $password,
]);
$connection->open();
$command = $connection->createCommand('SELECT * FROM post')->....;

Refer: http://www.yiiframework.com/doc-2.0/yii-db-connection.html

edited Jan 15, 2017 at 2:38

answered Jan 9, 2017 at 23:58

Thao Ngo

3,7811 gold badge23 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Andreas Hinderberger Over a year ago

Thanks a lot. This works perfect. I'm using the 1st approach. Now i can do in my models which need only access to the "other" database : public static function getDb() { return Yii::$app->db2; }. This will pull it from the right DB then. As a side not, i've moved all models for the "other" database into a seperate namespace. I think i could also extend ActiveRecord seperately for this namespace, but the getDB in there and then extend all models in that namespace off that AR class.

Nadeem Shaikh Over a year ago

Thanks a lot, I am using first one and its working fine.

Collectives™ on Stack Overflow

Yii2 set db connection at runtime

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related