-
Notifications
You must be signed in to change notification settings - Fork 1
/
Copy pathgallery.php
178 lines (154 loc) · 6 KB
/
gallery.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
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
<?php
session_start();
include_once 'include/config.php';
include_once 'include/gallery_user_functions.php';
include_once 'include/getuser.php';
//get user
$user = getSessionUser();
// Connect to MySQL
$db = mysqli_connect(DBHOST, DBUSER, DBPASS, DBNAME);
// Error checking
if (!$db) {
print "<p>Error - Could not connect to MySQL</p>";
exit;
}
$error = mysqli_connect_error();
if ($error != null) {
$output = "<p>Unable to connet to database</p>" . $error;
exit($output);
}
//get images from db
$query = genSQL();
$result = mysqli_query($db, $query);
?>
<!DOCTYPE html>
<html lan="en">
<head>
<meta charset="utf-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Gallery</title>
<link href="css/style.css" rel="stylesheet">
<script src="https://kit.fontawesome.com/57c4c79ee8.js" crossorigin="anonymous"></script>
</head>
<body>
<!--
main nav bar
-->
<nav class="main-nav">
<div class="logo">
<img src="images/logo.png">
</div>
<div class="hamburger">
<div class="line"></div>
<div class="line"></div>
<div class="line"></div>
</div>
<div class="post-bt">
<a href="post.php"><i class="fas fa-plus"></i>  Post new image</a>
</div>
<ul class="nav-links">
<li><a href="gallery.php"><i class="fas fa-th"></i>  Gallery</a></li>
<li><a href="user.php"><i class="fas fa-house-user"></i>  My dashboard</a></li>
<li><a href="account.php"><i class="fas fa-user-cog"></i></i>  settings</a></li>
<li><a href="logout.php"><i class="fas fa-sign-out-alt"></i>  Sign out</a></li>
<li><a href="about.html"><i class="fas fa-question-circle"></i>  About</a></li>
</ul>
</nav>
<!--
Full screen image div
-->
<div class="gal-full-view">
<button class="fullscreen-close-bt"><i class="far fa-times-circle"></i></button>
<img src="">
</div>
<!--
Gallery nav bar
-->
<nav class="gal-nav">
<div id="gal-search">
<input type="text" <?php addSearch() ?> name="gal-search" placeholder="Search title or start with # to search tag">
<div class="button-holder">
<button id='gal-clear-bt'><i class="fas fa-times"></i></button>
<button id='gal-search-bt'><i class="fas fa-search"></i></button>
</div>
</div>
<div id="gal-sort">
Sort:
<select class="gal-contr" name="sort">
<?php addSortOp() ?>
</select>
In
<select class="gal-contr" name="order">
<?php addOrderOp() ?>
</select>
</div>
</nav>
<!--
Gallery
-->
<div class="grid">
<!-- columns -->
<div class="grid-col grid-col--1"></div>
<div class="grid-col grid-col--2"></div>
<div class="grid-col grid-col--3"></div>
<div class="grid-col grid-col--4"></div>
<?php
$admin=isAdmin($db,$user);
while ($row = mysqli_fetch_assoc($result)) {
// output data of each row
//$row = mysqli_fetch_assoc($result);
$id = $row["Img_id"];
$path = $row["Img_file_name"];
$title=$row['title']
?>
<div class="grid-item">
<div class="img_box" <?php echo 'data-user= "' . $user . '" data-img= "' . $id . '"' ?>>
<div class="img_box_header">
<h1 ><?php echo $title ?></h1>
</div>
<img src=<?php echo "'" . $path . "'" ?>>
<div class="pic-edit-picker">
<span><img class="pic-edit-picked" src=<?php echo "'" . $path . "'" . "data-img= '" . $id . "'"." data-img-title= '".$title."'" ?>></span>
<?php
//returns list of edits of the image
$query = "SELECT * FROM img_edit, image WHERE img_edit.img_id=image.Img_id AND img_edit.edit_id=$id";
$edit_result = mysqli_query($db, $query);
while ($edit_row = mysqli_fetch_assoc($edit_result)) {
$edit_id = $edit_row["Img_id"];
$edit_title = $edit_row["title"];
$edit_path = $edit_row["Img_file_name"];
echo '<span><img src="' . $edit_path . '" data-img= "' . $edit_id . '" data-img-title= "' . $edit_title . '"></span>';
}
?>
</div>
<div class="pic-control-bar">
<span><?php addLike($db, $user, $id) ?></span>
<span><button onclick="location.href='<?php echo 'editor.php?id='.$id.'&path='.urlencode($path)?>'" ><i class="fas fa-edit"></i></button></span>
<span><button class="fullscreen-bt"><i class="fas fa-expand"></i></button></span>
<span><button><i class="fas fa-info"></i></button></span>
<span><button class="edit-sl-arw-l"><i class="fas fa-arrow-left"></i></button></span>
<span><button class="edit-sl-bn"><i class="fas fa-images"></i></button></span>
<span><button class="edit-sl-arw-r"><i class="fas fa-arrow-right"></i></button></span>
<?php
if($admin){
?>
<span><button onclick="location.href='<?php echo 'include/delete_img.php?id='.$id?>'" class="edit-sl-delete"><i class="fas fa-trash-alt"></i></button></span>
<?php
}
?>
</div>
</div>
</div>
<?php } ?>
</div>
<script src="js/nav.js"></script>
<script src="js/jquery-3.5.1.min.js"></script>
<script src="js/gallery.js"></script>
<script src="https://unpkg.com/colcade@0/colcade.js"></script>
<script>
$('.grid').colcade({
columns: '.grid-col',
items: '.grid-item'
})
</script>
</body>