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']; // 'up' অথবা 'down'
$duration = $_POST['duration'];
// সর্বনিম্ন ট্রেড $1.0 চেক
if ($amount >= 1.0) {
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, status) VALUES (?, ?, ?, ?, 'Pending')");
$stmt->execute([$user_id, $amount, $direction, $duration]);
$message = "Trade Placed: ".strtoupper($direction)."!
";
$current_balance = $new_balance;
} else {
$message = "Insufficient Balance!
";
}
} else {
$message = "Minimum investment is $1.0
";
}
}
?>
Ziber - Professional Trading
Active & Recent Trades
Live Updates
prepare("SELECT * FROM trades WHERE user_id = ? ORDER BY id DESC LIMIT 6");
$stmt->execute([$user_id]);
while ($row = $stmt->fetch(PDO::FETCH_ASSOC)):
$is_up = ($row['direction'] == 'up');
$status = $row['status'];
// ডাইনামিক স্টাইল
$bg_color = $is_up ? 'bg-green-500/10' : 'bg-red-500/10';
$icon_color = $is_up ? 'text-green-500' : 'text-red-500';
$status_class = ($status == 'Pending') ? 'bg-yellow-500/20 text-yellow-500' :
(($status == 'Win') ? 'bg-green-500/20 text-green-500' : 'bg-red-500/20 text-red-500');
?>
rowCount() == 0): ?>