Search — Market For The Blind

All Wanted Ads

0 wanted ads

No wanted ads found. View all wanted ads or

require_once ROOT_PATH . '/includes/header.php'; if ($logged_in) { enforce_rating_lock(false); } $q = trim($_GET['q'] ?? ''); $cat_filter = isset($_GET['category']) ? (int)$_GET['category'] : 0; $results = []; // Always run the query — show all listings by default, // filtered if a keyword or category was provided $sql = 'SELECT DISTINCT l.id, l.title, l.price, l.condition_label, DATEDIFF(l.expires_at, NOW()) AS days_remaining, u.username AS seller FROM listings l JOIN users u ON u.id = l.seller_id LEFT JOIN listing_categories lc ON lc.listing_id = l.id WHERE l.status = "active" AND l.expires_at > NOW()'; $params = []; if ($q !== '') { $sql .= ' AND (l.title LIKE ? OR l.description LIKE ? OR l.keywords LIKE ?)'; $like = '%' . $q . '%'; $params = [$like, $like, $like]; } if ($cat_filter > 0) { $sql .= ' AND lc.category_id = ?'; $params[] = $cat_filter; } $sql .= ' ORDER BY l.approved_at DESC LIMIT 100'; $stmt = $db->prepare($sql); $stmt->execute($params); $results = $stmt->fetchAll(); $categories = $db->query( 'SELECT id, name FROM categories WHERE active = 1 ORDER BY display_order' )->fetchAll(); $cat_name = ''; if ($cat_filter > 0) { foreach ($categories as $c) { if ((int)$c['id'] === $cat_filter) { $cat_name = $c['name']; break; } } } $is_filtered = $q !== '' || $cat_filter > 0; ?>

All Active Listings

0 active listings

There are no active listings at this time. Check back soon or apply for an account to post your own.