網(wǎng)(LieHuo.Net)教程 Dedecms 5.5站點信息調(diào)用標簽代碼,有需要的拿去吧。
{dede:sql sql="SELECT count( * ) AS c FROM dede_archives WHERE pubdate > UNIX_TIMESTAMP( CURDATE( ) ) "} <li class="count">今日更新:<span>[field:c/]</span> 篇</li> {/dede:sql} {dede:sql sql="Select count(ID) as c From dede_archives WHERE FROM_UNIXTIME(pubdate,'%m')=month(curdate())"} <li class="count">當月更新:<span>[field:c/]</span> 篇</li> {/dede:sql} {dede:sql sql="select count(*) as c from dede_archives} <li class="count">共有文章:<span>[field:c/]</span> 篇</li> {/dede:sql} {dede:sql sql="select sum(click) as c from dede_archives"} <li class="count">總共閱讀:<span>[field:c/]</span> 人次</li> {/dede:sql} {dede:sql sql="select count(mid) as c from dede_member "} <li class="count">共有會員:<span>[field:c/]</span> 名</li> {/dede:sql} |
還可以指定欄目ID,例如:
{dede:sql sql="select count(*) as c from dede_archives where channel in(1,2,3,5,6,9)"} <li class="count">共有文章:<span>[field:c/]</span> 篇</li> {/dede:sql} |