zblog读者墙数据调用php代码
function readers(){
global $zbp;
$limit = 100;
$list = array();
$sql = $zbp->db->sql->get()->select($zbp->table['Comment'])->column('comm_Name,comm_Email,comm_AuthorID,count(*)')->groupby('comm_Name,comm_Email,comm_AuthorID')->orderBy(array('count(*)' => 'DESC'))->limit($limit)->sql;
foreach($zbp->db->Query($sql) as $value){
$value = array_values($value);
$list[] = array(
'member' => $zbp->GetMemberByID($value[2]),
'name' => $value[0],
'email' => $value[1],
'count' => $value[3],
);
}
return $list;
}模板里调用方法：
{foreach readers() as $value}
用户：{$value['member']->StaticName}
名称：{$value['name']}
邮箱：{$value['email']}
评论数量：{$value['count']}
{/foreach}
上一篇
信息由用户投稿以及用户自行发布，真实性、合法性由发布人负责，涉及到汇款等个人财产或隐私内容时请仔细甄别，注意防骗！如有侵权，请联系：wwwlaoyuwang#126.com(#=@)！我们会第一时间核实处理！