$comment_array['total'] = $rows_num;
$offset = $page_num * $per_page;
//计算偏移量
$limit = ' LIMIT ' . $offset . ', ' . $per_page;
$sql .= $limit;
$this->setXmlNode('comments', 'comment');
$qid = $this->db->query($sql);
$split = '';
$status = $this->mStatus->show($id);
while ($rows = $this->db->fetch_array($qid)) {
$member_ids .= $split . $rows['member_id'];
$comment_array[$rows['id']] = $rows;
$comment_array[$rows['id']]['status'] = $status[0];
$split = ',';
}
$members = array();
$members = $this->mUser->getUserById($member_ids);
foreach ($comment_array as $k => $comment) {
foreach ($members as $id => $user) {
if ($comment['member_id'] == $user['id']) {
$comment['user'] = $user;
}
}
$this->addItem($comment);
}
$this->output();
}
}
$out = new comments();
$out->commentList();