/** * init booking page */ public function index() { //echo "this is index method in booking controller"; $getFilmInfo = new FilmBookingModel(); if (isset($_POST['filmId'])) { // $filmId = $_POST['filmId']; $sql = "SELECT DISTINCT(rooms.Room_Name)\n FROM films JOIN running_films\n ON films.Film_Id = running_films.Film_Id\n JOIN rooms\n ON running_films.Room_ID = rooms.Room_ID\n JOIN cinemas\n ON cinemas.Cinema_ID = rooms.Cinema_ID\n WHERE running_films.Film_Id=:Film_Id;"; $RoomInfos = $getFilmInfo->getBookingInfo($filmId, $sql); require_once "./View/Booking.php"; } else { require_once "./View/Error404.php"; } }
/** * click submit button * after choosing film redirect to Booking page * @param $filmId */ public function postToBooking($filmId) { //get film if (empty($filmId)) { header("Location: ./index.php"); } $getFilmInfo = new FilmBookingModel(); $sql = "SELECT *\n FROM films JOIN running_films\n ON films.Film_Id=running_films.Film_Id\n WHERE films.Film_Id=:Film_Id"; $param = ['Film_Id' => $filmId]; $film = $getFilmInfo->getBookingDetail($param, $sql); if (empty($film)) { header("Location: ./index.php"); } $changeRate = new TopRateModel(); $filmInfo = $getFilmInfo->getFilmById($filmId); $changeRate->clickNumber($filmInfo[0]->film_description); $sql = "SELECT DISTINCT(cinemas.Cinema_ID),cinemas.Cinema_Name\n FROM films JOIN running_films\n ON films.Film_Id = running_films.Film_Id\n JOIN rooms\n ON running_films.Room_ID = rooms.Room_ID\n JOIN cinemas\n ON cinemas.Cinema_ID = rooms.Cinema_ID\n WHERE running_films.Film_Id=:Film_Id;"; $CinemaInfos = $getFilmInfo->getBookingInfo($filmId, $sql); // var_dump($filmInfo); require_once "./View/Booking.php"; }