连接多个数据库（基础版）

参考链接

1,创建一个新的 remote_db  文件
<?php

return [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=rds0cuyc388353x5pld0.mysql.rds.aliyuncs.com;dbname=db_wdm',
    'username' => 'db_wdm',
    'password' => 'Q3Bc8tyFP9IG3Jq_0swE8IzDDSicB4TA',
    'charset' => 'utf8',
    // 'tablePrefix' => 'o2o_',
    // 'tablePrefix' => 'o2o_',//自己设置表前缀
    // Schema cache options (for production environment)
    //'enableSchemaCache' => true,
    //'schemaCacheDuration' => 60,
    //'schemaCache' => 'cache',
];

2,修改配置文件
'components' => [
     
    'db' => require(__DIR__ . '/db.php'),
    'remote_db' => require(__DIR__ . '/remote_db.php'),
     
],

在控制器中使用

$sql = "SELECT * FROM ship_station where station_id = 49";
    $result = \Yii::$app->remote_db->createCommand($sql)->queryAll();

转载于:https://www.cnblogs.com/AbbyXie/p/11526135.html