User History - <?php echo htmlspecialchars($user['name']); ?>

prepare("SELECT * FROM users WHERE id = ?"); $uStmt->execute([$user_id]); $user = $uStmt->fetch(); if (!$user) { echo "User not found."; exit(); } // 2. Fetch All Orders & Items for this User $orders = $pdo->prepare(" SELECT o.*, GROUP_CONCAT(p.name SEPARATOR ', ') as product_names FROM orders o LEFT JOIN order_items oi ON o.id = oi.order_id LEFT JOIN products p ON oi.product_id = p.id WHERE o.user_id = ? GROUP BY o.id ORDER BY o.created_at DESC "); $orders->execute([$user_id]); $order_history = $orders->fetchAll(); // 3. Calculate Stats $total_spent = 0; $completed_orders = 0; foreach($order_history as $o) { if($o['status'] == 'completed') { $total_spent += $o['total_amount']; $completed_orders++; } } ?> User History - <?php echo htmlspecialchars($user['name']); ?>

← Back to Users List

Joined:

Chat with Customer

₹

Lifetime Spent

Paid Orders

Order History

This user has not placed any orders yet.

Order ID	Products Bought	Amount	Payment	Status	Date	Action
#	Item deleted'; ?>	₹				View Order