tp5多表联合查询及带分页显示

1.

以主表article查询，起别名a，，联合表art_category，起别名c，条件是id等同，用join

field查询需要的字段，

where条件查询

order排序差

分页3个一页

 // 多表联合查询
        $data = Db::name('article')
            ->alias('a')
            ->join('art_category c','a.category_id = c.category_id')
            ->field('a.art_id,a.imageurl,a.title,a.art_desc,a.category_pid,a.create_time,c.category_id,c.category_name')
            ->where('a.status',1)
            ->order('a.art_id','desc')
            ->paginate(3);



//多表联合查询-内连接

$articleList = Db::name("tp_art_rela_category")
            ->alias("arc")
            ->join('tp_article a','a.art_id = arc.art_id','inner')
            ->where('arc.category_id',$category_id)
            ->select();

2.

$page = $data->render();
        //输出数据
        $this -> assign('data',$data);
         //输出分页
        $this -> assign('page',$page);
        
        return $this->fetch();

3.数据输出

<div class="item-box-rt flex" style="">
	<div class="item-content">
		<a class="item-title" href="{:url('detail/detail',['type'=>99,'id'=>$vo['art_id']])}">{$vo.title}</a>
		<div class="sm-hidden md-hidden item-desc">
	<a href="{:url('detail/detail',['type'=>99,'id'=>$vo['art_id']])}">{$vo.art_desc}</a>
		</div>
		</div>
	<div class="item-info flex text-overflow">
									<p>
										<i class="fa {switch name='$vo.category_pid'}
											{case value='1'}fa-jsfiddle{/case}
											{case value='4'}fa-download{/case}
											{default /}fa-download
										{/switch}" 
										style="font-size: 1.2rem;color:#e2712c;" aria-hidden="true" 
										></i>{$vo.category_pid}/
										<span>{switch name='$vo.category_pid'}
											{case value='1'}vv{/case}
											{case value='4'}44{/case}
											{default /}其他
										{/switch}</span>
										 -id：{$vo.category_id}
									</p>
									<p><i class="fa fa-clock-o" aria-hidden="true"></i>
										{$vo.create_time|date="Y-m-d",###}
									</p>
									<p><i class="fa fa-heart-o" aria-hidden="true"></i>321</p>
									<p><i class="fa fa-download" aria-hidden="true"></i><a href="#">下载 </a></p>
								</div>
							</div>

4.html显示分页

<div class="pagination-box">{$page}</div>