網(LieHuo.Net)教程 Dedecms V5.5后臺首頁信息統計代碼分享
| 以下為引用的內容： /*--------------------------------- 載入右邊內容 function _getRightSide() { } ---------------------------------*/ else if($dopost=='getRightSide') { $query = " Select count(*) as dd From `dede_member` "; $row1 = $dsql->GetOne($query); $query = " Select count(*) as dd From `dede_feedback` "; $row2 = $dsql->GetOne($query); $chArrNames = array(); $query = "Select id, typename From `dede_channeltype` "; $dsql->Execute('c', $query); while($row = $dsql->GetArray('c')) { $chArrNames[$row['id']] = $row['typename']; } $query = "Select count(channel) as dd, channel From `dede_arctiny` group by channel "; $allArc = 0; $chArr = array(); $dsql->Execute('a', $query); while($row = $dsql->GetArray('a')) { $allArc += $row['dd']; $row['typename'] = $chArrNames[$row['channel']]; $chArr[] = $row; } $query = "Select arc.id, arc.arcrank, arc.title, arc.channel, ch.editcon From `dede_archives` arc left join `dede_channeltype` ch on ch.id = arc.channel where arc.arcrank<>-2 order by arc.id desc limit 0, 6 "; $arcArr = array(); $dsql->Execute('m', $query); while($row = $dsql->GetArray('m')) { $arcArr[] = $row; } AjaxHead(); ?> <dl class='dbox'> <dt class='rside'> <div class='l'>信息統計</div> </dt> <dd class='intable'> <table width="100%" class="dboxtable"> <tr> <td width='50%' class='nline'> 會員數： </td> <td class='nline'> <?php echo $row1['dd']; ?> </td> </tr> <tr> <td class='nline'> 文檔數： </td> <td class='nline'> <?php echo $allArc; ?> </td> </tr> <?php foreach($chArr as $row) { ?> <tr> <td class='nline'> <?php echo $row['typename']; ?>： </td> <td class='nline'> <?php echo $row['dd']; ?> </td> </tr> <?php } ?> <tr> <td> 評論數： </td> <td> <?php echo $row2['dd']; ?> </td> </tr> </table> </dd> </dl> |
程序員人生，我編程，我富裕，記住wfuyu網，php教程，php學習，php手冊，CMS模版制作
聲明：本站大部分內容是作者原創，少部分收集于互聯網供大家一起學習，原版權很多不明，如有侵權請聯系本站，謝謝！
粵ICP備14040726號-1?? 2015-2020 程序員人生 版權所有
