setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$db->exec("CREATE TABLE IF NOT EXISTS messages (
id INTEGER PRIMARY KEY AUTOINCREMENT,
username TEXT,
message TEXT,
created_at INTEGER
)");
// ---- API ----
if(isset($_GET['api'])){
header('Content-Type: application/json');
if($_GET['api']==='send'){
$data=json_decode(file_get_contents('php://input'),true);
$stmt=$db->prepare('INSERT INTO messages(username,message,created_at) VALUES(?,?,?)');
$stmt->execute([$data['username'],$data['message'],time()]);
echo json_encode(['status'=>'ok']);
exit;
}
if($_GET['api']==='list'){
$since=intval($_GET['since']??0);
$stmt=$db->prepare('SELECT * FROM messages WHERE created_at>? ORDER BY created_at ASC');
$stmt->execute([$since]);
echo json_encode($stmt->fetchAll(PDO::FETCH_ASSOC));
exit;
}
}
?>
Chat
Assistant
Hors ligne
✖
