fetchAll('SELECT * FROM landing_pages WHERE slug = ? AND is_published = 1', [$slug]); if (empty($page) || !is_array($page) || !isset($page[0])) { // Page not found header('HTTP/1.0 404 Not Found'); require_once __DIR__ . '/../includes/header2.php'; echo '

'; echo '

Page Not Found

'; echo '

The page you are looking for does not exist.

'; echo 'Go to Homepage'; echo '

'; require_once __DIR__ . '/../includes/footer.php'; exit; } $page = $page[0]; // Validate that $page is an array if (!is_array($page)) { error_log('Categories page error: $page is not an array. Type: ' . gettype($page) . ', Value: ' . print_r($page, true)); header('HTTP/1.0 500 Internal Server Error'); require_once __DIR__ . '/../includes/header2.php'; echo '

'; echo '

Error

'; echo '

There was an error loading this page. Please try again later.

'; echo 'Go to Homepage'; echo '

'; require_once __DIR__ . '/../includes/footer.php'; exit; } // Increment view count $db->query('UPDATE landing_pages SET view_count = view_count + 1 WHERE id = ?', [$page['id']]); // Get FAQs for this page $faqs = []; if (isset($page['id'])) { $faqs = $db->fetchAll('SELECT * FROM landing_page_faqs WHERE landing_page_id = ? ORDER BY display_order ASC', [$page['id']]); } // Set SEO variables $page_title = $page['title']; $meta_description = $page['meta_description']; $meta_keywords = $page['meta_keywords']; $canonical_url = '/categories/' . $page['slug'] . '/'; // Set Open Graph data for social sharing $og_data = [ 'title' => $page['h1_title'], 'description' => $page['meta_description'], 'url' => 'https://searchmusicgear.com' . $canonical_url, 'image' => !empty($page['image_url']) ? 'https://searchmusicgear.com' . $page['image_url'] : 'https://searchmusicgear.com/assets/imgs/search-header.jpg', 'type' => 'website' ]; // Breadcrumbs $breadcrumbs = [ ['title' => 'Home', 'url' => '/'], ['title' => 'Browse', 'url' => '/categories/'], ['title' => $page['h1_title'] ?? $page['title'] ?? 'Category', 'url' => ''] ]; // Generate structured data $structured_data = generateBreadcrumbSchema($breadcrumbs); // Get search results for this query $search_query = $page['search_query'] ?? $page['title'] ?? ''; $search_url = '/search/?q=' . urlencode($search_query); // platforms=both is default // Fetch preview listings (6 items - 3 from each platform) // Use caching to avoid excessive API calls require_once __DIR__ . '/../lib/cache.php'; $cacheKey = 'category_preview_' . $page['slug']; $preview_listings = cache_remember($cacheKey, 1800, function() use ($search_query) { // 30 min cache $listings = []; try { // Fetch from Reverb (3 items) $reverbUrl = 'https://reverb.com/api/listings/all?query=' . urlencode($search_query) . '&per_page=3'; $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, $reverbUrl); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_FOLLOWLOCATION, true); curl_setopt($ch, CURLOPT_USERAGENT, 'Mozilla/5.0'); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_SSL_VERIFYHOST, false); curl_setopt($ch, CURLOPT_TIMEOUT, 5); $response = curl_exec($ch); $curlError = curl_error($ch); $httpCode = curl_getinfo($ch, CURLINFO_HTTP_CODE); curl_close($ch); // Debug logging error_log("Reverb API Call - HTTP Code: $httpCode, Query: $search_query"); if ($curlError) { error_log("Reverb API cURL Error: $curlError"); } if ($response) { $data = json_decode($response, true); error_log("Reverb API Response decoded, listings count: " . count($data['listings'] ?? [])); if (!empty($data['listings'])) { require_once __DIR__ . '/../config/affiliates.php'; foreach ($data['listings'] as $item) { // Get URL and add affiliate tracking $itemUrl = $item['_links']['web']['href'] ?? ''; $itemUrl = addReverbAffiliateTracking($itemUrl); $listings[] = [ 'id' => $item['id'] ?? '', 'listing_id' => $item['id'] ?? '', 'title' => $item['title'] ?? '', 'price' => '$' . number_format($item['price']['amount'] ?? 0, 2), 'image' => $item['_links']['photo']['href'] ?? '', 'url' => $itemUrl, 'platform' => 'Reverb', 'condition' => $item['condition']['display_name'] ?? '', 'make' => $item['make'] ?? '', 'model' => $item['model'] ?? '' ]; } } else { error_log("Reverb API: No listings found in response"); } } else { error_log("Reverb API: No response received"); } // Fetch from eBay (3 items) require_once __DIR__ . '/../api/ebay_api_client.php'; $ebayClient = new EbayApiClient( EBAY_CLIENT_ID, EBAY_CLIENT_SECRET ); $ebayResults = $ebayClient->findItems($search_query, [ 'per_page' => 3, 'page' => 1, 'category_id' => '619' // Musical Instruments ]); if (!empty($ebayResults['items'])) { require_once __DIR__ . '/../config/affiliates.php'; foreach ($ebayResults['items'] as $item) { $itemUrl = $item['viewItemURL'] ?? ''; $itemUrl = addAffiliateTracking($itemUrl, 'eBay'); $listings[] = [ 'id' => $item['itemId'] ?? '', 'listing_id' => $item['itemId'] ?? '', 'title' => $item['title'] ?? '', 'price' => '$' . number_format((float)($item['price']['amount'] ?? 0), 2), 'image' => $item['galleryURL'] ?? '', 'url' => $itemUrl, 'platform' => 'eBay', 'condition' => $item['condition'] ?? 'Used', 'make' => '', 'model' => '' ]; } } } catch (Exception $e) { error_log('Landing page preview error: ' . $e->getMessage()); } return $listings; }); require_once __DIR__ . '/../includes/header2.php'; ?>

' . htmlspecialchars($queryText) . '? You\'ve come to the right place. We search both eBay and Reverb to show you all available ' . htmlspecialchars($queryText) . ' in one place. Browse listings from both platforms, filter by price and condition, and find exactly what you\'re looking for.

Browse our complete selection of musical instruments and gear from trusted sellers on eBay and Reverb.'; } ?>

🔍 View All Listings

Real-time listings

eBay + Reverb

Price alerts