PDO::ERRMODE_EXCEPTION, PDO::ATTR_DEFAULT_FETCH_MODE => PDO::FETCH_ASSOC, ]; try { $pdo = new PDO($dsn, $user, $pass, $options); } catch(PDOException $e) { exit('Database connection failed: ' . $e->getMessage()); } // If the request is for loading messages (AJAX GET request) if (isset($_GET['action']) && $_GET['action'] === 'load') { $stmt = $pdo->query("SELECT username, content, timestamp FROM messages ORDER BY id ASC"); $messages = $stmt->fetchAll(); foreach ($messages as $msg) { echo "

" . htmlspecialchars($msg['username'], ENT_QUOTES, 'UTF-8') . " [" . $msg['timestamp'] . "]: " . htmlspecialchars($msg['content'], ENT_QUOTES, 'UTF-8') . "

"; } exit; } // If a new message is posted via a POST request if (isset($_POST['username']) && isset($_POST['message'])) { $username = trim($_POST['username']); $message = trim($_POST['message']); if (!empty($username) && !empty($message)) { $stmt = $pdo->prepare("INSERT INTO messages (username, content) VALUES (:username, :content)"); $stmt->execute(['username' => $username, 'content' => $message]); } exit; } ?> Gamer Hub Chat

Multi-User Messaging App