相关文章的调用

PHPCMS v9在非show页面调用相关文章

{pc:content action="hits" catid="$catid" num="2" order="views DESC"}
    {loop $data $key $r}
    <div class="hotNews">
      <div class="space01"></div>
      <h2><a href="{$r[url]}" target="_blank" title="{$r[title]}"{title_style($r[style])}>{$r[title]}</a></h2>
      {pc:get sql="SELECT relation FROM v9_news_data a WHERE a.id=$r[id]" return="relation"}  - 获取当前文章的相关文章字段值
      {loop $relation $v}                                                                - 返回的是列表，虽然仅仅包含一条记录
      {php $ins = implode(',', explode("|", $v[relation]));}                  - 1|2|3|4变成1,2,3,4
      {pc:get sql="SELECT * FROM v9_news a WHERE a.id in ($ins)" return="more"}    - 获取相关文章
      {loop $more $v2}
      <h3><a href="{$v2[url]}" target="_blank" title="{$v2[title]}"{title_style($v2[style])}>{$v2[title]}</a></h3>
      {/loop}
      {/pc}
      {/loop}
    </div>
    {/loop}
   {/pc}    

 

 

在show页面

{pc:content action="relation" relation="$relation" id="$id" catid="$catid" num="5" keywords="$rs[keywords]"}

              {if $data}

                <div class="related">

                    <h5 class="blue">延伸阅读222：</h5>

                    <ul class="list blue lh24 f14">

                        {loop $data $r}

                            <li>·<a href="{$r[url]}" target="_blank">{$r[title]}</a><span>({date('Y-m-d',$r[inputtime])})</span></li>

                        {/loop}

                    </ul>

                </div>

              {/if}

          {/pc}

来自为知笔记(Wiz)Time=2013-02-26 17:00:43