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);
}
}
}
