getConnection();
// Get wishlist items
$query = "SELECT w.*, u.name as user_name, u.phone,
p.name as product_name, p.price, p.image, p.stock_quantity
FROM wishlist w
JOIN users u ON w.user_id = u.id
JOIN products p ON w.product_id = p.id
ORDER BY w.created_at DESC";
$stmt = $db->prepare($query);
$stmt->execute();
$wishlist_items = $stmt->fetchAll(PDO::FETCH_ASSOC);
// Get most wanted products
$query = "SELECT p.id, p.name, p.price, p.image, p.stock_quantity,
COUNT(w.id) as wishlist_count
FROM products p
JOIN wishlist w ON p.id = w.product_id
GROUP BY p.id
ORDER BY wishlist_count DESC
LIMIT 10";
$stmt = $db->prepare($query);
$stmt->execute();
$top_products = $stmt->fetchAll(PDO::FETCH_ASSOC);
} catch (Exception $e) {
$error = "خطأ: " . $e->getMessage();
$wishlist_items = [];
$top_products = [];
}
?>
قائمة الأمنيات - Roz Skin