采用原始方法调取文章标题及链接的实现方法

<php>

use think\Db;

</php>

<php>

$list=Db::query('select A.id,A.post_title,B.category_id,C.name from cmf_portal_post A

LEFT JOIN cmf_portal_category_post B ON A.id=B.post_id

LEFT JOIN cmf_portal_category C ON B.category_id=C.id'); 

$count=count($list);

for ($x=0; $x<=$count-1; $x++) {

$title[$x]=$list[$x]['post_title'] ;

 $url[$x]=$list[$x]['name'].'/'.$list[$x]['id'].'.html' ;   

</php>

<h5 class="title"><a href="{$url[$x]}"> {$title[$x]}</a></h5>  

<php>

} 

</php>