-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathtops-OST.php
111 lines (72 loc) · 3.64 KB
/
tops-OST.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
105
106
107
108
109
110
111
<?php
include 'login-check.php'; //verificar se login foi feito
include 'connection.php'; //ligação à base de dados
//----------------------SELECT FILME------------------------//
$select_filme = "SELECT _id_filmes, filme, image, classif, data_lanc, realizador, imdb_rating, ost_rating
FROM filmes
ORDER BY ost_rating DESC";
$result_filme = $conn->query($select_filme);
?>
<!DOCTYPE html>
<html>
<head>
<!-- META TAGS -->
<meta charset="UTF-8" />
<title>Spotlight Top OST</title>
<!-- STYLESHEETS -->
<link rel="stylesheet" href="assets/css/flexboxgrid.min.css" type="text/css">
<link rel="stylesheet" href="assets/css/_font-awesome.min.css.scss" type="text/css">
<link rel="stylesheet" href="assets/css/style.css" type="text/css">
</head>
<body>
<?php include 'navbar.php'; ?>
<section class="section-resized">
<div class="row">
<div class="subtitle col-xs-12 start-xs">
<p>TOP 25 OST</p>
</div>
</div>
<div class="row">
<div class="col-xs-12 start-xs">
<?php
$numrows_ost = 0;
echo "<div class='row start-md'>";
while(($row = $result_filme->fetch_assoc()) && ($num_rows < 25)) {
$numrows_ost++;
echo "<div class='col-xs-5 col-md-2'>
<div><br><b> #$numrows_ost </b></div>
<a class='nav__link center-xs' href=" . "movie.php?movieid=" . $row["_id_filmes"] . "><img src=" . $row["image"] . " class=" ." logo" . "> </a>
</div>
<div class='col-xs-7 col-md-4'>
<p class='subtitle text-left middle-xs'>" . $row["filme"] . "</p>" .
"<p class='text text-left middle-xs'>";
if (!(!isset($row["data_lanc"]) || empty(trim($row["data_lanc"])))){ //se tiver data_lanc definido
echo "<b>Release date: </b>" . $row["data_lanc"];
}
if (!(!isset($row["classif"]) || empty(trim($row["classif"])))){ //se tiver classif etária definido
echo "<br><b>Age Rating: </b>" . $row["classif"];
}
if (!(!isset($row["realizador"]) || empty(trim($row["realizador"])))){ //se tiver realizador definido
echo "<br><b>Director: </b>" . $row["realizador"];
}
if (!(!isset($row["imdb_rating"]) || empty(trim($row["imdb_rating"])))){ //se tiver imdb_rating definido
echo "<br><b>IMDB Rating: </b>" . $row["imdb_rating"] . "/10";
}
if (!(!isset($row["ost_rating"]) || empty(trim($row["ost_rating"])))){ //se tiver ost_rating definido
echo "<br><b>OST Rating: </b>" . $row["ost_rating"] . "/100";
}
echo " </p>
</div>
<br>";
}
?>
</div>
</div>
</section>
<div class="md-overlay"></div>
<script src="https://ajax.googleapis.com/ajax/libs/angularjs/1.0.7/angular.min.js"></script>
<script type="text/javascript" src="assets/js/classie.js"></script>
<script type="text/javascript" src="assets/js/modalEffects.js"></script>
<script src="assets/js/cssParser.js"></script>
</body>
</html>