站长网经验 Phpcms v9运用GET标签调用全站内容月排行

Phpcms v9运用GET标签调用全站内容月排行

作者: dawei 发布: 2021年12月18日

{pc:get sql=SELECT h.`monthviews`,n.`title`,n.`url`,n.`style` FROM `phpcms_hits` AS h,`phpcms_news` AS n WHERE substring_index(h.`hitsid`, -, -1)=n.`id` AND n.`status`=99 ORDER BY h.`monthviews` DESC num=20 cache=3600} {loop $data $v} /SP

{pc:get sql="SELECT h.`monthviews`,n.`title`,n.`url`,n.`style` FROM `phpcms_hits` AS h,`phpcms_news` AS n WHERE substring_index(h.`hitsid`, '-', -1)=n.`id` AND n.`status`=99 ORDER BY h.`monthviews` DESC" num="20" cache="3600"}
{loop $data $v}
<li><span>{number_format($v['monthviews'])}</span><a href="{$v['url']}"{title_style($v['style'])} class="title" title="{$v['title']}">{str_cut($v['title'],56,'…')}</a></li>
{/loop}
{/pc}

本文来自网络，不代表站长网立场，转载请注明出处：https://www.zwzz.com.cn/html/jianzhan/jy/2021/1218/38409.html