$last ORDER BY id ASC");
$msgs = [];
while ($m = mysqli_fetch_assoc($res)) $msgs[] = $m;
if ($msgs) $_SESSION['last_id'] = $msgs[count($msgs)-1]['id'];
echo json_encode(['msgs' => $msgs]);
exit;
}
// 历史消息
function get_history($conn, $uid) {
$res = mysqli_query($conn, "SELECT * FROM messages WHERE uid='$uid' ORDER BY id ASC");
$arr = [];
while ($m = mysqli_fetch_assoc($res)) $arr[] = $m;
return $arr;
}
$my_msgs = get_history($conn, $uid);
$chat_uid = $_GET['chat'] ?? '';
$chat_msgs = $chat_uid ? get_history($conn, $chat_uid) : [];
// 用户列表
$users = [];
$res = mysqli_query($conn, "SELECT * FROM users ORDER BY created_at DESC");
while ($u = mysqli_fetch_assoc($res)) $users[] = $u;
?>
客服系统