How to connect to multiple databases at once?

Question

Yii

<?php
return [
    'components' => [
        'db' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'mysql:host=localhost;dbname=name',
            'username' => 'login',
            'password' => 'password',
            'charset' => 'utf8',
        ],
    ],
];

How to access multiple databases at once?

Answer 1

In the config write:

<?php
return [
    'components' => [
       'db' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'mysql:host=localhost;dbname=name',
            'username' => 'login',
            'password' => 'password',
            'charset' => 'utf8',
        ],
        'db2' => [
            'class' => 'yii\db\Connection',
            'dsn' => 'pgsql:host=localhost;dbname=db2',
            'username' => 'user',
            'password' => 'pass',
            'charset' => 'utf8',
        ],
       
];

Then, in models that use the 2nd database, just specify it:

public static function getDb()
    {
        return Yii::$app->db2;
    }