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; ?> Dashboard - InvestUG

Dashboard

Current Time

Total Invested

Total Earnings

Wallet Balance

Referrals

Active referrals
Investment Packages
Starter Package $10 (20,000 UGX)
Daily returns: 2.5%
Growth Package $25 (60,000 UGX)
Daily returns: 3%
View All Packages
Recent Transactions
Date Type Amount Status
No transactions found