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;
 }
<?php

include_once "includes/include.php";
$movies = new MoviesBD();
$categories = new CategoriesBD();
?>

<!doctype html>
<html>
    <head>
        <?php 
include "includes/head.php";
?>
 
    </head>
    <body>
        <?php 
include_once "includes/navbar.php";
?>
   
        <div class="container"> 
            <div class="container-fluid">
                <div class="dropdown">
                    <button class="btn btn-default dropdown-toggle" type="button" id="dropdownTrieCat" data-toggle="dropdown" aria-haspopup="true" aria-expanded="true">Tier par catégorie<span class="caret"></span></button>
                    <ul class="dropdown-menu" aria-labelledby="dropdownTrieCat">
                        <li><a href="index.php">Tous</a></li>
                        <?php 
$mycategories = $categories->getAllCategories();
foreach ($mycategories as $c) {
    echo "<li><a href=\"index.php?id=" . $c->getId() . "\">" . $c->getName() . "</a></li>";
}
<?php

include_once "includes/include.php";
$movies = new MoviesBD();
if (isset($_GET['id'])) {
    $mymovie = $movies->getMovie($_GET['id']);
    if ($mymovie == null || $mymovie->getUser() != $_SESSION["utilisateur"]->getId()) {
        header('Location: index.php');
    }
} else {
    header('Location: index.php');
}
?>

<!doctype html>
<html>
    <head>
        <?php 
include_once "includes/head.php";
?>
        <title>My Movie Static</title>    
    </head>
    <body>
        <?php 
include_once "includes/navbar.php";
if (isset($_SESSION["edit"]) && $_SESSION["edit"] == true) {
    showModal("Edition complète", "L'édition a été réalisée avec succès.");
} else {
    if (isset($_SESSION["edit"]) && $_SESSION["edit"] == false) {
        showModal("Edition ratée", "L'édition n'a pas pu aboutir.");
    }
<?php

include_once "movies_bd.php";
include_once "users_bd.php";
session_start();
$userBD = new UsersBD();
$idUser = $_SESSION['utilisateur']->getId();
if (isset($idUser) && $userBD->getUser($idUser) != null) {
    $movieBD = new MoviesBD();
    if (isset($_POST['add'])) {
        $_SESSION["ajout"] = false;
        print_r($_POST);
        if (isset($_POST)) {
            $movie = new Movie(-1, $idUser, $_POST['titre'], $_POST['resume'], $_POST['synopsis'], $_POST['realisateur'], $_POST['annee'], $_FILES['affiche']['name'], $_POST['categorie']);
            $_SESSION["ajout"] = $movieBD->addMovie($movie, $_FILES['affiche'], $idUser);
        }
        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']);
<?php

include_once "includes/include.php";
$movies = new MoviesBD();
$users = new UsersBD();
$categories = new CategoriesBD();
?>

<!doctype html>
<html>
    <head>
        <?php 
include "includes/head.php";
?>
 
    </head>
    <body>
        <?php 
include_once "includes/navbar.php";
?>
        <div class="container">
            <h1 class="center">Administration</h1>
            <ul class="nav nav-tabs nav-center">
                <li class="active"><a data-toggle="tab" href="#Film">Films</a></li>
                <li><a data-toggle="tab" href="#Categorie" >Categories</a></li>
                <li><a data-toggle="tab" href="#Utilisateur" >Utilisateurs</a></li>
            </ul>
            <div class="tab-content">
                <div class="tab-pane fade in active"  id="Film">
                    <table class="table table-hover">
                        <thead>