prepare('INSERT INTO statuses(title, contents) VALUES (?, ?)')
->execute([$title, $contents]);
$id = $db->lastInsertId();
header("Location: /status/?id=$id");
exit;
}
if (isset($_GET['id']) && !empty(trim($_GET['id']))) {
$stmt = $db->prepare('SELECT * FROM statuses WHERE id = ?');
$stmt->execute([$_GET['id']]);
$status = $stmt->fetch(PDO::FETCH_ASSOC) ?: null;
} else {
$stmt = $db->query('SELECT id, title, posted_at FROM statuses ORDER BY posted_at DESC');
$statuses = $stmt->fetchAll(PDO::FETCH_ASSOC);
}
?>
new status - ilt.su
ilt.su - statuses
post a new status