Changes between Version 7 and Version 8 of ImportantCase2

Timestamp:

01/10/25 15:00:18 (10 months ago)

Author:

222039

Comment:

--

ImportantCase2

@@ -14 +14 @@
                             WHERE book.genre IN ($placeholders) AND book.PublishedYear BETWEEN $query_from AND $query_to;"
 }}}
-{{{#!sql
-SELECT book.bookid, book.CoverImage, book.Title, book.Genre, book.PublishedYear, author.FirstName, author.LastName
-                            FROM Book
-                            INNER JOIN Book_Author ON Book.BookID = Book_Author.BookID
-                            INNER JOIN Author ON Book_Author.AuthorID = Author.AuthorID WHERE book.PublishedYear BETWEEN $query_from AND $query_to;
 
-}}}
 
 
@@ -27 +21 @@
 [[Image(BT-12.png)]]
 {{{#!sql
-SELECT MIN(PublishedYear) as min_year, MAX(PublishedYear) as max_year FROM Book
+$year_query = "SELECT MIN(PublishedYear) as min_year, MAX(PublishedYear) as max_year FROM Book";
+$year_stmt = $conn->prepare($year_query);
+$year_stmt->execute();
+$year_range = $year_stmt->fetch(PDO::FETCH_ASSOC);
+
+
+$where_conditions = [];
+$params = [];
+
+$year_from = isset($_GET['year_from']) ? (int)$_GET['year_from'] : null;
+$year_to = isset($_GET['year_to']) ? (int)$_GET['year_to'] : null;
+
+$year_min = $year_range['min_year'];
+$year_max = $year_range['max_year'];
+
+$query_from = $year_from;
+$query_to = $year_to;
+
+if($year_from === null) {
+    $query_from = $year_min;
+}
+if($year_to === null) {
+    $query_to = $year_max;
+}
+
+SELECT book.bookid, book.CoverImage, book.Title, book.Genre, book.PublishedYear, author.FirstName, author.LastName
+                            FROM Book
+                            INNER JOIN Book_Author ON Book.BookID = Book_Author.BookID
+                            INNER JOIN Author ON Book_Author.AuthorID = Author.AuthorID WHERE book.PublishedYear BETWEEN $query_from AND $query_to
 }}}