Yii2 set db connection at runtime
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