prepare("UPDATE categories SET name=?, slug=?, image=? WHERE id=?");
$stmt->execute([$name, $slug, $img_path, $_POST['cat_id']]);
$msg = "Category updated!"; $msgClass = "success";
} else {
// INSERT
$stmt = $pdo->prepare("INSERT INTO categories (name, slug, image) VALUES (?, ?, ?)");
$stmt->execute([$name, $slug, $img_path]);
$msg = "Category added!"; $msgClass = "success";
}
}
// 2. DELETE CATEGORY
if (isset($_GET['delete'])) {
$pdo->prepare("DELETE FROM categories WHERE id=?")->execute([$_GET['delete']]);
header("Location: categories.php?msg=deleted"); exit();
}
// 3. FETCH DATA
$edit_cat = null;
if (isset($_GET['edit'])) {
$stmt = $pdo->prepare("SELECT * FROM categories WHERE id=?");
$stmt->execute([$_GET['edit']]);
$edit_cat = $stmt->fetch();
}
$categories = $pdo->query("SELECT * FROM categories ORDER BY id DESC")->fetchAll();
?>
Manage Categories