帝国cms站点统计、发布信息统计

内容摘要

帝国cms站点统计、发布信息统计

文章正文

功能：帝国cms站点统计、发布信息统计简介：帝国站点统计、发布信息统计

 <div class="hd">站点统计</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]个 ‖ 资源：[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>评论：<?=$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");?>会员：<?=$members?>人<br></li></ul></div>

前台调用发布信息统计1、按字段="值"：<?=$empire->gettotal("select count(*) as total from phome_ecms_news where 字段='值'")?>2、统计有多少附件：一共有 <?=$empire->gettotal("select count(*) as total from phome_enewsfile")?> 个附件3、注册会员ID：<?=$empire->gettotal("select count(*) as total from phome_ecms_news where userid=会员ID and ismember=1");?> 

代码注释