• 网站认证
  • 教程:6,665|
  • 话题:6319|
  • 评论:46|
  • 会员:194|
  • 注册
  • 查看作者
  • 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> 

  • 0
  • 0
  • 0
  • 49
  • 请登录之后再进行评论

    登录
  • 做任务
  • 实时动态
  • 偏好设置
  • 单栏布局 侧栏位置: