prepare($sql);
$stmt->bind_param("i", $id);
$stmt->execute();
$result = $stmt->get_result();
$project = $result->fetch_assoc();
// Update project on POST
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
$name = $_POST['project_name'];
$url = $_POST['sheet_url'];
$status = $_POST['status'];
$deadline = $_POST['deadline'];
$update = $conn->prepare("UPDATE seo_projects SET project_name=?, sheet_url=?, status=?, deadline=? WHERE id=?");
$update->bind_param("ssssi", $name, $url, $status, $deadline, $id);
$update->execute();
header("Location: ../dashboard.php");
exit;
}
?>
Edit Project
Edit Project