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> 

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/e043461aa9ce61c2d9d632c4fef82b2a.html