prepare('DELETE FROM ' . tn('announcements') . ' WHERE id = ?')->execute([$id]);
$msg = '已删除这条公告。';
}
if (isset($_POST['save'])) {
verifyCsrf();
$id = (int) ($_POST['id'] ?? 0);
$title = trim($_POST['title'] ?? '');
$content = trim($_POST['content'] ?? '');
$pinned = isset($_POST['pinned']) ? 1 : 0;
$status = isset($_POST['status']) ? 1 : 0;
if ($title === '') $err = '请填写公告标题。';
elseif ($content === '') $err = '请填写公告内容。';
if ($err === '') {
if ($id > 0) {
$db->prepare('UPDATE ' . tn('announcements') . ' SET title=?, content=?, pinned=?, status=? WHERE id=?')
->execute([$title, $content, $pinned, $status, $id]);
$msg = '公告已更新！';
} else {
$db->prepare('INSERT INTO ' . tn('announcements') . ' (title, content, pinned, status, created_at) VALUES (?,?,?,?,NOW())')
->execute([$title, $content, $pinned, $status]);
$msg = '公告已发布！';
}
}
}
$edit = null;
if (isset($_GET['edit'])) {
$stmt = $db->prepare('SELECT * FROM ' . tn('announcements') . ' WHERE id = ?');
$stmt->execute([(int) $_GET['edit']]);
$edit = $stmt->fetch();
}
$showForm = ($edit !== null) || isset($_GET['act']) && $_GET['act'] === 'add';
$list = $db->query('SELECT * FROM ' . tn('announcements') . ' ORDER BY pinned DESC, created_at DESC')->fetchAll();
adminHeader('公告中心', 'announcements');
?>
公告中心
还没有公告，点上方「发布公告」。
| ID | 标题 | 置顶 | 显示 | 时间 | 操作 |
|---|
|
|
置顶' : '否' ?> |
显示' : '隐藏' ?> |
|
|