<?php
$title = "Update Confirmation";
include('includes/header.inc');
include('includes/nav.inc');
require_once('includes/config.inc');
require_once('includes/DbController.inc');
echo "<div id='message'>";
$error = false;
if (!empty($_POST['id'])) {
$db = new DbController(HOST,USER,PASS,DB);
foreach ($_POST as $key => $val) {
$$key = trim($val);
}
$sql = "UPDATE places SET location=?, theme=?, description=?, WHERE placeid=?";
$update = $db->updateRecord($sql, $location, $theme, $description, $id);
if ($update) {
echo "<p>Record $placename updated</p>";
} else {
$error = true;
}
} else {
$error = true;
}
if ($error) {
echo "<p>Record is NOT updated.</p>";
}
echo "</div>";
include('includes/footer.inc');
?>