$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$g_member = array();
$g_member['uid'] = $row['id'];
$g_member['nickname'] = $row['nickname'];
$g_member['birthday'] = $row['birthday'];
$g_member['gender'] = $row['gender'];
$g_member['status'] = $row['status'];
$g_member['icon'] = get_avatar_url($row['id']);
$g_member_list[] = $g_member;
}
//不管执行成功还是失败最后都要在关闭自动提交
$db->setAttribute(PDO::ATTR_AUTOCOMMIT, 1);
log_info("make group succ. uid:{$uid}");
$group_data = array();
$group_data['gid'] = $gid;
$group_data['nickname'] = $group_name;
$group_data['owner'] = $owner_id;
$group_data['status'] = 0;
$group_data['icon'] = get_group_avatar_url($gid);
$group_data['members'] = $g_member_list;
$res = show_info('succ', '注册成功!');
$res['group'] = $group_data;
echo json_encode($res);
return 0;
} else {
log_info("register fail, parameters error");
$res['status'] = 'fail';
$res['des'] = 'parameters error';
echo json_encode($res);
}
if (strlen($group_ids) > 0) {
$group_ids .= ",";
}
$group_ids .= $row['gid'];
}
if (strlen($group_ids) > 0) {
// get group info
$sql = "SELECT id, group_name, owner_id, status FROM sc_groups WHERE id in ({$group_ids}) ";
$stmt = $db->prepare($sql);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$group_info = array();
$group_info['gid'] = $row['id'];
$group_info['nickname'] = $row['group_name'];
$group_info['owner'] = $row['owner_id'];
$group_info['icon'] = get_group_avatar_url($row['id']);
$group_info['status'] = $row['status'];
$group_info['members'] = array();
$groups[] = $group_info;
}
// get member info joined groups
$group_members = array();
$sql = "SELECT gid, group_concat(member_id) as member_ids FROM sc_group_members WHERE gid IN ({$group_ids}) GROUP BY gid ";
$stmt = $db->prepare($sql);
$stmt->execute();
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$group_members[$row['gid']] = $row['member_ids'];
}
// 查询成员信息
foreach ($group_members as $gid => $member_ids) {
$g_member_list = array();
