prepare($sql_get_distinct_genres);
$stmt->execute();
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$distinct_genres[] = $row['genre'];
}
$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;
}
if(isset($_GET['genres'])) {
$genres_filters = $_GET['genres'];
$placeholders = str_repeat('?,', count($genres_filters) - 1) . '?';
$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.genre IN ($placeholders) AND book.PublishedYear BETWEEN ? AND ?;");
$stmt->execute(array_merge($genres_filters, [$query_from, $query_to]));
}
else {
$genres_filters = [];
$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();
}
if ($year_from !== null) {
$where_conditions[] = "book.publishedyear >= ?";
$params[] = $year_from;
}
if ($year_to !== null) {
$where_conditions[] = "book.publishedyear <= ?";
$params[] = $year_to;
}
$all_books = [];
while($row = $stmt->fetch(PDO::FETCH_ASSOC)) {
$all_books[] = $row;
}
// CART
if(isset($_GET['submit']) && isset($_GET['bookid'])){
if(!isset($_SESSION['userid'])) {
header("Location: ./SignLog.php");
die();
}
$sql = "SELECT * FROM member WHERE memberid = :userid";
$stmt = $conn->prepare($sql);
$stmt->bindParam(':userid', $_SESSION['userid'], PDO::PARAM_INT);
$stmt->execute();
$row = $stmt->fetch(PDO::FETCH_ASSOC);
$current_date = date('Y-m-d');
if($stmt->rowCount() <= 0 || $row['expired_date'] < $current_date || $row['membership_status'] != 'Active') {
// ne si member ili ti istekol ili ti e neaktiven ili suspendiran
header("Location: ./Profile.php");
die();
}
if ($_GET['submit'] == 'add-to-cart') {
try {
$check_stmt = $conn->prepare("
SELECT Cart.*, member.*, book.* FROM CART
INNER JOIN Member ON Cart.memberid = member.memberid
INNER JOIN Book ON Cart.bookid = Book.bookid
WHERE Book.bookid = :bookid AND member.memberid = {$row['memberid']};
");
$check_stmt->bindParam(':bookid', $_GET['bookid'], PDO::PARAM_INT);
$check_stmt->execute();
if($check_stmt->rowCount() > 0){
header("Location: ./Cart.php");
die();
}
else {
// INSERT INTO CART
$sql = $conn->prepare('INSERT INTO Cart (BookID, MemberID) VALUES (:book_id, :member_id)');
$sql->bindParam(':book_id', $_GET['bookid'], PDO::PARAM_INT);
$sql->bindParam(':member_id', $row['memberid'], PDO::PARAM_INT);
$sql->execute();
}
header("Location: ./Cart.php");
exit();
} catch (PDOException $e) {
error_log("Database error: " . $e->getMessage());
echo $e->getMessage();
echo "An error occurred while adding the book to your cart.";
exit();
}
}
header("Location: ./Cart.php");
}
?>
All Books