prepare(" SELECT c.*, ci.image_path FROM cars c LEFT JOIN car_images ci ON c.id = ci.car_id AND ci.is_main = 1 WHERE c.user_id = ? AND c.deleted_at IS NULL ORDER BY c.created_at DESC "); $stmt->execute([$user_id]); $my_listings = $stmt->fetchAll(); // Fetch user's purchase requests $stmt = $pdo->prepare(" SELECT p.*, c.brand, c.model, c.year, c.price, ci.image_path FROM purchases p JOIN cars c ON p.car_id = c.id LEFT JOIN car_images ci ON c.id = ci.car_id AND ci.is_main = 1 WHERE p.user_id = ? ORDER BY p.created_at DESC "); $stmt->execute([$user_id]); $my_purchases = $stmt->fetchAll(); ?>

User Dashboard

Manage your vehicle listings and track your purchase requests.

List New Vehicle

🚗 My Vehicle Listings

You haven't listed any vehicles yet.

Start Selling Today
SOLD

•

$ Edit Details →

💰 My Purchase Requests

You haven't made any purchase requests yet.

Browse Marketplace
Vehicle Price Bank ID Status Action
Model
 $ View Receipt Under Review