帝国CMS统计文章数量、会员数量等相关统计sql代码

本文主要展示帝国CMS统计今日文章数量,昨日文章数量,总共文章数量,文章+评论数量,会员数量,最新会员的代码
<?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”);
$tzcount=$empire->gettotal(“select count(*) as total from phome_ecms_news”);
$plnum=$empire->gettotal(“select count(*) as total from {$dbtbpre}enewspl”);
$pltzcont=$tzcount+$plnum;
?>

今日: <em class=”numeric”>[totaldata]’news’,2,1[/totaldata]</em> ,
昨日: <em class=”numeric”>[ztotal]栏目ID[/ztotal]</em> ,
主题: <em class=”numeric”><?=$tzcount?></em> ,
帖子: <em class=”numeric”><?=$pltzcont?></em> ,
用户: <em class=”numeric”><?=$members?></em>,
最新会员: <em class=”numeric”><?=$newmember[username]?></em>