prepare("DELETE FROM users WHERE id = ?")->execute([$id]);
header("Location: users.php?msg=deleted");
exit();
}
// 2. FETCH USERS & STATS
$users = $pdo->query("
SELECT u.*,
COUNT(o.id) as order_count,
COALESCE(SUM(o.total_amount), 0) as total_spent
FROM users u
LEFT JOIN orders o ON u.id = o.user_id AND o.status = 'completed'
GROUP BY u.id
ORDER BY u.created_at DESC
")->fetchAll();
?>
Manage Users