在使用織夢(mèng)cms建站的時(shí)候通常會(huì)需要統(tǒng)計(jì)一些常見的網(wǎng)站數(shù)據(jù) 那么下面織夢(mèng)者就為您提供一些織夢(mèng)cms調(diào)用會(huì)員數(shù),文章數(shù),評(píng)論數(shù),今天新增文章數(shù)的代碼供您參考

{dede:sql sql=”select count(*) as c from mei_member “}共有會(huì)員[field:c /]名{/dede:sql}，{dede:sql sql=”select count(ID) as c from mei_archives where channel=1″}共有文章[field:c /]篇{/dede:sql}，{dede:sql sql=”select sum(click) as c from mei_archives”}文章閱讀[field:c /]人次{/dede:sql}，{dede:sql sql=”select count(ID) as c from mei_feedback”}共有評(píng)論[field:c /]條{/dede:sql}，{dede:sql sql=”SELECT count( ID ) AS c FROM mei_archives WHERE pubdate > UNIX_TIMESTAMP( CURDATE( ) ) “}今日更新[field:c /]篇{/dede:sql}