public function deleteCategory($id)
{
$moviesBD = new MoviesBD();
$resultats = $this->bdd->query("SELECT cat_id FROM category WHERE cat_default=1 ;");
$resultats->setFetchMode(PDO::FETCH_OBJ);
while ($result = $resultats->fetch()) {
$default = $result->cat_id;
}
foreach ($moviesBD->getAllMovies() as $movie) {
if ($movie->getCategory() == $id) {
$movie->setCategory($default);
$moviesBD->updateMovie($movie, null);
}
}
$req = $this->bdd->prepare("DELETE FROM category WHERE cat_id = :id AND cat_default=0;");
$result = $req->execute(array("id" => $id));
return $result;
}
}
header('Location: ../add.php');
} else {
if (isset($_POST['edit'])) {
$_SESSION["edit"] = false;
if (isset($_POST)) {
$movie = $movieBD->getMovie($_POST['id'], $idUser);
$movie->setTitle(isset($_POST['titre']) ? $_POST['titre'] : $movie->getTitle());
$movie->setDescriptionShort(isset($_POST['resume']) ? $_POST['resume'] : $movie->getDescriptionShort());
$movie->setDescriptionLong(isset($_POST['synopsis']) ? $_POST['synopsis'] : $movie->getDescriptionLong());
$movie->setDirector(isset($_POST['realisateur']) ? $_POST['realisateur'] : $movie->getDirector());
$movie->setYear(isset($_POST['annee']) ? $_POST['annee'] : $movie->getYear());
$movie->setImage(empty($_FILES['affiche']['name']) ? $movie->getImage() : $_FILES['affiche']['name']);
$movie->setCategory(isset($_POST['categorie']) ? $_POST['categorie'] : $movie->getCategory());
print_r($movie);
$_SESSION["edit"] = $movieBD->updateMovie($movie, empty($_FILES['affiche']['nom']) ? null : $_FILES['affiche']);
header('Location: ../edit.php?id=' . $movie->getId());
}
} else {
if (isset($_POST['delete'])) {
$_SESSION["delete"] = false;
if (isset($_POST)) {
$_SESSION["delete"] = $movieBD->deleteMovie($_POST['id']);
header('Location: ../admin.php');
}
} else {
if (isset($_POST['duplicate'])) {
$_SESSION["duplicate"] = false;
if (isset($_POST)) {
$_SESSION["duplicate"] = $movieBD->duplicateMovie($_POST['id'], $idUser);
header('Location: ../admin.php');
