prepare($query); $totalStmt->execute($params); $totalRows = $totalStmt->rowCount(); $totalPages = ceil($totalRows / $limit); // Final query with limit $query .= " LIMIT $limit OFFSET $offset"; $stmt = $db->prepare($query); $stmt->execute($params); $cars = $stmt->fetchAll(); // Get unique brands for filter $brandsStmt = $db->query("SELECT DISTINCT brand FROM cars WHERE is_deleted = 0 ORDER BY brand"); $allBrands = $brandsStmt->fetchAll(PDO::FETCH_COLUMN); ?>

Premium Marketplace

Browse our curated collection of luxury vehicles from verified sellers across the region.

Clear

No vehicles found matching your criteria.

Reset All Filters
HOT DEAL SOLD date('Y-m-d H:i:s', strtotime('-7 days'))): ?> NEW LISTING prepare("SELECT image_path FROM car_images WHERE car_id = ? AND is_main = 1 LIMIT 1"); $imgStmt->execute([$car['id']]); $mainImg = $imgStmt->fetchColumn(); $displayImg = $mainImg ?: 'assets/images/pexels/car_1.jpg'; ?> <?php echo htmlspecialchars($car['title']); ?>
$

📍 🛣️ km
1): ?>