我正在尝试在 yii2 框架上使用多个数据库连接。在 config 文件夹内的 db.php 文件下,我有这段代码:
return [
'class' => 'yii\db\Connection',
'components' => [
'db1' => [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=localhost;dbname=new',
'username' => 'root',
'password' => 'password',
'charset' => 'utf8',
],
'db2' => [
'class' => 'yii\db\Connection',
'dsn' => 'mysql:host=localhost;dbname=old',
'username' => 'root',
'password' => 'password',
'charset' => 'utf8',
],
],
];
在模型文件夹下的 test.php 中,我有以下内容...
namespace app\models;
use Yii;
use yii\base\Model;
use yii\db\Query;
class GetAds extends Model
{
public function ads()
{
$test = Yii::$app->db1->createCommand((new \yii\db\Query)->select('*')->from('members'))->queryAll();
}
当我尝试访问时,收到此错误消息“获取未知属性:yii\web\Application::db1”
我该如何解决这个问题?我实际上已经遵循了这个指南多个数据库连接和 Yii 2.0 https://stackoverflow.com/questions/27254540/yii-2-0-multiple-database-connection
我哪里做错了?
最糟糕的是,我设置只使用一个数据库......在我的模型上,我使用这段代码......
namespace app\models;
use Yii;
use yii\base\Model;
use yii\db\ActiveRecord;
use yii\db\Query;
class GetAds extends ActiveRecord
{
public static function tableName()
{
return 'ads_page';
}
public static function ads()
{
$count=(new \yii\db\Query)->from('ads_page')->count('*');
}
}
我收到这个错误
Database Exception – yii\db\Exception
could not find driver
↵
Caused by: PDOException
could not find driver
为什么使用 yii2 这么难?我从这里关注了一切http://www.yiiframework.com/doc-2.0/guide-db-dao.html http://www.yiiframework.com/doc-2.0/guide-db-dao.html
请帮忙