沿用教程（2）的代码

第一步、在本地mysql数据库中新建数据库zhyoulun

第二步、在数据库中新建表并插入若干条数据

CREATE TABLE `country` (

  `code` CHAR(2) NOT NULL PRIMARY KEY,

  `name` CHAR(52) NOT NULL,

  `population` INT(11) NOT NULL DEFAULT '0'

) ENGINE=InnoDB DEFAULT CHARSET=utf8;

INSERT INTO `country` VALUES ('AU','Australia',18886000);

INSERT INTO `country` VALUES ('BR','Brazil',170115000);

INSERT INTO `country` VALUES ('CA','Canada',1147000);

INSERT INTO `country` VALUES ('CN','China',1277558000);

INSERT INTO `country` VALUES ('DE','Germany',82164700);

INSERT INTO `country` VALUES ('FR','France',59225700);

INSERT INTO `country` VALUES ('GB','United Kingdom',59623400);

INSERT INTO `country` VALUES ('IN','India',1013662000);

INSERT INTO `country` VALUES ('RU','Russia',146934000);

INSERT INTO `country` VALUES ('US','United States',278357000);

第三步、给yii进行数据库连接配置，配置文件是config/db.php

<?php

//配置的数据库连接能够在应用中通过 Yii::$app->db 訪问

return [

    'class' => 'yii\db\Connection',

    'dsn' => 'mysql:host=localhost;dbname=zhyoulun',

    'username' => 'root',

    'password' => '20092565',

    'charset' => 'utf8',

];

第四步、在controllers/ZhyoulunController.php加入代码

	public function actionCountry()

	{

		return $this->render('country');

	}

第五步、在models目录中新建Country.php

<?

php

namespace app\models;

use yii\db\ActiveRecord;

//你不用在里面写不论什么代码。

仅仅须要像如今这样。Yii 就能依据类名去推測相应的数据表名。

class Country extends ActiveRecord

{

}

第六步、在views/zhyoulun/目录中新建country.php

<?php

use app\models\Country;

// 获取 country 表的全部行并以 name 排序

$countries = Country::find()->orderBy('name')->all();

echo '<table border="1">';

for($i=0;$i<count($countries);$i++)

{

	echo '<tr>';

	echo '<td>'.$countries[$i]['code'].'</td>';

	echo '<td>'.$countries[$i]['name'].'</td>';

	echo '<td>'.$countries[$i]['population'].'</td>';

	echo '</tr>';

}

echo '</table>';

第七步、訪问网址http://localhost/basic/web/index.php?

r=zhyoulun/country

watermark/2/text/aHR0cDovL2Jsb2cuY3Nkbi5uZXQvemh5b3VsdW4=/font/5a6L5L2T/fontsize/400/fill/I0JBQkFCMA==/dissolve/70/gravity/SouthEast" alt="">

參考：http://www.yiichina.com/guide/2/start-databases

转载请注明出处：http://blog.csdn.net/zhyoulun/article/details/40454583