配置
return [
'components' => [
'db' => [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=localhost;dbname=dbname',
'username' => 'username',
'password' => 'password',
],
'db2' => [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=localhost;dbname=db2name',
'username' => 'username',
'password' => 'password',
],
],
];
模型中重写ActiveRecord中的getDb()
public static function getDb() {
return Yii::$app->db2;
}
使用
$sql = (new Query())->select($fields)->from(self::tableName())->filterWhere($where2)->orderBy($order)->limit($limit)->createCommand()->getRawSql();
$res = Yii::$app->db2->createCommand($sql)->queryAll();