getConnection(); // Initialize user and transaction objects $user = new User($db); $transaction = new Transaction($db); // Get user data from session $username = $_SESSION['username']; // Default values if database operations fail $email = $_SESSION['email'] ?? 'unknown@example.com'; $tier = $_SESSION['tier'] ?? 'Basic'; $package = $_SESSION['package'] ?? 'NOVA'; $balance = $_SESSION['balance'] ?? 0; $total_deposits = $_SESSION['total_deposits'] ?? 0; $total_withdrawals = $_SESSION['total_withdrawals'] ?? 0; $rewards = $_SESSION['rewards'] ?? 0; $earnings = $total_deposits - $total_withdrawals; $transactions = []; // Try to get user details from database try { if ($user->getUserByUsername($username)) { // User exists in database $email = $user->email; $tier = $user->tier; $package = $user->package; $balance = $user->balance; $total_deposits = $user->total_deposits; $total_withdrawals = $user->total_withdrawals; $rewards = $user->rewards; $earnings = $total_deposits - $total_withdrawals; // Store updated values in session $_SESSION['email'] = $email; $_SESSION['tier'] = $tier; $_SESSION['package'] = $package; $_SESSION['balance'] = $balance; $_SESSION['total_deposits'] = $total_deposits; $_SESSION['total_withdrawals'] = $total_withdrawals; $_SESSION['rewards'] = $rewards; // Get transactions for the user $transactions_stmt = $transaction->getTransactionsByUserId($user->id, 20); if ($transactions_stmt) { $transactions = $transactions_stmt->fetchAll(PDO::FETCH_ASSOC); } } } catch (Exception $e) { // Database error - use session values instead error_log("Database error: " . $e->getMessage()); } ?> Japanese Motors — Transactions
Jmotors
💸

Transaction History

All your financial activities
All
Deposits
Withdrawals
Earnings
No transactions found
Sample Deposit
Today, 09:42 AM
+ KES 100
Sample Withdrawal
Yesterday, 3:15 PM
- KES 1,000