久久久久亚洲AV成人网人人网站,精品久久久久久中文字幕,色综合久久久久久久久五月

yii2連接數據庫失敗

首先，先來看一下問題代碼：

1、控制器代碼如下：

????public?function?actionIndex() ????{ ????????$query?=?Country::find(); ? ????????$pagination?=?new?Pagination([ ????????????'defaultPageSize'?=&gt;?5, ????????????'totalCount'?=&gt;?$query-&gt;count() ????????]); ? ????????$countries?=?$query-&gt;orderBy('name') ????????????-&gt;offset($pagination-&gt;offset) ????????????-&gt;limit($pagination-&gt;limit) ????????????-&gt;all(); ? ????????return?$this-&gt;render('index',?[ ????????????'countries'?=&gt;?$countries, ????????????'pagination'?=&gt;?$pagination, ????????]); ????}

（推薦教程：yii框架）

2、數據庫配置文件db.php代碼如下：

<?php   return [     &#39;class&#39; =>?'YIIdbConnection', ????'dsn'?=&gt;?'mysql:host=localhost;dbname=yii2basic', ????'username'?=&gt;?'root', ????'password'?=&gt;?'', ????'charset'?=&gt;?'utf8', ? ????//?Schema?cache?options?(for?production?environment) ????//'enableSchemaCache'?=&gt;?true, ????//'schemaCacheDuration'?=&gt;?60, ????//'schemaCache'?=&gt;?'cache', ];

解決方法：

將pdo連接中的dsn的host由“localhost”改為“127.0.0.1”即可，打開文件DB.PHP，修改如下：

<?php   return [     &#39;class&#39; =>?'yiidbConnection', ????'dsn'?=&gt;?'mysql:host=127.0.0.1;dbname=yii2basic', ????'username'?=&gt;?'root', ????'password'?=&gt;?'', ????'charset'?=&gt;?'utf8', ? ????//?Schema?cache?options?(for?production?environment) ????//'enableSchemaCache'?=&gt;?true, ????//'schemaCacheDuration'?=&gt;?60, ????//'schemaCache'?=&gt;?'cache', ];

更多編程相關內容，請關注php中文網yii框架欄目！

文章版權歸作者所有，未經允許請勿轉載。

THE END