prepare("INSERT INTO gallery (category_id, title, description, image, is_featured, sort_order) VALUES (?,?,?,?,?,?)");
$stmt->bind_param("isssii", $cat_id, $title, $desc, $image, $featured, $sort);
} else {
$id = intval($_POST['id']);
if ($image) { $stmt = $conn->prepare("UPDATE gallery SET category_id=?, title=?, description=?, image=?, is_featured=?, sort_order=? WHERE id=?"); $stmt->bind_param("isssiii", $cat_id, $title, $desc, $image, $featured, $sort, $id); }
else { $stmt = $conn->prepare("UPDATE gallery SET category_id=?, title=?, description=?, is_featured=?, sort_order=? WHERE id=?"); $stmt->bind_param("issiii", $cat_id, $title, $desc, $featured, $sort, $id); }
}
$stmt->execute(); $msg = 'Saved!
';
} elseif ($action == 'delete') {
$id = intval($_POST['id']); $conn->query("DELETE FROM gallery WHERE id=$id");
$msg = 'Deleted!
';
}
}
$gallery = getGallery();
$categories = getCategories();
?>
Gallery Management
| ID | Image | Title | Category | Featured | Action |
|---|
|
 |
| |
':'' ?> |
|