exec("CREATE TABLE IF NOT EXISTS messages (
id INT AUTO_INCREMENT PRIMARY KEY,
message TEXT NOT NULL,
created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);");
// Handle new message submission (Post/Redirect/Get pattern)
if ($_SERVER['REQUEST_METHOD'] === 'POST' && !empty(trim($_POST['message']))) {
$stmt = $pdo->prepare("INSERT INTO messages (message) VALUES (?)");
$stmt->execute([$_POST['message']]);
// Prevent form resubmission on refresh
header("Location: index.php");
exit;
}
// Fetch all messages for display
$messages = $pdo->query("SELECT * FROM messages ORDER BY created_at ASC")->fetchAll(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
// For a real app, you'd want to log this and show a user-friendly error page.
error_log("Database error: " . $e->getMessage());
// Keep the page from crashing, show an error inline.
$dbError = "Could not connect to the database or run the query. Please check server logs.";
}
// --- Dynamic Meta Tags & SEO --- (Platform-managed)
$project_name = htmlspecialchars($_SERVER['PROJECT_NAME'] ?? 'Telegram App');
$project_description = htmlspecialchars($_SERVER['PROJECT_DESCRIPTION'] ?? 'A simple messaging app.');
$project_image_url = htmlspecialchars($_SERVER['PROJECT_IMAGE_URL'] ?? '');
?>
<?= $project_name ?>