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!"; } }