0) { $row = db_row('SELECT * FROM listings WHERE id = :id AND published = 1', ['id' => $id]); if (!$row) { header('Location: directory.php'); exit; } // Load all categories this listing belongs to $listing_cats = []; try { $listing_cats = db_all( 'SELECT lc.category_slug AS slug, c.name, lc.is_primary FROM listing_categories lc LEFT JOIN categories c ON c.slug = lc.category_slug WHERE lc.listing_id = :id', ['id' => $id] ); } catch (Throwable $e) { /* junction not migrated */ } if (empty($listing_cats) && !empty($row['category_slug'])) { $listing_cats = [['slug' => $row['category_slug'], 'name' => $row['category_slug'], 'is_primary' => 1]]; } $listing = [ 'id' => (int)$row['id'], 'slug' => $row['slug'], 'name' => $row['name'], 'category' => $row['category_slug'], 'categories' => $listing_cats, 'tier' => $row['tier'], 'description' => $row['description'], 'tagline' => $row['tagline'] ?? '', 'phone' => $row['phone'], 'email' => $row['email'], 'website' => $row['website'], 'address' => $row['address'], 'logo_path' => $row['logo_path'] ?? null, 'banner_path' => $row['banner_path'] ?? null, ]; $categories = db_all('SELECT slug, name FROM categories'); } else { $listings = require __DIR__ . '/data/listings.php'; $categories = require __DIR__ . '/data/categories.php'; $listing = null; foreach ($listings as $l) { if ((int)$l['id'] === $id) { $listing = $l; break; } } if (!$listing) { header('Location: directory.php'); exit; } if (empty($listing['categories'])) $listing['categories'] = []; } $cat_lookup = []; foreach ($categories as $c) { $cat_lookup[$c['slug']] = $c; } $cat = $cat_lookup[$listing['category']] ?? null; $page_title = $listing['name']; $page_description = $listing['description']; $tier_class = 'tier-' . strtolower($listing['tier']); // Track this listing view (overrides the header's generic pageview tracker // since we want to associate it with the specific listing_id) require_once __DIR__ . '/includes/metrics.php'; metrics_track_listing_view((int)$listing['id']); // Prevent the header include from double-counting this as a generic page view $GLOBALS['__metrics_tracked'] = true; require 'includes/header.php'; $banner = !empty($listing['banner_path']) ? $listing['banner_path'] : null; $logo = !empty($listing['logo_path']) ? $listing['logo_path'] : null; ?>
>
<?= htmlspecialchars($listing['name']) ?>

← Back to directory

Member

About

This listing is part of the Buy Local Lowveld directory. When you choose this member, your spend helps keep the Lowveld economy strong.