<?php require_once "../classes/Database.php"; require_once "../classes/Screening.php"; require_once "../classes/Movie.php"; require_once "../classes/Cinema.php"; if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST["movie"])) { $movieId = $_POST["movie"]; $cinemaId = $_POST["cinema"]; $dateFormatted = str_replace("T", " ", $_POST["date"]); $db = DATABASE::getInstance(); $mysqli = $db->getConnection(); $movie = new Movie($mysqli); $movie->findMovieById($movieId); $cinema = new Cinema($mysqli); $cinema->findCinemaById($cinemaId); $screening = new Screening($mysqli); $screening->setMovie($movie); $screening->setCinema($cinema); $screening->setDate($dateFormatted); $screening->addToDatabase(); header("location: adminPanel.php"); }
<a href="index.php" class="btn btn-default">Go to the main site</a> <?php require_once "classes/Database.php"; require_once "classes/Movie.php"; require_once "classes/Cinema.php"; require_once "classes/ScreeningFetcher.php"; require_once "classes/Screening.php"; require_once "includes/ticketForm.php"; if ($_SERVER["REQUEST_METHOD"] === "GET" && $_GET["type"] === "movie") { $id = $_GET["id"]; $db = DATABASE::getInstance(); $mysqli = $db->getConnection(); $movie = new Movie($mysqli); $movie->findMovieById($id); $movieName = $movie->getName(); $movieRating = $movie->getRating(); $movieDesc = $movie->getDescription(); echo "<h3>Title: {$movieName}</h3>"; echo "<p>Rating: {$movieRating}</p>"; echo "<h3>Description:</h3>"; echo "<p>{$movieDesc}</p>"; echo "<h3>Movie Screenings:</h3>"; $fetcher = new ScreeningFetcher($db); $fetcher->getMovieScreenings($id); $screeningsArray = $fetcher->getArrayWithMovieScreenings(); if (!empty($screeningsArray)) { echo "<ul>"; foreach ($screeningsArray as $screening) { $cinemaName = $screening->getCinema()->getName();
public function getCinemaScreenings($id) { $sqlQuery = "SELECT id, cinema_id, movie_id, date FROM screenings WHERE date > NOW() AND cinema_id = {$id} ORDER BY date "; $conn = parent::getConnection(); $result = $conn->query($sqlQuery); if ($result->num_rows > 0) { while (list($id, $cinemaId, $movieId, $date) = $result->fetch_array(MYSQLI_NUM)) { $movie = new Movie($conn); $movie->findMovieById($movieId); $cinema = new Cinema($conn); $cinema->findCinemaById($cinemaId); $screening = new Screening($conn); $screening->setMovie($movie); $screening->setCinema($cinema); $screening->setDate($date); $screening->setId($id); $this->setArrayWithCinemaScreenings($screening); } } }