public function getMoviesFromDb($columnsNames = ["id", "name", "description", "rating"]) { if (is_array($columnsNames) && !empty($columnsNames)) { $columns = implode(",", $columnsNames); $sqlQuery = "SELECT " . $columns . " FROM movies"; $conn = parent::getConnection(); $result = $conn->query($sqlQuery); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $movie = new Movie(parent::getConnection()); if (array_key_exists("id", $row)) { $movie->setId($row["id"]); } if (array_key_exists("name", $row)) { $movie->setName($row["name"]); } if (array_key_exists("description", $row)) { $movie->setDescription($row["description"]); } if (array_key_exists("rating", $row)) { $movie->setRating($row["rating"]); } $this->setArrayWithMovies($movie); } } } }
public function getCinemasFromDb($columnsNames = ["id", "name", "address"]) { if (is_array($columnsNames) && !empty($columnsNames)) { $columns = implode(",", $columnsNames); $sqlQuery = "SELECT " . $columns . " FROM cinemas"; $conn = parent::getConnection(); $result = $conn->query($sqlQuery); if ($result->num_rows > 0) { while ($row = $result->fetch_assoc()) { $cinema = new Cinema(parent::getConnection()); if (array_key_exists("id", $row)) { $cinema->setId($row["id"]); } if (array_key_exists("name", $row)) { $cinema->setName($row["name"]); } if (array_key_exists("address", $row)) { $cinema->setAddress($row["address"]); } $this->setArrayWithCinemas($cinema); } } } }
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); } } }