功能：帝國cms站點(diǎn)統(tǒng)計(jì)、發(fā)布信息統(tǒng)計(jì)
簡介：帝國站點(diǎn)統(tǒng)計(jì)、發(fā)布信息統(tǒng)計(jì)
<div class="hd">站點(diǎn)統(tǒng)計(jì)</div>
<div class="bd">
<ul>
<li>新聞：[e:loop={'select count(*) as total from [!db.pre!]ecms_news ',1,24,0}]<?=$bqr[total]?>[/e:loop]條</a> ‖ 文章：[e:loop={'select count(*) as total from [!db.pre!]ecms_article ',1,24,0}]<?=$bqr[total]?>[/e:loop]篇</li>
<li>視頻：[e:loop={'select count(*) as total from [!db.pre!]ecms_movie ',1,24,0}]<?=$bqr[total]?>[/e:loop]個(gè) ‖ 資源：[e:loop={'select count(*) as total from [!db.pre!]ecms_download ',1,24,0}]<?=$bqr[total]?>[/e:loop]件</li>
<li>圖片：[e:loop={'select count(*) as total from [!db.pre!]ecms_photo ',1,24,0}]<?=$bqr[total]?>[/e:loop]張 ‖ 留言：[e:loop={'select count(*) as total from [!db.pre!]enewsgbook where checked=0',1,24,0}]<?=$bqr[total]?>[/e:loop]
條</li>
<li>評(píng)論：<?=$empire->gettotal("select count(*) as total from phome_enewspl_1");?>次‖
<?php
$members=$empire->gettotal("select count(*) as total from phome_enewsmember");
$newmember=$empire->fetch1("select userid,username from phome_enewsmember order by userid desc limit 1");
?>
會(huì)員：<?=$members?>人
<br>
</li>
</ul>
</div>
前臺(tái)調(diào)用發(fā)布信息統(tǒng)計(jì)
1、按字段="值"：<?=$empire->gettotal("select count(*) as total from phome_ecms_news where 字段='值'")?>
2、統(tǒng)計(jì)有多少附件：一共有 <?=$empire->gettotal("select count(*) as total from phome_enewsfile")?> 個(gè)附件
3、注冊會(huì)員ID：<?=$empire->gettotal("select count(*) as total from phome_ecms_news where userid=會(huì)員ID and ismember=1");?>
