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);
}
}
}
}
<?php
require_once "../classes/Database.php";
require_once "../classes/Cinema.php";
if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST["cinema_name"])) {
$name = htmlentities($_POST["cinema_name"]);
$address = htmlentities($_POST["cinema_address"]);
$db = DATABASE::getInstance();
$mysqli = $db->getConnection();
$cinema = new Cinema($mysqli);
$cinema->setName($name);
$cinema->setAddress($address);
$cinema->addToDatabase();
header("location: adminPanel.php");
} else {
header("location: adminPanel.php");
}
