Yii2 HOW-TO（4）：PDO连接数据库错误

最新推荐文章于 2021-02-05 02:09:33 发布

weixin_34292959

最新推荐文章于 2021-02-05 02:09:33 发布

阅读量299

点赞数

文章标签：数据库 php

本文链接：https://blog.csdn.net/weixin_34292959/article/details/85023069

版权

问题代码

1，控制器代码如下：

    public function actionIndex()
    {
        $query = Country::find();

        $pagination = new Pagination([
            'defaultPageSize' => 5,
            'totalCount' => $query->count()
        ]);

        $countries = $query->orderBy('name')
            ->offset($pagination->offset)
            ->limit($pagination->limit)
            ->all();

        return $this->render('index', [
            'countries' => $countries,
            'pagination' => $pagination,
        ]);
    }

2，数据库配置文件db.php代码如下：

<?php

return [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=localhost;dbname=yii2basic',
    'username' => 'root',
    'password' => '',
    'charset' => 'utf8',

    // Schema cache options (for production environment)
    //'enableSchemaCache' => true,
    //'schemaCacheDuration' => 60,
    //'schemaCache' => 'cache',
];

3，问题截图：

Yii2 HOW-TO（4）：PDO连接数据库错误

解决办法

将PDO连接中的dsn的host由“localhost”改为“127.0.0.1”即可，打开文件DB.PHP，修改如下：

<?php

return [
    'class' => 'yii\db\Connection',
    'dsn' => 'mysql:host=127.0.0.1;dbname=yii2basic',
    'username' => 'root',
    'password' => '',
    'charset' => 'utf8',

    // Schema cache options (for production environment)
    //'enableSchemaCache' => true,
    //'schemaCacheDuration' => 60,
    //'schemaCache' => 'cache',
];