prepare("INSERT INTO categories (name) VALUES (?)");
$stmt->execute([$name]);
$msg = "分类添加成功";
} elseif ($action === 'delete') {
$stmt = $pdo->prepare("DELETE FROM categories WHERE id = ?");
$stmt->execute([$_POST['id']]);
$msg = "分类删除成功";
}
} catch (PDOException $e) {
$error = "操作失败：".$e->getMessage();
}
}
// 获取现有分类
$categories = $pdo->query("SELECT * FROM categories ORDER BY name")->fetchAll();
?>
分类管理
分类管理