Amanda
那可以这样:
return [ // ... 'components' => [ // ... 'db' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=localhost;dbname=mydatabase', 'username' => 'root', 'password' => '', 'charset' => 'utf8', ], //可以配置多个 'db2' => [ 'class' => 'yii\db\Connection', 'dsn' => 'mysql:host=localhost;dbname=mydatabase2', 'username' => 'root', 'password' => '', 'charset' => 'utf8', ], ], // ... ];
然后
$connection = \Yii::$app->db; $connection2 = \Yii::$app->db2;
然后
//一旦有了连接实例就可以通过yii\db\Command执行 SQL 查询。你拿你需要的连接实例去查就好了 $command = $connection->createCommand('SELECT count(*) FROM post'); $post = $command->queryOne();
谢谢,已经会了
- Amanda 提出了问题Yii2如何返回结果记录数
- Amanda 发布了话题YII2连接数据库,出现了PDO问题
- Amanda 2016-03-06 已签到连续签到1天,获得了5个金钱