prepare("INSERT INTO categories (name, slug, description, icon, sort_order) VALUES (?, ?, ?, ?, ?)"); $stmt->bind_param("ssssi", $name, $slug, $desc, $icon, $sort); } else { $id = intval($_POST['id']); $stmt = $conn->prepare("UPDATE categories SET name=?, slug=?, description=?, icon=?, sort_order=? WHERE id=?"); $stmt->bind_param("ssssii", $name, $slug, $desc, $icon, $sort, $id); } $stmt->execute(); $msg = '

Category saved!

'; } elseif ($action == 'delete') { $id = intval($_POST['id']); $conn->query("DELETE FROM categories WHERE id=$id"); $msg = '

Category deleted!

'; } } $categories = getCategories(); ?>