‰PNG  IHDRôxÔúsBIT|dˆ pHYsÄÄ•+tEXtSoftwarewww.inkscape.org›î<,àtEXtComment 'error', 'message' => 'Unauthorized']); exit(); } $user = GetMember1($_SESSION['Email']); if (!$user) { echo json_encode(['status' => 'error', 'message' => 'User not found']); exit(); } $userId = $user['ID']; $openTrades = []; $closedTrades = []; try { // 2. Query the trades table securely $stmt = $conn->prepare("SELECT id, commodity, trade_type, trade_amount, entry_price, close_price, pnl, status, created_at FROM trades WHERE user_id = ? ORDER BY created_at DESC"); if ($stmt) { $stmt->bind_param("i", $userId); $stmt->execute(); $result = $stmt->get_result(); // 3. Sort trades into Open and Closed arrays while ($row = $result->fetch_assoc()) { if ($row['status'] === 'OPEN') { $openTrades[] = $row; } else { $closedTrades[] = $row; } } $stmt->close(); // 4. Send the data back to the JavaScript echo json_encode([ 'status' => 'success', 'open_trades' => $openTrades, 'closed_trades' => $closedTrades ]); } else { echo json_encode(['status' => 'error', 'message' => 'Database query failed']); } } catch (Exception $e) { echo json_encode(['status' => 'error', 'message' => 'System error']); } ?>