Приказ на сите книги

Актери

• Најавен корисник

Чекор 1

Избор на жанра/и

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.genre IN ($placeholders) AND book.PublishedYear BETWEEN $query_from AND $query_to;"

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;

Чекор 2

Избор на временски период

SELECT MIN(PublishedYear) as min_year, MAX(PublishedYear) as max_year FROM Book

Чекор 3

Сортирање на книгите по избор, и селектирање на "Apply Filters"

Чекор 4

Резултат