ftdxl
- ftdxl 回复了 wonderful60 的回复
可以类似这样处理。
main-local.php:'components' => [ 'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test1;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ], 'db2' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test2;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ],
Model:
$connection = \Yii::$app->get ( "db" ); 或 $connection = \Yii::$app->get ( "db2" );
@asialong 层主的办法也是可以的,不过层主的办法是设置一个全局的数据库连接,如果你只是想独立链接一个数据库的话,可以在model中重写getDb方法,如下
public static function getDb(){ $connection = new \yii\db\Connection([ 'dsn' => 'mysql:host=localhost;dbname=xxx, 'username' => 'root', 'password' => '', ]); $connection->open(); return $connection; }
- ftdxl 回复了 wonderful60 的回复
可以类似这样处理。
main-local.php:'components' => [ 'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test1;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ], 'db2' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test2;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ],
Model:
$connection = \Yii::$app->get ( "db" ); 或 $connection = \Yii::$app->get ( "db2" );
@asialong 在你需要独立使用数据库的模型里设置你要使用的数据库就可以了
- ftdxl 2015-10-17 已签到连续签到1天,获得了5个金钱
- ftdxl 回复了 wonderful60 的回复
可以类似这样处理。
main-local.php:'components' => [ 'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test1;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ], 'db2' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test2;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ],
Model:
$connection = \Yii::$app->get ( "db" ); 或 $connection = \Yii::$app->get ( "db2" );
@langya1260 谢谢,找到设置办法了
- ftdxl 回复了 wonderful60 的回复
可以类似这样处理。
main-local.php:'components' => [ 'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test1;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ], 'db2' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test2;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ],
Model:
$connection = \Yii::$app->get ( "db" ); 或 $connection = \Yii::$app->get ( "db2" );
$connection = \Yii::$app->get ( "db2" );这个应该在哪里使用?才可以让model自动识别到正确的数据库中的表。
- ftdxl 回复了 wonderful60 的回复
可以类似这样处理。
main-local.php:'components' => [ 'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test1;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ], 'db2' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=192.168.80.1;dbname=test2;port=3306', 'username' => 'root', 'password' => '123456', 'charset' => 'utf8', ],
Model:
$connection = \Yii::$app->get ( "db" ); 或 $connection = \Yii::$app->get ( "db2" );
可以给个详细一点的例子吗?
- ftdxl 发布了话题如何使用独立的数据库