/** * 获取全部群信息 * @UserFunction(method = GET) */ function get_all_group() { $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD); $group_list = $db->fetchAll('SELECT * FROM `group`'); return $group_list; }
/** * 获取好友列表 * @UserFunction(method = GET|POST) * @CheckLogin */ function get_friend() { $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD); $friends = $db->fetchAll('SELECT A.`id`,`email`,`username`,`portrait`,`status` FROM `friend` INNER JOIN `user` AS A ON `friend_id`=A.`id` WHERE `user_id`=?;', getCurrentUserId()); return $friends; }
/** * 获取全部个人资料 * @UserFunction(method = GET) * @CheckLogin */ function friends() { $db = new DataBase(DB_DNS, DB_USER, DB_PASSWORD); $result = $db->fetchAll('SELECT `id`, `username`, `portrait` FROM `user`'); return $result; }