query("SELECT * FROM categories")->fetchAll(); // Handle search and filters $search = $_GET['search'] ?? ''; $category_id = $_GET['category'] ?? ''; $query = "SELECT p.*, c.name as category_name FROM products p LEFT JOIN categories c ON p.category_id = c.id WHERE 1=1"; $params = []; if (!empty($search)) { $query .= " AND (p.name LIKE ? OR p.description LIKE ?)"; $params[] = "%$search%"; $params[] = "%$search%"; } if (!empty($category_id)) { $query .= " AND p.category_id = ?"; $params[] = $category_id; } $query .= " ORDER BY p.id DESC"; $stmt = $pdo->prepare($query); $stmt->execute($params); $products = $stmt->fetchAll(); ?>

Korean Chic,
Curated for You

Welcome to Aora Closet. Explore premium Korean style fashion clothing with points collection system, and free shipping on all orders!

Shop Now
Korean Fashion Trend
Browse Categories
âœĻ

All Items

Recommended for You Clear Filters ×
🔍

No Outfits Found

Try adjusting your search keywords or filter category.

<?php echo htmlspecialchars($product['name']); ?>

āļŋ 0): ?> View Details Out of Stock