织梦DedeCMS网站信息(会员数,文章数等)调用:
1、会员数
{dede:sql sql="select count(mid) as c from dede_member"}共有会员:[field:c /] 名{/dede:sql}
2、本月文章更新数
{dede:sql sql="SELECT count(ID) AS c FROM dede_archives WHERE FROM_UNIXTIME(pubdate, '%m' ) = month(curdate()) "} 本月更新:[field:c /] 篇{/dede:sql}
3、文章篇数
{dede:sql sql="select count(*) as c from dede_archives where channel=1"}共有文章:[field:c/] 篇{/dede:sql}