PHP电商订单数组改造：如何实现order_lines从购物车动态加载

你的代码存在以下核心错误： #

• 语法违规：PHP不支持在数组定义的内部直接写入if判断、循环、SQL赋值这类执行逻辑，你将数据库查询和循环逻辑直接嵌入了$order数组的order_lines字段定义中，属于致命语法错误，直接导致程序崩溃。
• 订单项未正确收集：循环中生成的订单项数组没有主动追加到order_lines数组中，裸写的数组结构不会被自动识别为数组元素。
• 金额数据不匹配：原有静态代码中order_amount（订单总金额）、order_tax_amount（订单总税额）是固定值，动态生成订单项后这两个值需要同步计算，否则会出现数据不一致。
• 缺少错误兜底：没有处理数据库查询失败的场景，也没有释放查询结果集，容易引发额外报错。

正确实现代码 #

// 第一步：先单独从数据库读取购物车数据，组装order_lines数组
$order_lines = [];
$order_amount = 0;
$order_tax_amount = 0;
$tax_rate = 2500; // 统一税率，和你原有逻辑保持一致

$cartsql = "select a, b, c, d from lux_cart WHERE status = 0 ORDER BY a DESC";    
if ($result = mysqli_query($mysqli, $cartsql)) {
    while ($cartrow = mysqli_fetch_row($result)) {
        $itemid = $cartrow[0];
        $prodTitel = $cartrow[1];
        $antalcart = $cartrow[2];
        $prodPris = $cartrow[3]; // 注意这里是单价，单位要和原有逻辑保持一致
        
        // 计算当前商品的总金额和总税额
        $item_total = $prodPris * $antalcart;
        $item_tax = intval($item_total * ($tax_rate / 10000)); // 2500对应25%税率
        
        // 把当前商品追加到订单项数组
        $order_lines[] = [
            "type" => "physical",
            "reference" => (string)$itemid,
            "name" => $prodTitel,
            "quantity" => $antalcart,
            "unit_price" => $prodPris,
            "tax_rate" => $tax_rate,
            "total_amount" => $item_total,
            "total_tax_amount" => $item_tax
            // 如果需要quantity_unit、折扣等其他字段可以自行追加
        ];
        
        // 累加订单总金额和总税额
        $order_amount += $item_total;
        $order_tax_amount += $item_tax;
    }
    // 释放结果集
    mysqli_free_result($result);
}

// 第二步：组装完整的order数组
$order = [
    "purchase_country" => "SE",
    "purchase_currency" => "SEK",
    "locale" => "sv-SE",
    "order_amount" => $order_amount,
    "order_tax_amount" => $order_tax_amount,
    "order_lines" => $order_lines,
    "merchant_urls" => [
        "terms" => "https://www.example.com/villkor.php",
        "cancellation_terms" => "https://www.example.com/terms/cancellation.html",
        "checkout" => "https://www.example.com/_script/checkout.php",
        "confirmation" => "https://www.example.com/_script/checkout.php",
        // Callbacks
        "push" => "https://www.example.com/api/push",
        "validation" => "https://www.example.com/api/validation",
        "shipping_option_update" => "https://www.example.com/api/shipment",
        "address_update" => "https://www.example.com/api/address",
        "notification" => "https://www.example.com/api/pending",
        "country_change" => "https://www.example.com/api/country"
    ]
];

内容的提问来源于stack exchange，提问作者Andreas Thomsson