prepare("SELECT * FROM users WHERE id = ?"); $uStmt->execute([$user_id]); $userData = $uStmt->fetch(); // Fallback if user data fetch fails if (!$userData) { $userData = ['wallet_balance' => 0, 'referral_code' => 'ERROR']; } // 3. Fetch Recent Orders $stmt = $pdo->prepare("SELECT * FROM orders WHERE user_id = ? ORDER BY created_at DESC LIMIT 5"); $stmt->execute([$user_id]); $orders = $stmt->fetchAll(PDO::FETCH_ASSOC); // 4. Fetch Open Tickets Count $ticket_count = $pdo->query("SELECT COUNT(*) FROM tickets WHERE user_id=$user_id AND status='open'")->fetchColumn(); include 'includes/header.php'; ?>

Hello, 👋

Manage your orders and subscriptions.

Logout

My Wallet Balance

Add Funds ₹ Available to Spend

Want free software?
Invite friends & earn ₹50 per signup!

Refer Now

New Order

Browse catalog

Wishlist

Saved items

Support

0 ? "$ticket_count Active" : "No issues"; ?>

Settings

Edit Profile

Recent Activity

0): ?>

Order #

•

prepare(" SELECT p.name, v.name as variant FROM order_items oi JOIN products p ON oi.product_id = p.id JOIN product_variants v ON oi.variant_id = v.id WHERE oi.order_id = ? "); $iStmt->execute([$order['id']]); $items = $iStmt->fetchAll(); foreach($items as $item) { echo "

" . htmlspecialchars($item['name']) . " (" . htmlspecialchars($item['variant']) . ")

"; } ?>

Access Details:

Invoice Invoice Pending Report Issue

You haven't purchased anything yet.

Start Shopping