abstrak:前端用的Bootstrap3分頁用的think\db\paginate方法,之所以可以Student::paginate這樣使用,是因?yàn)镾tudent::等價(jià)于Db::table('student')模型<?phpnamespace app\demo\model; use think\Model;class Student extends Model{}控制器<
前端用的Bootstrap3
分頁用的think\db\paginate方法,之所以可以Student::paginate這樣使用,是因?yàn)镾tudent::等價(jià)于Db::table('student')
模型
<?php
namespace app\demo\model;
use think\Model;
class Student extends Model
{
}
控制器
<?php
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;">學(xué)習(xí)PHP中文網(wǎng)的視頻教程中</h3>';
// 這里也可以用靜態(tài)代理的方法寫
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>
<head>
<meta charset="UTF-8">
<title>{$title|default='默認(rèn)標(biāo)題'}</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>
<div>
<div></div>
<div>
<h2>考試信息</h2>
<table class="table table-bordered table-default text-center">
<tr>
<td>序號(hào)</td>
<td>昵稱</td>
<td>郵箱</td>
<td>課程</td>
<td>分?jǐn)?shù)</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></div>
<div>
<!--開啟分頁條-->
{$data|raw}
</div>
</div>
</div>
</body>
</html>
Guru membetulkan:西門大官人Masa pembetulan:2019-03-03 13:16:48
Rumusan guru:思考一下,查詢分頁數(shù)據(jù)的時(shí)候,如何帶上查詢條件?