ftdxl

ftdxl

这家伙有点懒,还没写个性签名!

  • 财富值50
  • 威望值0
  • 总积分90

个人信息

  • 回复了 的回复

    可以类似这样处理。
    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" );
    

    层主的办法也是可以的,不过层主的办法是设置一个全局的数据库连接,如果你只是想独立链接一个数据库的话,可以在model中重写getDb方法,如下
    public static function getDb()

    {
        $connection = new \yii\db\Connection([
            'dsn' => 'mysql:host=localhost;dbname=xxx,
             'username' => 'root',
             'password' => '',
        ]);
        $connection->open();
    
        return $connection;
    }
    
  • 回复了 的回复

    可以类似这样处理。
    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" );
    

    在你需要独立使用数据库的模型里设置你要使用的数据库就可以了

  • 发布了话题
    如何使用left join on and查询
  • 2015-10-17 已签到
    连续签到1天,获得了5个金钱
  • 回复了 的回复

    可以类似这样处理。
    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" );
    

    谢谢,找到设置办法了

  • 回复了 的回复

    可以类似这样处理。
    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自动识别到正确的数据库中的表。

  • 回复了 的回复

    可以类似这样处理。
    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" );
    

    可以给个详细一点的例子吗?

  • 发布了话题
    如何使用独立的数据库
职场新人 等级规则
90/100
资料完整度
10/100
用户活跃度
0/100

Ta的关注

2

Ta的粉丝

2

Ta的访客

2