Changes between Version 9 and Version 10 of ImportantCase3

Timestamp:

01/11/25 15:10:43 (4 days ago)

Author:

222039

Comment:

--

ImportantCase3

@@ -38 +38 @@
 Повеќе книги
 [[Image(BT-DB-3.png)]]
+
+{{{#!sql
+//Similar Books
+    $stmt = $conn->prepare("SELECT book.bookid, coverimage, title, genre, firstname, 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 = :bookgenre AND book.bookid != :bookid LIMIT 5;
+    ");
+    $stmt->bindParam(':bookgenre', $book_genre, PDO::PARAM_STR);
+    $stmt->bindParam(':bookid', $bookid, PDO::PARAM_INT);
+    // Execute the query
+    $stmt->execute();
+    $similar_books = [];
+
+    while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
+      $similar_books[] = $row;
+    }
+
+    //More Author
+    $stmt = $conn->prepare("SELECT book.bookid, coverimage, title, genre, firstname, lastname 
+    FROM book
+    INNER JOIN book_author ON book.bookid = book_author.bookid
+    INNER JOIN author ON book_author.authorid = author.authorid
+    WHERE book_author.authorid IN (
+        SELECT book_author.authorid 
+        FROM book_author 
+        WHERE book_author.bookid = :bookid
+    ) AND book.bookid != :bookid
+    LIMIT 5;
+    ");
+    $stmt->bindParam(':bookid', $bookid, PDO::PARAM_INT);
+
+    // Execute the query
+    $stmt->execute();
+    $author_books = [];
+
+    while ($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
+        $author_books[] = $row;
+    }
+}}}