Integrate Review in Book Detail

app/controller/book/BookDb.php

@@ -60,6 +60,27 @@
 
             return $book;
         }
+
+        function getReviewsDetailByBookId($book_id) {
+            $reviews = [];
+            $sql = 'SELECT * FROM review WHERE book_id = ?';
+            $stmt = $this->conn->prepare($sql);
+            $stmt->execute([$book_id]);
+
+            while ($row = $stmt->fetch()) {
+                $review_id = (int) $row["review_id"];
+                $user_id = (int) $row["user_id"];
+                $book_id = (int) $row["book_id"];
+                $content = $row["content"];
+                $rating = (float) $row["rating"];
+                
+                $username = getJwtData($_COOKIE["Authorization"])->username;
+
+                $review = new Review($review_id, $user_id, $book_id, $content, $rating, $username);
+                array_push($reviews, $review);
+            }
+            return $reviews;
+        }
     }
 
 ?>
\ No newline at end of file