在项目common/config/main-local.php添加:
<?php
return [
'components' => [
'db' => [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=127.0.0.1;port=3306;dbname=testdb',
'username' => 'root',
'password' => '123456',
'charset' => 'utf8',
],
'mssqldb' => [
'class' => 'yii\db\Connection',
'dsn' => 'dblib:host=127.0.0.1:9433;dbname=TESTDB',
'username' => 'root',
'password' => '123456',
'charset' => 'gbk',
'tablePrefix' => '',
'enableSchemaCache' => YII_ENV_PROD
],
'mongodb' => [
'class' => '\yii\mongodb\Connection',
'dsn' => 'mongodb://127.0.0.1:27017/commondb',
],
'redis' => [
'class' => 'yii\redis\Connection',
'hostname' => '127.0.0.1',
'port' => 6379,
'database' => 0,
],
],
];
调用方式如下:
\Yii::$app->db
\Yii::$app->mssqldb
\Yii::$app->redis
\Yii::$app->mongodb