query("SELECT id FROM products WHERE category_id = $id");
if($check->num_rows > 0) {
$error = "Cannot delete category! It contains products.";
} else {
$conn->query("DELETE FROM categories WHERE id = $id");
header("Location: categories.php");
}
}
// Handle Add/Edit
$edit_cat = null;
if(isset($_GET['edit'])) {
$id = intval($_GET['edit']);
$edit_cat = $conn->query("SELECT * FROM categories WHERE id = $id")->fetch_assoc();
}
if(isset($_POST['save_category'])) {
$name = $_POST['name'];
if(isset($_POST['category_id']) && !empty($_POST['category_id'])) {
$id = $_POST['category_id'];
$stmt = $conn->prepare("UPDATE categories SET name=? WHERE id=?");
$stmt->bind_param("si", $name, $id);
} else {
$stmt = $conn->prepare("INSERT INTO categories (name) VALUES (?)");
$stmt->bind_param("s", $name);
}
$stmt->execute();
header("Location: categories.php");
}
?>
Manage Categories
ID
Category Name
Product Count
Action
query("SELECT c.*, (SELECT COUNT(*) FROM products WHERE category_id = c.id) as prod_count FROM categories c ORDER BY c.id DESC");
while($row = $res->fetch_assoc()):
?>