prepare("SELECT * FROM users WHERE id = ?"); $stmt->execute([$user_id]); $user = $stmt->fetch(); // Fetch user investments $stmt = $pdo->prepare("SELECT SUM(amount) as total_invested FROM investments WHERE user_id = ? AND status = 'active'"); $stmt->execute([$user_id]); $total_invested = $stmt->fetchColumn() ?: 0; // Fetch total earnings $stmt = $pdo->prepare("SELECT SUM(amount) as total_earnings FROM earnings WHERE user_id = ?"); $stmt->execute([$user_id]); $total_earnings = $stmt->fetchColumn() ?: 0; // Fetch wallet balance $stmt = $pdo->prepare("SELECT balance FROM wallets WHERE user_id = ?"); $stmt->execute([$user_id]); $wallet_balance = $stmt->fetchColumn() ?: 0; // Fetch referral count $stmt = $pdo->prepare("SELECT COUNT(*) as referral_count FROM users WHERE referred_by = ?"); $stmt->execute([$user_id]); $referral_count = $stmt->fetchColumn() ?: 0; ?>
Current Time
Date | Type | Amount | Status |
---|---|---|---|
No transactions found |