THINKPHP5.1模板循环输出数据库中的内容到表格并分页以及判断显示

最新推荐文章于 2021-03-21 20:42:00 发布

盼盼大魔王

最新推荐文章于 2021-03-21 20:42:00 发布

阅读量2.1k

点赞数 2

分类专栏： ThinkPHP5.1

本文链接：https://blog.csdn.net/weixin_38468437/article/details/82263476

版权

ThinkPHP5.1 专栏收录该内容

34 篇文章 2 订阅

订阅专栏

看THINKPHP5.1视频教程时的笔记

前端用的Bootstrap3

分页用的think\db\paginate方法，之所以可以Student::paginate这样使用，是因为Student::等价于Db::table('student')

官方文档在此

模型

<?php
/**
 * Created by PhpStorm.
 * User: 10475
 * Date: 2018/8/30
 * Time: 21:26
 */
namespace app\demo\model;

use think\Model;

class Student extends Model
{

}

控制器

<?php
/**
 * Created by PhpStorm.
 * User: 10475
 * Date: 2018/8/30
 * Time: 21:57
 */

namespace app\demo\controller;
use think\Controller;
use think\Facade\View;
use app\demo\model\Student;

class Demo7 extends Controller
{
    public function test1()
    {
        $content = '<h3 style="color: red;">学习PHP中文网的视频教程中</h3>';
//        这里也可以用静态代理的方法写
        return View::display($content);
    }
    public function test3()
    {
        $data = Student::all();
        $this->view->assign('data',$data);
        return $this->view->fetch();
    }
    public function test4()
    {
        // 使用分页方法
        $data = Student::paginate(5);
        $this->view->assign('data',$data);
        return $this->view->fetch();
    }

}

视图：加入了判断和循环

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>{$title|default='默认标题'}</title>
    <link rel="stylesheet" href="/static/css/bootstrap.min.css">
    <script src="https://cdn.bootcss.com/jquery/3.2.1/jquery.slim.min.js" integrity="sha384-KJ3o2DKtIkvYIK3UENzmM7KCkRr/rE9/Qpg6aAZGJwFDMVNA/GpGFF93hXpG5KkN" crossorigin="anonymous"></script>
    <script src="/static/js/bootstrap.min.js"></script>
</head>
<body>
<div class="container">
    <div class="row">
        <div class="col-md-2"></div>
        <div class="col-md-8">
            <h2 class="text-center">考试信息</h2>
            <table class="table table-bordered table-default text-center">
                <tr class="bg-primary">
                    <td>序号</td>
                    <td>昵称</td>
                    <td>邮箱</td>
                    <td>课程</td>
                    <td>分数</td>
                </tr>
                {volist name='data' id='list'}
                <tr>
                    <td>{$list.id}</td>
                    <td>{$list.name}</td>
                    <td>{$list.email}</td>
                    <td>{$list.course}</td>
                    <td>
                        {if $list.grade>=60}
                        <span style="color: green;">及格</span>
                        {else /}
                        <span style="color: red;">不及格</span>
                        {/if}
                    </td>
                </tr>
                {/volist}
            </table>
        </div>
        <div class="col-md-2"></div>
        <div class="text-center">
            <!--开启分页条-->
            {$data|raw}
        </div>
    </div>
</div>
</body>
</html>