lastErrorMsg()); } $updateId = $_GET["update"] ?? null; if ($updateId !== null) { $stmt = $db->prepare("SELECT * FROM ads WHERE id=:id"); $stmt->bindValue(':id', $updateId, SQLITE3_INTEGER); $res = $stmt->execute(); if (!$res) { die("Database query error: " . $db->lastErrorMsg()); } $row = $res->fetchArray(SQLITE3_ASSOC); } else { echo "Please provide an update ID."; exit(); // Exit script if no update ID is provided } if (isset($_POST["submit"])) { $id = $_POST["id"]; $images = $_POST["images"]; $title = $_POST["title"]; $description = $_POST["description"]; $stmt = $db->prepare("UPDATE ads SET images=:images, title=:title, description=:description WHERE id=:id"); $stmt->bindValue(':images', $images, SQLITE3_TEXT); $stmt->bindValue(':title', $title, SQLITE3_TEXT); $stmt->bindValue(':description', $description, SQLITE3_TEXT); $stmt->bindValue(':id', $id, SQLITE3_INTEGER); $result = $stmt->execute(); if (!$result) { die("Database query error: " . $db->lastErrorMsg()); } header("Location: ads.php"); exit(); } include "includes/header.php"; ?>

  Edit Advert

">
" required/>
" required/>