-
Notifications
You must be signed in to change notification settings - Fork 0
/
reviewphoto.php
75 lines (64 loc) · 3.93 KB
/
reviewphoto.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
<style>
.line-height-username1 {
line-height: 1.80rem;
}
</style>
<?php include_once '_header.php'; ?>
<section class="text-gray-600 body-font">
<div class="container mx-auto flex px-5 py-24 md:flex-row flex-col items-center">
<?php
// Include the db file
include_once 'includes/dbh.inc.php';
// Get Photo ID
$id = mysqli_real_escape_string( $conn, $_GET['photoid'] );
// Create query to display required image
$sql = "SELECT * FROM photo WHERE id = $id;";
$stmt = mysqli_stmt_init( $conn );
if ( !mysqli_stmt_prepare( $stmt, $sql ) ) {
echo "SQL Statement Failed!";
} else {
mysqli_stmt_execute( $stmt );
$result = mysqli_stmt_get_result( $stmt );
$numRows = mysqli_num_rows( $result );
if ( $numRows > 0 ) {
while ( $row = mysqli_fetch_assoc( $result ) ) {
$user_id = $row['user_id'];
$userSql = "SELECT * FROM users WHERE id = $user_id;";
if ( !mysqli_stmt_prepare( $stmt, $userSql ) ) {
echo "SQL Statement Failed!";
} else {
mysqli_stmt_execute( $stmt );
$result = mysqli_stmt_get_result( $stmt );
$userRow = mysqli_fetch_assoc( $result );
$posted_by = $userRow['fullname'];
}
echo '<div class="lg:max-w-lg lg:w-full md:w-1/2 w-5/6 mb-10 md:mb-0">
<img class="object-cover object-center rounded" alt="photo" src="img/'.$row['img_name'].'" style="box-shadow: 0 0 2px;">
</div>
<div class="lg:flex-grow md:w-1/2 lg:pl-24 md:pl-16 flex flex-col md:items-start md:text-left items-center text-center">
<h1 class="title-font sm:text-4xl text-3xl mb-4 font-small text-gray-900">'.$row['title'].'
<br class="hidden lg:inline-block">
</h1>
<p class="mb-8 leading-relaxed">'.$row['description'].'.</p>
<p class="mb-1 leading-relaxed"><b>Posted by :</b></p>
<div class="inline-block mb-20 rounded-full bg-gray-300 pr-3 h-8 line-height-username1">
<img class="rounded-full float-left h-full" src="img/default-image.png"> <span class="ml-3">'.$posted_by.'</span>
</div>
<div class="flex justify-center ml-20 mt-9">
<a href="img/'.$row['img_name'].'" download><button
class="bg-grey-light hover:bg-grey text-grey-darkest font-bold ml-12 mt-9 py-2 px-3 rounded inline-flex items-center object-cover" style="box-shadow: 0 0 2px;">
<svg class="fill-current w-4 h-4 mr-2" xmlns="http://www.w3.org/2000/svg"
viewBox="0 0 20 20">
<path d="M13 8V2H7v6H2l8 8 8-8h-5zM0 18h20v2H0v-2z" />
</svg>
<span>Download Photo</span>
</button></a>
</div>
</div>';
}
}
}
?>
</div>
</section>
<?php include_once '_footer.php'; ?>