Yii2 调用数据简单显示

数据模型层
models/ZsDynasty.php

<?php
namespace appmodels;


use yiidbActiveRecord;


class ZsDynasty extends ActiveRecord
{
}

ZsDynasty 对应数据库表 zs_dynasty

控制器
Controller/TestController.php

<?php

namespace appcontrollers;

use yiiwebController;
use yiidataPagination;//分页
use yiidataActiveDataProvider;//活动记录
use appmodelssDynasty;//自定义数据模型

class TestController extends Controller
{
    public function actionIndex()
    {
        $query = ZsDynasty::find();


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


        $dynastys = $query->orderBy("dyn_id")
            ->offset($pagination->offset)
            ->limit($pagination->limit)
            ->all();


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

对应网址 index.php?r=test/index

视图
views estindex.php

<?php
use yiihelpersHtml;
use yiiwidgetsLinkPager;

$this->title = "朝代";
$this->params["breadcrumbs"][] = $this->title;
?>
<h1>朝代</h1>
<ul>
<?php foreach ($dynastys as $dynasty): ?>
    <li>
        <?= Html::encode("{$dynasty->dyn_name} ({$dynasty->dyn_id})") ?>:
    </li>
<?php endforeach; ?>
</ul>

<?= LinkPager::widget(["pagination" => $pagination]) ?>