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}
本文创建于:2022年02月25日,最后更新于:2022年02月25日,已超过 1115 天没更新!内容可能已失效,请自行测试,失效请评论区反馈,谢谢啦~