PHP を使用して簡単なオンライン カスタマー サービス機能を開発する方法

      
  
  发送    

prepare("INSERT INTO messages (content) VALUES (?)"); $stmt->execute([$message]); // 返回最新的消息和聊天记录列表 $stmt = $pdo->prepare("SELECT * FROM messages ORDER BY id DESC LIMIT 1"); $stmt->execute(); $newMessage = $stmt->fetch(PDO::FETCH_ASSOC); $stmt = $pdo->prepare("SELECT * FROM messages ORDER BY id DESC LIMIT 10"); $stmt->execute(); $messages = $stmt->fetchAll(PDO::FETCH_ASSOC); $response = [ 'newMessage' => $newMessage, 'messages' => $messages ]; echo json_encode($response); exit; } // 获取聊天记录列表 $stmt = $pdo->prepare("SELECT * FROM messages ORDER BY id DESC LIMIT 10"); $stmt->execute(); $messages = $stmt->fetchAll(PDO::FETCH_ASSOC); echo json_encode($messages);

$(document).ready(function() { // 加载聊天记录 $.ajax({ url: 'backend.php', type: 'GET', dataType: 'json', success: function(response) { displayMessages(response); } }); // 发送消息 $('#send').click(function() { var message = $('#message').val(); $.ajax({ url: 'backend.php', type: 'POST', data: { message: message }, dataType: 'json', success: function(response) { displayMessages(response); } }); $('#message').val(''); }); }); // 显示聊天记录 function displayMessages(response) { var chatbox = $('#chatbox'); chatbox.empty(); $.each(response.messages, function(index, message) { var content = $('
').text(message.content); chatbox.append(content); }); if (response.newMessage) { var newMessage = $('
').text(response.newMessage.content); chatbox.append(newMessage); } chatbox.scrollTop(chatbox[0].scrollHeight); }