getConnection(); $district_slug = sanitize($_GET['district'] ?? ''); if (!$district_slug) { header('Location: ../index.php'); exit(); } // Get district $stmt = $db->prepare("SELECT * FROM " . TBL_DISTRICTS . " WHERE slug = ?"); $stmt->execute([$district_slug]); $district = $stmt->fetch(); if (!$district) { header('Location: ../index.php'); exit(); } $page_title = ($district['meta_title'] ?? escape($district['name']) . ' | ' . SITE_NAME); $page_subtitle = $district['meta_description'] ?? 'Find businesses and services in ' . escape($district['name']); // Get listings $stmt = $db->query(" SELECT l.*, c.name as category_name FROM " . TBL_LISTINGS . " l JOIN " . TBL_CATEGORIES . " c ON l.category_id = c.id WHERE l.district_id = " . $district['id'] . " AND l.status = 'approved' ORDER BY l.is_featured DESC, l.created_at DESC "); $listings = $stmt->fetchAll(); // Get categories $stmt = $db->query(" SELECT DISTINCT c.* FROM " . TBL_CATEGORIES . " c JOIN " . TBL_LISTINGS . " l ON c.id = l.category_id WHERE l.district_id = " . $district['id'] . " AND l.status = 'approved' ORDER BY c.name "); $categories = $stmt->fetchAll(); ?>

0): ?>

Listings in ()

Browse all available businesses and services

View Details
No listings found in .