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