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);
}
}
}
}
<?php
require_once "../classes/Database.php";
require_once "../classes/Movie.php";
if ($_SERVER["REQUEST_METHOD"] === "POST" && isset($_POST["movie_name"])) {
$name = htmlentities($_POST["movie_name"]);
$description = htmlentities($_POST["movie_description"]);
$rating = $_POST["movie_rating"];
$db = DATABASE::getInstance();
$mysqli = $db->getConnection();
$movie = new Movie($mysqli);
$movie->setName($name);
$movie->setDescription($description);
$movie->setRating($rating);
$movie->addToDatabase();
header("location: adminPanel.php");
} else {
header("location: adminPanel.php");
}