<?php
include 'includes/header.php';
$id = $_GET['id'];
$db = new Database();
$pi = new Picture();
$ca = new Category();
$image = $db->select($pi->getPictureById($id))->fetch_assoc();
$categories = $db->select($ca->getAllCategories());
// if submit button is pressed
if (isset($_POST['submit'])) {
//assign story variables
$category = mysqli_real_escape_string($db->link, $_POST['category']);
$title = mysqli_real_escape_string($db->link, $_POST['title']);
$description = mysqli_real_escape_string($db->link, $_POST['description']);
$year = mysqli_real_escape_string($db->link, $_POST['year']);
// simple validation
if ($title == '' || $description == '' || $category == '' || $year == '') {
// set error
$error = 'Please fill out all required fields.';
} else {
$update_row = $db->update($pi->updatePicture($category, $year, $title, $description, $id));
}
}
if (isset($_POST['delete'])) {
$delete_row = $db->delete($pi->deletePicture($id));
$filename = "../images/gallery/" . $image['ImagePath'];
unlink($filename);
}
?>
