-
Notifications
You must be signed in to change notification settings - Fork 0
/
admin-view_movies.php
119 lines (102 loc) · 4.14 KB
/
admin-view_movies.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
<?php
require_once('admin.php');
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>View Movies</title>
<link href="style.css" rel="stylesheet" type="text/css" />
<link rel="icon" href="icons/fav.ico" type="image/x-icon">
<link rel="shortcut icon" href="icons/fav.ico" type="image/x-icon">
</head>
<body>
<div class="content">
<?php
require_once('menu.php'); menu();
?>
<h1>View Movies</h1>
<?php
require_once('config.php');
//Connect to mysql server
$link = mysql_connect(DB_HOST, DB_USER, DB_PASSWORD);
if(!$link) {
die('Failed to connect to server: ' . mysql_error());
}
//Get all results as UTF-8
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'latin1', character_set_server = 'latin1'", $link)
or die(mysql_error());
//Select database
$db = mysql_select_db(DB_DATABASE);
if(!$db) {
die("Unable to select database");
}
//Get all results as UTF-8
mysql_query("SET character_set_results = 'utf8', character_set_client = 'utf8', character_set_connection = 'utf8', character_set_database = 'latin1', character_set_server = 'latin1'", $link)
or die(mysql_error());
if(isset($_GET['page']))
$page=$_GET['page'];
else
$page=1;
//counting all the results for the pagination
$qry="SELECT * FROM movies";
$result=mysql_query($qry) or die(mysql_error());
$rows = mysql_num_rows($result);
//Create query
@$qry="SELECT * FROM movies LIMIT ".($page*RESULTS_PER_PAGE-RESULTS_PER_PAGE).", ".RESULTS_PER_PAGE;
$result=mysql_query($qry) or die(mysql_error());
echo '<table class="results">
<tr>
<td><b>Trailer</b></td>
<td><b>Title</b></td>
<td><b>Year</b></td>
<td></td>
<td></td>
</tr>';
//loop which shows the results in table
while(@$movie = mysql_fetch_array($result)) {
echo '<tr>';
echo '<td class="trailer"> <a href="'.$movie['trailer'].'"><img src="icons/trailer.png"></a> </td>';
echo '<td><a href="view_movie.php?id='.$movie['id'].'">'.$movie['title'].'</a></td>';
echo '<td>'.$movie['year'].'</td>';
echo '<td> <form name="edit" method="post" id="edit" action="admin-edit_movie.php">
<input type="hidden" name="id" id="id" value="'.$movie['id'].'" />
<input type="image" src="icons/movie_edit.png" value="Edit" />
</form>
</td>';
echo '<td> <form name="delete" method="post" id="delete" action="admin-delete_movie_result.php">
<input type="hidden" name="id" id="id" value="'.$movie['id'].'" />
<input type="image" onclick="return confirm(\'Are you sure you want to delete this movie?\')" src="icons/movie_delete.png" value="Delete" />
</form>
</td>';
echo '</tr>';
}
echo '<tr>
<td colspan="5" style="text-align:center;padding-top:10px;vertical-align:middle;">
<form method="get" name="page" id="page" action="admin-view_movies.php">';
echo '<input type="hidden" name="page" id="page" value="'.$page.'"/>';
if ($page > 1){
echo'<input type="image" src="icons/left.png" onclick="document.page.page.value='.($page-1).'"/>';
}
$i=0;
echo '<span style="padding:10px;position:relative;top:-8px;">';
for($i=1;$i<=ceil($rows/RESULTS_PER_PAGE);$i++)
if ($page == $i)
echo ' <b>'.$i.'</b> ';
else
echo ' <a href="admin-view_movies.php?page='.$i.'">'.$i.'</a> ';
echo '</span>';
#echo '<span style="padding:10px;position:relative;top:-8px;">'.(ceil($page/RESULTS_PER_PAGE)+1).'/'.ceil($rows/RESULTS_PER_PAGE).'</span>';
if ($page < ceil($rows/RESULTS_PER_PAGE)){
echo'<input type="image" src="icons/right.png" onclick="document.page.page.value='.($page+1).'"/>';
}
echo '</form>
</td>
</tr>';
echo '</table>'; //close the table
echo '<br /> <br /> <td> <a class="button" href="admin-add_movie.php"><img class="menuicons"src="icons/movie_add.png" />Add Movie</a></td>';
?>
</div>
<?php include "footer.php"; ?>
</body>
</html>