prepare("INSERT INTO packages (category_id, name, slug, short_description, description, price, original_price, whats_included, optional_extras, image, is_featured, is_popular, sort_order) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?)"); $stmt->bind_param("issssddsssiii", $cat_id, $name, $slug, $short, $desc, $price, $orig, $included, $extras, $image, $featured, $popular, $sort); } else { $id = intval($_POST['id']); if ($image) { $stmt = $conn->prepare("UPDATE packages SET category_id=?, name=?, slug=?, short_description=?, description=?, price=?, original_price=?, whats_included=?, optional_extras=?, image=?, is_featured=?, is_popular=?, sort_order=? WHERE id=?"); $stmt->bind_param("issssddsssiii", $cat_id, $name, $slug, $short, $desc, $price, $orig, $included, $extras, $image, $featured, $popular, $sort, $id); } else { $stmt = $conn->prepare("UPDATE packages SET category_id=?, name=?, slug=?, short_description=?, description=?, price=?, original_price=?, whats_included=?, optional_extras=?, is_featured=?, is_popular=?, sort_order=? WHERE id=?"); $stmt->bind_param("issssddsssiii", $cat_id, $name, $slug, $short, $desc, $price, $orig, $included, $extras, $featured, $popular, $sort, $id); } } $stmt->execute(); $msg = '
Package saved!
'; } elseif ($action == 'delete') { $id = intval($_POST['id']); $conn->query("DELETE FROM packages WHERE id=$id"); $msg = '
Package deleted!
'; } } $packages = $conn->query("SELECT p.*, c.name as cname FROM packages p JOIN categories c ON p.category_id=c.id ORDER BY p.id DESC")->fetch_all(MYSQLI_ASSOC); $categories = getCategories(); ?>

Packages

IDNameCategoryPriceFeaturedPopularImageAction
':'' ?> ':'' ?> ':'No' ?>