PHPCMS V9 二次开发常用代码集

佚名 6年前 (2019-04-09) 随笔 1365人围观抢沙发百度已收录

0:调用最新文章，带所在版块

{pc:get sql="SELECT a.title, a.catid, b.catid, b.catname, a.url as turl ,b.url as curl,

a.id FROM `v9_news` a, `v9_category` b WHERE a.catid = b.catid ORDER BY `a`.`id` DESC "

num="15" cache="300"}
{loop $data $r}
<h6><font class="cate"><a href="http://archive.cnblogs.com/a/2482088/{$r[curl]}" target="_blank" rel="nofollow"> 
class="gray" href="http://archive.cnblogs.com/a/2482088/{$r[turl]}" target="_blank" rel="nofollow"> {/loop}
{/pc}

1.截取调用标题长度

{str_cut($v[title],36,'')}

{str_cut($v['title'],34)} 超出用 ... 代替

{str_cut($v['title'],34, '???')}超出用 ？？？代替

{str_cut($v['title'],34,'')}超出不用任何字符代替

2.格式化时间

调用格式化时间 2011-05-06 11:22:33

{date('Y-m-d H:i:s',$r[inputtime])}

<span class="rt">{date('m-d',$v['inputtime'])}</span>

3.多栏目调用&多推荐位调用

调用需求：文章范围为59 60 61三个栏目，并且推送到了27 和28两个推荐位；
从第三条开始，连续调用7篇文章。

{pc:get sql="SELECT * FROM v9_news WHERE id IN (SELECT id FROM v9_position_data WHERE posid

in(27,28) and catid in(59,60,61)) order by listorder DESC" cache="3600" start="3" num="7"

return="data" }
{loop $data $n $r}
<li>·<a target="_blank" href="http://archive.cnblogs.com/a/2482088/{$r[url]}" target="_blank" rel="nofollow"> 
($r[title],22,'')}</a></li>
{/loop}
{/pc}

4.显示栏目名称、链接

{$CATEGORYS[$r[catid]][url]}

SRE实战互联网时代守护先锋，助力企业售后服务体系运筹帷幄！一键直达领取阿里云限量特价优惠。

{$CATEGORYS[$r[catid]][catname]}

{$CATEGORY[$catid][parentid]}

父栏目名称：{$CATEGORYS[$CAT[parentid]][catname]}

6.外部数据源调用

dedecmsdb 在后台数据源处添加
{pc:get sql="SELECT * FROM cq_member where mtype='企业' " cache="3600" dbsource="dedecmsdb"

num="7" return="data"}
{loop $data $r}
<a href="http://archive.cnblogs.com/member/index.php?uid={$r[userid]}" target="_blank" rel="nofollow"> 
($r[uname],28,'')}</a>
{/loop}
{/pc}