<?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"); }
$screeningId = $screening->getId(); echo "<li>Cinema: <a href='showInfo.php?type=cinema&id={$cinemaId}'>{$cinemaName}</a>, Date & Time: {$dateFormatted}"; renderTicketForm($screeningId); echo "</li>"; } echo "</ul>"; } else { echo "<p>No screenings</p>"; } } if ($_SERVER["REQUEST_METHOD"] === "GET" && $_GET["type"] === "cinema") { $id = $_GET["id"]; $db = DATABASE::getInstance(); $mysqli = $db->getConnection(); $cinema = new Cinema($mysqli); $cinema->findCinemaById($id); $cinemaName = $cinema->getName(); $cinemaAddress = $cinema->getAddress(); echo "<h3>Name: {$cinemaName}</h3>"; echo "<p>Address: {$cinemaAddress}</p>"; echo "<h3>Cinema Screenings:</h3>"; $fetcher = new ScreeningFetcher($db); $fetcher->getCinemaScreenings($id); $screeningsArray = $fetcher->getArrayWithCinemaScreenings(); if (!empty($screeningsArray)) { echo "<ul>"; foreach ($screeningsArray as $screening) { $movieName = $screening->getMovie()->getName(); $movieId = $screening->getMovie()->getId(); $date = $screening->getDate(); $dateFormatted = substr($date, 0, 16);
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); } } }