fetchOne(
"SELECT * FROM " . TBL_CATEGORIES . " WHERE slug = ?",
[$category_slug]
);
if (!$category) {
redirect('/');
}
// Count total approved listings in this category
$total_listings = $db->count(
TBL_LISTINGS,
"category_id = ? AND status = 'approved'",
[$category['id']]
);
// Pagination
$items_per_page = 12;
$pagination = paginate($total_listings, $items_per_page, $page);
// Fetch listings for this page
$listings = $db->fetchAll(
"SELECT * FROM " . TBL_LISTINGS . "
WHERE category_id = ? AND status = 'approved'
ORDER BY is_featured DESC, created_at DESC
LIMIT ?, ?",
[$category['id'], $pagination['offset'], $items_per_page]
);
// Get all categories for sidebar
$all_categories = $db->fetchAll(
"SELECT id, name, slug, icon,
(SELECT COUNT(*) FROM " . TBL_LISTINGS . " WHERE category_id = " . TBL_CATEGORIES . ".id AND status = 'approved') as listing_count
FROM " . TBL_CATEGORIES . "
ORDER BY name ASC"
);
include '../includes/header.php';
?>
Business Found
0): ?>
Featured
fetchOne("SELECT name FROM " . TBL_DISTRICTS . " WHERE id = ?", [$listing['district_id']]);
echo escape($district['name'] ?? 'N/A');
?>
1): ?>
No Listings Found
There are currently no businesses in the "" category.