1、父类列表页分页
//分页参考:https://www.kancloud.cn/manual/thinkphp5/154294
//子查询参考:https://www.kancloud.cn/manual/thinkphp5/135185
// tp5 分页样式:https://www.jianshu.com/p/a925af4fa2de
// 4、使用闭包构造子查询
$list = Db::table('tb_news')
->where('cat_id','IN',function($query){
$query->table('tb_category')->where('parent_id',16)->field('cat_id');
})
->paginate(2);
$this->assign('list', $list);
2、子类列表页分页
//分页参考:https://www.kancloud.cn/manual/thinkphp5/154294
//子查询参考:https://www.kancloud.cn/manual/thinkphp5/135185
// tp5 分页样式:https://www.jianshu.com/p/a925af4fa2de
// 4、使用闭包构造子查询
// 分页自定义参数参考:https://blog.csdn.net/qq_40245128/article/details/85206598
$where['query']['cat_id'] = $cat_id;
$list = Db::table('tb_news')
->where(['cat_id' => $cat_id])
->paginate(2,'',$where);
$this->assign('list', $list);
3、模板输出
<?php
for($i=0;$i<count($list);$i++) {
?>
<dl class="news clearfix">
<dt><a href="/public/index.php/home/Case/view?news_id=<?php echo $list[$i]['news_id'];?>"><img src="<?php echo $list[$i]['title_pic'];?>" alt=""/></a></dt>
<dd>
<div class="title">
<p><a href="/public/index.php/home/Case/view?news_id=<?php echo $list[$i]['news_id'];?>"><?php echo $list[$i]["title"];?></a></p>
<span><?php echo date("Y-m-d H:i:s",$list[$i]["create_time"]);?></span>
</div>
<div class="des"><?php echo $list[$i]["description"];?></div>
<div class="more"><a href="case_info.html">查看详情>></a></div>
</dd>
</dl>
<?php
}
?>
<div class="space_hx"> </div>
<div class="pages">
<?php echo $list->render();?>
</div>
4、分页样式
ul.pagination {display: inline-block;padding: 0;margin: 0;}
.pagination a{text-decoration: none;margin-right: 0px!important; }
ul.pagination li {display: inline;}
.disabled ,.pagination .active, .pagination li a {color: black; float: left;padding: 8px 16px;text-decoration: none;transition: background-color .3s;border: 1px solid #ddd; margin: 0 4px;}
.pagination .active{background-color: #4CAF50;color: white;border: 1px solid #4CAF50;}
.disabled{background-color: rgba(236, 236, 236, 0.78);}
ul.pagination a.active {background-color: #4CAF50;color: white;border: 1px solid #4CAF50;}
ul.pagination li a:hover:not(.active) {background-color: #ddd;}
新蔷程序员特训营,带领初学者快速开发商业项目:https://paishenwx.taobao.com/