0) { $categories = db_all('SELECT slug, name, icon, image_path FROM categories ORDER BY sort_order, name LIMIT 100'); $db_rows = db_all('SELECT * FROM listings WHERE published = 1'); $listings = array_map(fn($l) => [ 'id' => (int)$l['id'], 'slug' => $l['slug'], 'name' => $l['name'], 'category' => $l['category_slug'], 'tier' => $l['tier'], 'featured' => (int)$l['featured'] === 1, 'description' => $l['description'], 'address' => $l['address'], 'logo_path' => $l['logo_path'] ?? null, ], $db_rows); } else { $categories = require __DIR__ . '/data/categories.php'; $listings = require __DIR__ . '/data/listings.php'; } // Curated sets for each section $diamond_members = array_values(array_filter($listings, fn($l) => $l['tier'] === 'Diamond')); $platinum_members = array_values(array_filter($listings, fn($l) => $l['tier'] === 'Platinum')); // Top 3 listings — based on real pageviews in the last 30 days // Falls back to featured listings if metrics table is empty or doesn't exist $top_3 = []; try { $top_rows = db_all( "SELECT l.*, COUNT(pv.id) AS view_count FROM listings l INNER JOIN metrics_pageviews pv ON pv.listing_id = l.id AND pv.viewed_at >= DATE_SUB(NOW(), INTERVAL 30 DAY) WHERE l.published = 1 GROUP BY l.id ORDER BY view_count DESC, l.name LIMIT 3" ); foreach ($top_rows as $r) { $top_3[] = [ 'id' => (int)$r['id'], 'slug' => $r['slug'], 'name' => $r['name'], 'tier' => $r['tier'], 'description' => $r['description'], 'address' => $r['address'], 'logo_path' => $r['logo_path'] ?? null, 'view_count' => (int)$r['view_count'], ]; } } catch (Throwable $e) { /* metrics table not ready */ } // If no view data yet, fall back to featured listings if (empty($top_3)) { $top_3 = array_slice(array_values(array_filter($listings, fn($l) => !empty($l['featured']))), 0, 3); } $featured_categories = array_slice($categories, 0, 4); require 'includes/header.php'; ?>
Buy Local Lowveld

#LekkerLocalLowveld

Become a Member

By supporting local you encourage local entrepreneurship.

Diamond Package Members

Support our Diamond Package Members

<?= htmlspecialchars($d['name']) ?>
Diamond

Platinum Package Members

Support our Platinum Package Members

<?= htmlspecialchars($p['name']) ?>
Platinum

"Buy Local Lowveld believes in creating a sustainable city through the promotion and support of locally owned businesses."

Learn More

We aim to STIMULATE the Lowveld economy by encouraging shoppers to support and spend their money LOCALLY.

Our FOCUS is on the people, businesses and families that have built our community, created jobs and invested their time, resources and love into creating a better region FOR US ALL.

We stand for excellence and aim to spread the spirit of UBUNTU IN THE LOWVELD COMMUNITY.

Buy Local Lowveld members

Our Directory

Find the best local businesses by category

>
View Our Directory

Top 3 Local Listings

Top Performing Listings of the Month

<?= htmlspecialchars($l['name']) ?>

Interested in finding out more?

We'd love to chat. Whether you're a Lowveld business thinking about joining, a shopper keen to support local, or a sponsor looking to back our work — get in touch and we'll come back to you within one business day.

I am interested in finding out more.
Please can someone get in touch with me.

Get in Touch