Recharge

❌ No user email provided"; exit; } $stmt = $conn->prepare("SELECT * FROM users WHERE email = ?"); $stmt->execute([$email]); $user = $stmt->fetch(PDO::FETCH_ASSOC); if (!$user) { echo "

❌ User not found

"; exit; } $balance = (float)($user['balance'] ?? 0); // ==================== Total Recharged ==================== $totalRecharged = 0; try { $r = $conn->prepare("SELECT COALESCE(SUM(amount), 0) FROM recharge_history WHERE email = ? AND status = 'approved'"); $r->execute([$email]); $totalRecharged = (float)$r->fetchColumn(); } catch (Exception $e) {} // ==================== LOAD DEPOSIT METHOD FROM DB ==================== $method = null; try { $mStmt = $conn->query("SELECT * FROM deposit_methods WHERE is_active = 1 AND method_key = 'binance' ORDER BY sort_order ASC LIMIT 1"); $method = $mStmt->fetch(PDO::FETCH_ASSOC); } catch (Exception $e) {} // Fallback if table missing or empty if (!$method) { $method = [ 'method_key' => 'binance', 'method_name' => 'Binance Pay', 'method_logo' => 'https://upload.wikimedia.org/wikipedia/commons/thumb/1/12/Binance_logo.svg/2560px-Binance_logo.svg.png', 'method_logo_type' => 'url', 'binance_id' => '123456789', 'min_amount' => 10, 'max_amount' => 100000, 'instructions' => 'Send USDT via Binance Pay to the ID above.' ]; } // ==================== Min / Max from SQL ==================== $minAmount = (float)($method['min_amount'] ?? 10); $maxAmount = (float)($method['max_amount'] ?? 100000); $methodName = htmlspecialchars($method['method_name'] ?? 'Binance Pay'); ?> Recharge

Available

Total Recharged