-
Notifications
You must be signed in to change notification settings - Fork 0
/
details.php
71 lines (57 loc) · 2.84 KB
/
details.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
<?php
$TITLE = "Details -- Bookstore Inc";
require_once "templates/header.html.php";
require_once "lib/sanitizers_validators.php";
$connection->select_db("bookstore");
$isbn = validateISBN($_GET["isbn"]);
$details_query = "SELECT isbn,name,detail,date_published,price,book_number,series,publisher,author,picture,total_pages FROM bookstore.book WHERE isbn = " . $isbn;
$bookDetails = $connection->query($details_query);
if ($bookDetails === false || $bookDetails->num_rows < 1)
// Display a book not found page
require "html/book_not_found.html";
$book = $bookDetails->fetch_assoc();
$tags_query = "SELECT tag FROM is_tagged WHERE isbn = '{$isbn}'";
$tags = $connection->query($tags_query);
// TODO: Implement the validations of picture
?>
<div id="content">
<div id="content_left">
<div class="content_left_section">
<h1>Tags</h1>
<ul>
<?php
while ($tag = $tags->fetch_assoc()) {
echo "<li><a href=\"/tag.php?tag={$tag["tag"]}\">{$tag["tag"]}</a></li>";
}
?>
</ul>
</div>
</div> <!-- end of content left -->
<div id="content_right">
<h1><?php echo $book["name"]; ?></h1>
<div class="image_panel"><img src="<?php echo $book["picture"]; ?>" alt="Cover" width="100" height="150" /></div>
<?php
if ($book["series"])
echo "<h2>Book {$book["book_number"]} of <a href=\"/series.php?series={$book["series"]}\">{$book["series"]}</a></h2>";
?>
<ul>
<li>By <a href="/author.php?name=<?php echo $book["author"]; ?>"><?php echo $book["author"]; ?></a></li>
<li>Published By: <?php echo $book["publisher"]; ?></li>
<li>Published: <?php
echo (new DateTime($book["date_published"]))->format("d F Y")
?></li>
<li>Pages: <?php echo $book["total_pages"]; ?></li>
<li>ISBN: <?php echo $book["isbn"]; ?></li>
<li>Price: Rs. <?php echo $book["price"]; ?>	</li>
</ul>
<br/>
<div class="buy_now_button" id="<?php echo $book["isbn"]; ?>"><a href="/cart.php?book=<?php echo $book["isbn"]; ?>">Add to cart</a></div>
<?php echo htmlspecialchars($book["detail"], ENT_COMPAT | ENT_HTML401 | ENT_QUOTES | ENT_IGNORE); ?>
<div class="cleaner_with_height"> </div>
</div> <!-- end of content right -->
<div class="cleaner_with_height"> </div>
</div> <!-- end of content -->
<script src="/assests/js"></script>
<?php
require_once "templates/footer.html.php";
?>