-
Notifications
You must be signed in to change notification settings - Fork 0
/
allbooks.php
120 lines (107 loc) · 4.76 KB
/
allbooks.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
<?php
require_once("private/connection.php");
//joins the author and book table so that the author name is in the books table
$results = $pdo->query("SELECT *, CONCAT(authors.first_name,' ', authors.last_name) as author
FROM books
INNER JOIN authors
ON books.author = authors.author_id;");
?>
<?php
require_once("php/header.php");
?>
<main>
<section class="allbooksheading">
<h1>Look At What We Have!</h1>
</section>
<!--
<section id="filter-and-sort">
<div id="list1" class="dropdown-check-list" tabindex="100">
<span class="anchor">
Filter
<svg xmlns="http://www.w3.org/2000/svg" height="24" viewBox="0 -960 960 960" width="24" fill="#432818"><path d="M400-240v-80h160v80H400ZM240-440v-80h480v80H240ZM120-640v-80h720v80H120Z"/></svg>
</span>
<ul class="genres">
<li><input type="checkbox" />Classic</li>
<li><input type="checkbox" />YA (Young Adult)</li>
<li><input type="checkbox" />Romance</li>
<li><input type="checkbox" />Fantasy</li>
<li><input type="checkbox" />Sci-Fi</li>
<li><input type="checkbox" />Mystery</li>
<li><input type="checkbox" />Thriller</li>
<li><input type="checkbox" />Historical</li>
<li><input type="checkbox" />Contemporary</li>
<li><input type="checkbox" />Literary</li>
<li><input type="checkbox" />Adventure</li>
<li><input type="checkbox" />Horror</li>
<li><input type="checkbox" />Dystopian</li>
<li><input type="checkbox" />Graphic</li>
<li><input type="checkbox" />Memoir</li>
<li><input type="checkbox" />Biography</li>
<li><input type="checkbox" />Self-Help</li>
<li><input type="checkbox" />Nonfiction</li>
<li><input type="checkbox" />Poetry</li>
<li><input type="checkbox" />Humor</li>
<li><input type="checkbox" />Suspense</li>
<li><input type="checkbox" />Crime</li>
<li><input type="checkbox" />Paranormal</li>
<li><input type="checkbox" />Science</li>
<li><input type="checkbox" />Philosophy</li>
<li><input type="checkbox" />Satire</li>
</ul>
</div>
<script src="js\filter-dropdown.js"></script>
<div id="sort">
<label for="sort">Sort by:</label>
<select name="sort" id="sort">
<option value="">-- Select an option --</option>
<option value="alphabet-asc">Alphabetical Order (A-Z)</option>
<option value="alphabet-desc">Alphabetical Order (Z-A)</option>
<option value="popularity">Popularity</option>
</select>
</div>
</section>
-->
<section class="allbooks">
<?php
require ("php/genresDictionary.php");
foreach ($results as $books)
//! I NEED to find an api for the book cover. The links are temporary. I may just have to do google books :(
{
echo "
<div class='thebook_div'>
<div class='img_div'>
<a href='book-details.php?book_id={$books["book_id"]}'>
<img src='{$books["cover_url"]}' alt='{$books["title"]}' class='Books'></a>
</div>
<div class='book-inside'></div>
<div class='label_container'>";
//creating an array with for the genres
$genres = array($books['genre1'], $books['genre2'], $books['genre3']);
//start of the foreach loop for the labels
foreach ($genres as $genre) {
//convert the abbrv to full name
if(isset($genresDictionary[$genre]) and (!empty($genre))) {
$fullGenreName = $genresDictionary[$genre];
}
// Only display the genre if it's not empty
if (!empty($genre)) {
echo "<span class='label {$genre}'>{$fullGenreName}</span>";
} //end of foreach loop for labels
} //end of the foreach loop inside the echo statement
echo "
</div>
<div class='thebook_info'>
<h4>{$books["title"]}</h4>
<p class='thebook_info_para'>{$books["author"]}</p>
</div>
</div>";
}
?>
</div>
</main>
<?php
require_once("php/footer.php");
?>
</body>
</html>
<!--When you have the time, try to reinvent the page by creating a bookshelf-->