Dashboard - User | Cricket Exchange

query("SELECT * FROM users WHERE id=" . (int)$_SESSION['user_id'])->fetch_assoc(); $sa = $conn->query("SELECT * FROM sub_admins WHERE id=" . (int)$user['sub_admin_id'])->fetch_assoc(); $recent_txns = $conn->query("SELECT * FROM user_wallet_transactions WHERE user_id=" . (int)$_SESSION['user_id'] . " ORDER BY created_at DESC LIMIT 6")->fetch_all(MYSQLI_ASSOC); $pending_dep = $conn->query("SELECT COUNT(*) as c FROM user_deposit_requests WHERE user_id=" . (int)$_SESSION['user_id'] . " AND status='pending'")->fetch_assoc()['c']; $pending_wit = $conn->query("SELECT COUNT(*) as c FROM user_withdrawal_requests WHERE user_id=" . (int)$_SESSION['user_id'] . " AND status='pending'")->fetch_assoc()['c']; $total_deposited = $conn->query("SELECT SUM(amount) as t FROM user_deposit_requests WHERE user_id=" . (int)$_SESSION['user_id'] . " AND status='approved'")->fetch_assoc()['t'] ?? 0; $total_withdrawn = $conn->query("SELECT SUM(amount) as t FROM user_withdrawal_requests WHERE user_id=" . (int)$_SESSION['user_id'] . " AND status='approved'")->fetch_assoc()['t'] ?? 0; ?> Dashboard - User | Cricket Exchange