<? $pageID = 'books'; ?>
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/db-connection.php'; ?>
<?
// Get filters from query parameters
$current_page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$genre_filters = isset($_GET['genre']) && is_array($_GET['genre']) ? $_GET['genre'] : [];
$match_all = isset($_GET['match_type']) ? $_GET['match_type'] === 'all' : false; // Default to "match any"
// Initialize fiction filter variables
$fiction_filter = null;
$fiction_filters = [];
// Initialize title filter variable
$title_filter = isset($_GET['title']) ? trim(htmlspecialchars($_GET['title'])) : '';
// Handle fiction filter based on match type
if ($match_all) {
// For "match all", treat as radio button (single selection)
$fiction_filter = isset($_GET['fiction']) ? ($_GET['fiction'] === '1' ? 1 : ($_GET['fiction'] === '0' ? 0 : null)) : null;
} else {
// For "match any", treat as checkboxes (multiple selection)
$fiction_filters = isset($_GET['fiction']) && is_array($_GET['fiction']) ? $_GET['fiction'] : [];
}
// Sanitize genre filters
$genre_filters = array_map('htmlspecialchars', $genre_filters);
$items_per_page = 20;
$offset = ($current_page - 1) * $items_per_page;
// Get total books count and filtered books
$pdo = getDbConnection();
$fiction_count = $pdo->query("SELECT COUNT(*) FROM books WHERE is_fiction = 1")->fetchColumn();
$non_fiction_count = $pdo->query("SELECT COUNT(*) FROM books WHERE is_fiction = 0")->fetchColumn();
// Build the query with filters
$query = 'SELECT DISTINCT b.id, b.name, b.slug, b.is_fiction
FROM books b';
$params = []; // Initialize params array
// Handle genre filters based on match type
if (!empty($genre_filters)) {
if ($match_all) {
// Match ALL genres (using JOINs)
foreach ($genre_filters as $index => $genre) {
$join_alias = "bbg{$index}";
$bg_alias = "bg{$index}";
$query .= " JOIN book_book_genre {$join_alias} ON b.id = {$join_alias}.book_id
JOIN book_genres {$bg_alias} ON {$join_alias}.book_genre_id = {$bg_alias}.id
AND {$bg_alias}.slug = ?";
$params[] = $genre;
}
} else {
// Match ANY genres (using EXISTS)
$query .= " JOIN book_book_genre bbg ON b.id = bbg.book_id
JOIN book_genres bg ON bbg.book_genre_id = bg.id
AND bg.slug IN (" . implode(',', array_fill(0, count($genre_filters), '?')) . ")";
$params = array_merge($params, $genre_filters);
}
}
$query .= ' WHERE 1=1';
// Handle fiction filter based on match type
if ($match_all && $fiction_filter !== null) {
$query .= ' AND b.is_fiction = ?';
$params[] = $fiction_filter;
} elseif (!$match_all && !empty($fiction_filters)) {
$query .= ' AND b.is_fiction IN (' . implode(',', array_fill(0, count($fiction_filters), '?')) . ')';
$params = array_merge($params, array_map('intval', $fiction_filters));
}
// Handle title filter
if (!empty($title_filter)) {
$title_words = array_filter(array_map('trim', explode(' ', $title_filter)));
if (!empty($title_words)) {
$title_conditions = [];
foreach ($title_words as $word) {
$title_conditions[] = 'LOWER(TRIM(b.name)) LIKE LOWER(?)';
$params[] = '%' . $word . '%';
}
$query .= ' AND (' . implode(' OR ', $title_conditions) . ')';
}
}
// Get total count
$count_query = str_replace('SELECT DISTINCT b.id, b.name, b.slug, b.is_fiction', 'SELECT COUNT(DISTINCT b.id)', $query);
$stmt = $pdo->prepare($count_query);
$stmt->execute($params);
$total_books = $stmt->fetchColumn();
$total_pages = ceil($total_books / $items_per_page);
// Get books for current page
$query .= ' ORDER BY b.name ASC LIMIT ? OFFSET ?';
$params[] = $items_per_page;
$params[] = $offset;
$stmt = $pdo->prepare($query);
$stmt->execute($params);
$books = $stmt->fetchAll(PDO::FETCH_ASSOC);
$query = "SELECT bg.name, bg.slug, COUNT(DISTINCT bbg.book_id) as book_count
FROM book_genres bg
LEFT JOIN book_book_genre bbg ON bg.id = bbg.book_genre_id
GROUP BY bg.id, bg.name, bg.slug
ORDER BY bg.name ASC";
$genres = $pdo->query($query)->fetchAll(PDO::FETCH_ASSOC);
// Function to build pagination URL with current filters
function buildPaginationUrl($page) {
$params = $_GET;
$params['page'] = $page;
return '?' . http_build_query($params);
}
// Check if there are active filters
$has_active_filters = $match_all || $fiction_filter !== null || !empty($fiction_filters) || !empty($genre_filters) || !empty($title_filter);
// Function to get genre names from slugs
function getGenreNames($slugs, $genres) {
$names = [];
foreach ($slugs as $slug) {
foreach ($genres as $genre) {
if ($genre['slug'] === $slug) {
$names[] = $genre['name'];
break;
}
}
}
return $names;
}
// Build filter summary text
$filter_summary = [];
if ($match_all || !$match_all) {
$filter_summary[] = 'Match ' . ($match_all ? 'ALL' : 'ANY') . ' criteria';
}
if ($match_all && $fiction_filter !== null) {
$filter_summary[] = $fiction_filter ? 'Fiction' : 'Non-Fiction';
} elseif (!$match_all && !empty($fiction_filters)) {
$fiction_labels = [];
foreach ($fiction_filters as $f) {
$fiction_labels[] = $f === '1' ? 'Fiction' : 'Non-Fiction';
}
$filter_summary = array_merge($filter_summary, $fiction_labels);
}
if (!empty($genre_filters)) {
$genre_names = getGenreNames($genre_filters, $genres);
$filter_summary = array_merge($filter_summary, $genre_names);
}
if (!empty($title_filter)) {
$filter_summary[] = 'Title contains "' . $title_filter . '"';
}
?>
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/global.php'; ?>
<!doctype html>
<html lang=en>
<head>
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/analytics.php'; ?>
<meta charset=utf-8>
<meta name=viewport content="width=device-width, initial-scale=1">
<? # START - Head code ?>
<title>Books - AspireBookClub.com<? echo $current_page > 1 ? " - Page $current_page" : ""; ?></title>
<meta name=description content="List of popular books that people have read.">
<meta property=og:title content="📚 Books - AspireBookClub.com <? echo $current_page > 1 ? " - Page $current_page" : ""; ?>">
<meta property=og:description content="AspireBookClub.com get inspired by books that people have read.">
<meta property=og:url content="https://aspirebookclub.com">
<meta property=og:site_name content=AspireBookClub.com>
<meta property=og:type content=website>
<meta property=og:image content="https://aspirebookclub.com/images/books.png">
<? # END - Head code ?>
<meta name=robots content="index, follow">
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/head-code.php'; ?>
</head>
<body class=bg-blue-50>
<div x-data="{ showNav: false }" class="max-w-[1250px] mx-auto">
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/header.php'; ?>
<div id=wrap class="grid grid-cols-12">
<? include $_SERVER['DOCUMENT_ROOT'] . '/../includes/navigation.php'; ?>
<main class="bg-white p-6 w-full col-span-12 shadow-[10px_0_15px_-3px_rgba(0,0,0,0.1)] flex flex-col">
<? # include $_SERVER['DOCUMENT_ROOT'] . '/../includes/ad-abc-res-top.php'; ?>
<nav aria-label=Breadcrumbs class="order-2 md:order-1 mt-7 md:mt-0">
<ul class="text-gray-600 lg:mb-3">
<? # START - Breadcrumb code ?>
<li class="mb-3 inline-block pl-2 before:absolute before:top-[0em] mr-1 after:content-['\203A'] after:ml-1"><a class=hover:text-blue-600 href="https://aspirebookclub.com">Aspire Book Club</a></li>
<li class="mb-3 inline-block pl-2 text-gray-400">Books</li>
<? # END - Breadcrumb code ?>
</ul>
</nav>
<div class="order-1 md:order-2 md:pl-3 md:pr-3">
<? # START - Main content ?>
<h1>📚 Books</h1>
<!-- Filters -->
<form method=get class="mb-8 bg-gray-50 rounded-lg border-gray-300 border" x-data="{
    isOpen: false}">
