-
Notifications
You must be signed in to change notification settings - Fork 0
/
index.php
104 lines (82 loc) · 3.28 KB
/
index.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
<?php
require_once 'header.php';
//$top_movies = array_slice($movies, 0, 8);
$top_movies = $db->query('SELECT * FROM movies ORDER BY year DESC LIMIT 8')->fetchAll();
$rand_movies = $db->query('SELECT * FROM movies ORDER BY RAND() LIMIT 3')->fetchAll();
?>
<div class="row">
<div class="col-xs-12 col-sm-9">
<div class="jumbotron">
<h1>Bienvenue sur Movies !</h1>
<p>Le site n°1 du cinéma.<br />
Découvrez notre <a href="search.php">recherche</a> de films et des <a href="news.php">actualités</a> sur le cinéma.
</p>
</div><!-- .jumbotron -->
<div class="row marketing">
<?php foreach ($rand_movies as $key => $movie) { ?>
<!-- BLOCK RANDOM MOVIE -->
<div class="col-xs-12 col-sm-6 col-md-4 col-lg-4">
<img class="movie-thumbnail" src="<?= getCover($movie['id']) ?>" />
<div class="caption">
<h2><?= $movie['title'] ?></h2>
<p><?= cutString($movie['synopsis'], 100) ?></p>
<p><a class="btn btn-default" href="movie.php?id=<?= $movie['id'] ?>" role="button">Voir la fiche du film »</a></p>
</div>
</div>
<!-- END BLOCK RANDOM MOVIE -->
<?php } ?>
</div><!-- .marketing -->
<?php
if (!empty($_SESSION['movies'])) {
$movie_ids_array = array_keys($_SESSION['movies']);
$movie_ids = implode(', ', $movie_ids_array);
$movie_ids_order = 'ORDER BY id = '.implode(' DESC, id = ', $movie_ids_array).' DESC';
$visited_movies = $db->query('SELECT * FROM movies WHERE id IN ('.$movie_ids.') '.$movie_ids_order)->fetchAll();
/*
$result = $db->query('SELECT * FROM movies WHERE id IN ('.$movie_ids.')')->fetchAll();
$visited_movies = $_SESSION['movies'];
foreach($result as $key => $movie) {
$visited_movies[$movie['id']] = $movie;
}
*/
?>
<hr>
<h1>Les derniers films visités</h1>
<div id="visited-movies" class="row">
<?php foreach ($visited_movies as $key => $movie) { ?>
<!-- BLOCK VISITED MOVIE -->
<div class="top-movie col-xs-12 col-sm-6 col-md-4 col-lg-3">
<div class="thumbnail">
<img src="<?= getCover($movie['id']) ?>" />
<div class="caption">
<h2><?= $movie['title'] ?></h2>
<p><?= cutString($movie['synopsis'], 100, '[...]') ?></p>
<p><a class="btn btn-default" href="movie.php?id=<?= $movie['id'] ?>" role="button">Voir la fiche du film »</a></p>
</div>
</div>
</div>
<!-- END BLOCK VISITED MOVIE -->
<?php } ?>
</div><!-- #visited-movies -->
<?php } ?>
<hr>
<div id="top-movies" class="row">
<?php foreach ($top_movies as $key => $movie) { ?>
<!-- BLOCK TOP MOVIE -->
<div class="top-movie col-xs-12 col-sm-6 col-md-4 col-lg-3">
<div class="thumbnail">
<img src="<?= getCover($movie['id']) ?>" />
<div class="caption">
<h2><?= $movie['title'] ?></h2>
<p><?= cutString($movie['synopsis'], 100, '[...]') ?></p>
<p><a class="btn btn-default" href="movie.php?id=<?= $movie['id'] ?>" role="button">Voir la fiche du film »</a></p>
</div>
</div>
</div>
<!-- END BLOCK TOP MOVIE -->
<?php } ?>
</div><!-- #top-movies -->
</div><!-- .col-xs-12.col-sm-9 -->
<?php include 'sidebar.php'; ?>
</div><!-- .row -->
<?php include_once 'footer.php'; ?>