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;
}
$mycategories = $categories->getAllCategories();
foreach ($mycategories as $c) {
echo "<li><a href=\"index.php?id=" . $c->getId() . "\">" . $c->getName() . "</a></li>";
}
?>
</ul>
<?php
if (isset($_GET['id'])) {
$cat = $categories->getCategory($_GET['id']);
}
if (isset($cat)) {
$mymovies = $movies->getAllMoviesCategory($_GET['id']);
print "<h4 style=\"display:inline; vertical-align:middle;\">" . $cat->getName() . "</h4>";
} else {
$mymovies = $movies->getAllMovies();
print "<h4 style=\"display:inline; vertical-align:middle;\"> Tous les films </h4>";
}
print "</div> <br>";
$i = 0;
foreach ($mymovies as $m) {
if ($i == 0) {
echo "<div class=\"row conteneur\">";
}
echo "<div class=\"col-md-4\">";
echo "<div class=\"well well-lg\">";
echo "<h3><span class=\"glyphicon glyphicon-film\"></span> " . escape($m->getTitle()) . "</h3>";
echo "<p id=\"description\">" . escape($m->getDescriptionShort()) . " <a href=\"movie.php?id=" . $m->getId() . "\"><span class=\"glyphicon glyphicon-option-horizontal\"></span></a></p>";
echo "</div>";
echo "</div>";
$i = $i + 1;
