prepare("SELECT * FROM users WHERE id = ?"); $stmt->execute([$user_id]); $user = $stmt->fetch(); // Fetch Stats $total_orders = $pdo->prepare("SELECT COUNT(*) FROM orders WHERE user_id = ? AND status='success'"); $total_orders->execute([$user_id]); $orders_count = $total_orders->fetchColumn(); $total_spent = $pdo->prepare("SELECT SUM(amount) FROM orders WHERE user_id = ? AND status='success'"); $total_spent->execute([$user_id]); $spent_amount = $total_spent->fetchColumn() ?: 0; ?>
Dashboard Overview
Total Purchases
₹
Total Spent
Welcome back,
! You can access your purchased files from the 'My Downloads' tab.