Dashboard

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

Current Time

Total Invested

Total Earnings

Wallet Balance

Referrals

Active referrals

Quick Actions

Make a Deposit Withdraw Funds Share Referral Link

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

View All Transactions