-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathfavourites.php
121 lines (111 loc) · 3.65 KB
/
favourites.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
112
113
114
115
116
117
118
119
120
121
<!DOCTYPE html>
<html lang="en">
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="utf-8" />
<meta
name="viewport"
content="width=device-width, initial-scale=1, shrink-to-fit=no"
/>
<meta name="description" content="" />
<meta name="author" content="" />
<title>Movie Bookmark Application - Favourites</title>
<!-- Favicon-->
<link rel="icon" type="image/x-icon" href="assets/favicon.ico" />
<!-- Core theme CSS (includes Bootstrap)-->
<link href="css/styles.css" rel="stylesheet" />
<link rel="stylesheet" href="/css/style.css" />
</head>
<body>
<!-- Responsive navbar-->
<nav class="navbar navbar-expand-lg navbar-dark bg-dark">
<div class="container">
<a class="navbar-brand" href="index.php">Movie Bookmark Application</a>
<button
class="navbar-toggler"
type="button"
data-bs-toggle="collapse"
data-bs-target="#navbarSupportedContent"
aria-controls="navbarSupportedContent"
aria-expanded="false"
aria-label="Toggle navigation"
>
<span class="navbar-toggler-icon"></span>
</button>
<div class="collapse navbar-collapse" id="navbarSupportedContent">
<ul class="navbar-nav ms-auto mb-2 mb-lg-0">
<li class="nav-item">
<a class="nav-link active" aria-current="page" href="index.php">Home</a>
</li>
<?php session_start(); if(isset($_SESSION['userid']) && $_SESSION['userid'] != NULL){echo('
<li class="nav-item">
<a class="nav-link" href="favourites.php">Favourites</a>
</li>
<li class="nav-item">
<a class="nav-link" href="bookmarks.php">Bookmarks</a>
</li>');} ?>
<li class="nav-item">
<a class="nav-link" href="<?php if(isset($_SESSION['userid']) && $_SESSION['userid'] != NULL) {echo('logout.php');} else {echo('/login/login.php');} ?>"><?php if(isset($_SESSION["userid"]) && $_SESSION["userid"] != NULL){echo("Log-out");}else{echo("Log-in");} ?></a>
</li>
</ul>
</div>
</div>
</nav>
<!-- Page content-->
<center id="movies" >
<link rel="stylesheet" href="/../components/movieCard/movieCard.css" />
<?php
require_once'functions.php';
$sql = $dbh->prepare("SELECT * FROM movies WHERE user_id = :ui and listing_type=1");
$sql->setFetchMode(PDO::FETCH_ASSOC);
$sql->bindParam(':ui',$_SESSION["userid"],PDO::PARAM_INT);
$sql->execute();
if($sql->rowCount() != 0) {
?>
<?php
while($row=$sql->fetch())
{
if(strlen($row["movie_image"])<20)
{
$img="/default.png";
}
else
{
$img=$row["movie_id"];
}
echo '
<div class="movie-container">
<div class="image-container">
<img src='.$img.'/>
</div>
<div class="info">
<h3 class="title">'.$row["movie_name"].'</h3>
<p id="index" hidden>'.$row["movie_id"].'</p>
<p>'.$row["movie_year"].' / '.$row["movie_type"].'</p>
<p>Saved on '.$row["create_date"].'</p>
<div class="action_container">
<a href="link" id="isFavourite"><i class="is_favourite fa fa-heart"></i></a>
<a target="_blank" href="https://imdb.com/title/'.$row["movie_link"].'" class="button">IMDb</a>
</div>
<div class="bs-example">
</div>
</div>
</div>
';
}
}
else
{
echo "don't exist records for list on the table";
}
?>
</center>
<!-- Core theme JS-->
<script defer src="/components/appHeader/appHeader.js"></script>
<script defer src="/components/movieCard/movieCard.js"></script>
<script src="js/scripts.js"></script>
</body>
</html>
</body>
</html>