<div class="p-4 ">
<div class="flex items-center justify-between cursor-pointer" @click="isOpen = !isOpen">
<div class="flex items-center gap-2">
<span class=font-medium>Filter</span>
<template x-if="!isOpen && false">
<div class="text-sm text-gray-600">
</div>
</template>
</div>
<svg class="w-5 h-5 transition-transform" :class="{ 'rotate-180': !isOpen }" xmlns="https://www.w3.org/2000/svg" fill=none viewBox="0 0 24 24" stroke=currentColor>
<path stroke-linecap=round stroke-linejoin=round stroke-width=2 d="M19 9l-7 7-7-7"/>
</svg>
</div>
</div>
<div class="space-y-4 p-4 pt-0" x-show=isOpen x-transition>
<!-- Match Type Selection -->
<div class=space-y-2>
<div class="flex gap-4">
<label class="inline-flex items-baseline">
<input type=radio name=match_type value=any checked class="form-radio text-blue-600" onchange="updateBookTypeFilters()">
<span class=ml-2>Match ANY criteria</span>
</label>
<label class="inline-flex items-baseline">
<input type=radio name=match_type value=all class="form-radio text-blue-600" onchange="updateBookTypeFilters()">
<span class=ml-2>Match ALL criteria</span>
</label>
</div>
</div>
<!-- Fiction/Non-fiction filter -->
<div class=space-y-2 id=bookTypeContainer>
<div class="flex gap-4" id=bookTypeFilters>
<!-- Checkboxes for "Match ANY" -->
<label class="inline-flex items-baseline">
<input type="checkbox" name="fiction[]" value="1"