Changes between Version 6 and Version 7 of ImportantCase1

Timestamp:

02/24/25 15:59:47 (6 weeks ago)

Author:

222039

Comment:

--

ImportantCase1

@@ -11 +11 @@
 [[Image(BT-5.png.png)]]
 {{{#!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 :year_from AND :year_to
-
-
+$stmt = $conn->prepare("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 :year_from AND :year_to;
+");
+$stmt->bindParam(":year_from", $query_from, PDO::PARAM_STR);
+$stmt->bindParam(":year_to", $query_to, PDO::PARAM_STR);
+$stmt->execute();
 }}}