网学网为广大网友收集整理了,Phpcms v9利用GET标签调用全站内容月排行,希望对大家有所帮助!
Phpcms v9实现全站内容月排行方法代码如下:
{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''])} title="{$v[''title'']}">{str_cut($v[''title''],56,''...'')}</a></li>
{/loop}
{/pc}