How to connect multiple databases in yii2

A project will require connecting to multiple databases as needed. So how to connect multiple databases in yii2? It's actually very simple and can be completed with a little configuration in the configuration file.

The configuration method is as follows:

Open the database configuration file common\config\main-local.php, add db2 under the original db configuration item, and configure the properties of the second database.

Example:

'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=localhost;dbname=hyii2', //数据库hyii2 'username' => 'root', 'password' => 'pwhyii2', 'charset' => 'utf8', ], 'db2' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=localhost;dbname=hyii', //数据库hyii 'username' => 'root', 'password' => 'pwhyii', 'charset' => 'utf8', ],

The above configuration can complete the function of yii2 connecting to multiple databases.

Related tutorial recommendations:yii framework

The above is the detailed content of How to connect multiple databases in yii2. For more information, please follow other related articles on the PHP Chinese website!