alert('订单不存在或您没有权限查看');history.back();"; exit; } // 获取订单项信息 $sql = "SELECT oi.*, p.ProductName, pc.name as category_name FROM order_items oi LEFT JOIN products p ON oi.product_id = p.id LEFT JOIN product_categories pc ON p.category_id = pc.id WHERE oi.order_id = $id"; $itemsResult = mysqli_query($conn, $sql); $orderItems = []; while ($itemRow = mysqli_fetch_assoc($itemsResult)) { $orderItems[] = $itemRow; } } else { echo ""; exit; } ?>