prepare("SELECT * FROM portfolio WHERE id = ?");
$stmt->execute([$id]);
$item = $stmt->fetch();
if(!$item) { die("Item not found"); }
// 3. Handle Update Form Submission
if(isset($_POST['update'])) {
$title = $_POST['title'];
$category_id = $_POST['category_id'];
// Optional: Logic to replace image could go here,
// but for simplicity, we usually just update text data
// or require re-upload for media changes.
$update = $pdo->prepare("UPDATE portfolio SET title = ?, category_id = ? WHERE id = ?");
$update->execute([$title, $category_id, $id]);
header("Location: dashboard.php?msg=updated");
exit;
}
?>
Edit Project