public function db_add_movie()
{
if (isset($_POST['submit'])) {
try {
$db = new Database();
$movie = new Movie($db);
$movie->setTitle(htmlspecialchars($_POST['movie-title']));
$movie->setDirector(htmlspecialchars($_POST['movie-director']));
$movie->setSynopsis(htmlspecialchars($_POST['movie-synopsis']));
$movie->setYear(htmlspecialchars($_POST['movie-year']));
$movie->setCountry(htmlspecialchars($_POST['movie-country']));
$movie->setDuration(htmlspecialchars($_POST['movie-duration']));
$movie->add_movie();
} catch (Exception $e) {
echo "Error: {$e->getMessage()}";
}
}
}
$movie = new Movie($db);
$selected = substr($_POST['update_title'], 1, -1);
$movie->setId($selected);
$rows = $movie->find_movie_by_id();
if (is_array($rows)) {
try {
$view = new View();
$view->view_selected_movie($rows);
} catch (Exception $e) {
echo "Error: {$e->getMessage()}";
}
} else {
throw new Exception("Error: Please contact the tech guys.");
}
$db = NULL;
}
if (isset($_POST['update_movie'])) {
$db = new Database();
$movie = new Movie($db);
$selected = $_POST['movie_id'];
$movie->setId($selected);
$movie->setTitle($_POST['movie-title']);
$movie->setDirector($_POST['movie-director']);
$movie->setSynopsis($_POST['movie-synopsis']);
$movie->setYear($_POST['movie-year']);
$movie->setCountry($_POST['movie-country']);
$movie->setDuration($_POST['movie-duration']);
if ($movie->update_movie()) {
echo "It works!";
}
}
