setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION); // ট্রেড টেবিল তৈরি $db->exec("CREATE TABLE IF NOT EXISTS trades ( id INTEGER PRIMARY KEY AUTOINCREMENT, user_id INTEGER, amount REAL, direction TEXT, duration TEXT, status TEXT DEFAULT 'Pending', result_amount REAL DEFAULT 0, created_at DATETIME DEFAULT CURRENT_TIMESTAMP )"); } catch (PDOException $e) { die("Database Error: " . $e->getMessage()); } $user_id = $_SESSION['user_id']; $message = ""; // ইউজারের বর্তমান ব্যালেন্স চেক $stmt = $db->prepare("SELECT main_balance FROM users WHERE id = ?"); $stmt->execute([$user_id]); $current_balance = $stmt->fetchColumn(); // ট্রেড প্লেস করার লজিক if (isset($_POST['place_trade'])) { $amount = (float)$_POST['trade_amount']; $direction = $_POST['direction']; $duration = $_POST['duration']; // সর্বনিম্ন ট্রেড $0.5 চেক if ($amount >= 0.5) { if ($amount <= $current_balance) { $new_balance = $current_balance - $amount; $update = $db->prepare("UPDATE users SET main_balance = ? WHERE id = ?"); $update->execute([$new_balance, $user_id]); $stmt = $db->prepare("INSERT INTO trades (user_id, amount, direction, duration) VALUES (?, ?, ?, ?)"); $stmt->execute([$user_id, $amount, $direction, $duration]); $message = "
Trade Executed Successfully!
"; $current_balance = $new_balance; } else { $message = "
Insufficient Balance!
"; } } else { $message = "
Minimum trade amount is $0.5
"; } } ?> Ziber - Live Trading Terminal
ZIBER

Balance

$

Return (Est.)

90% Payout

Recent History

prepare("SELECT * FROM trades WHERE user_id = ? ORDER BY id DESC LIMIT 5"); $stmt->execute([$user_id]); while ($row = $stmt->fetch(PDO::FETCH_ASSOC)): $is_up = $row['direction'] == 'up'; $status = $row['status']; $status_color = ($status == 'Pending') ? 'text-yellow-500' : (($status == 'Win') ? 'text-[#2fb474]' : 'text-red-500'); ?>

$