PHP中基于唯一ID精确定位更新关联数组数据（数据库行）

UPDATE suppliersOrdersAddress SET address = ?, operator = ? WHERE orderId = ? AND addressType = ?;

WHERE id = ? AND orderId = ? AND addressType = ?;

<?php

// 假设此函数位于一个独立的数据库操作文件，并已建立$conn连接
// function updateSupplierOrder($conn, ...) { ... }

/**
 * 更新供应商订单及其关联地址信息。
 *
 * @param mysqli $conn 数据库连接对象。
 * @param string $orderDate 订单日期。
 * @param string $datePickup 提货日期。
 * @param string $dateDelivery 送货日期。
 * @param string $timePickup 提货时间。
 * @param string $timeDelivery 送货时间。
 * @param string $car 车辆信息。
 * @param string $carType 车辆类型。
 * @param string $goodsDescription 货物描述。
 * @param int $paletChange 托盘是否更换。
 * @param int $paletNo 托盘数量。
 * @param int $supplier 供应商ID。
 * @param string $orderObservation 订单备注。
 * @param string $paymentDate 付款日期。
 * @param float $value 订单金额。
 * @param array $addressPickup 提货地址数组（每个元素是地址字符串）。
 * @param array $addressPickupIds 提货地址ID数组（每个元素是地址记录的唯一ID）。
 * @param array $addressDelivery 送货地址数组（每个元素是地址字符串）。
 * @param array $addressDeliveryIds 送货地址ID数组（每个元素是地址记录的唯一ID）。
 * @param int $userid 操作用户ID。
 * @param int $orderID 订单ID。
 * @return void
 */
function updateSupplierOrder(
    $conn, $orderDate, $datePickup, $dateDelivery, $timePickup, $timeDelivery,
    $car, $carType, $goodsDescription, $paletChange, $paletNo, $supplier,
    $orderObservation, $paymentDate, $value,
    $addressPickup, $addressPickupIds, // 引入提货地址ID数组
    $addressDelivery, $addressDeliveryIds, // 引入送货地址ID数组
    $userid, $orderID
) {
    // 1. 更新主订单信息
    $sql1 = "UPDATE suppliersOrders SET supplierId = ?, date = ?, datePickup = ?, timePickup = ?, goodsDescription = ?, dateDelivery = ?, timeDelivery = ?, carType = ?, carNo = ?, paletChange = ?, paletNo = ?, value = ?, invoice = ?, observations = ?, operator = ? WHERE id = ?;";
    $stmt1 = mysqli_stmt_init($conn);
    if (!mysqli_stmt_prepare($stmt1, $sql1)) {
        header("location: ../suppliersOrders?error=failedupdateorder");
        exit();
    }
    mysqli_stmt_bind_param($stmt1, "isssssssisisssii",
        $supplier, $orderDate, $datePickup, $timePickup, $goodsDescription,
        $dateDelivery, $timeDelivery, $carType, $car, $paletChange, $paletNo,
        $value, $paymentDate, $orderObservation, $userid, $orderID
    );
    mysqli_stmt_execute($stmt1);
    mysqli_stmt_close($stmt1);

    // 2. 遍历并更新提货地址
    for ($i = 0; $i < count($addressPickup); $i++) {
        $address = $addressPickup[$i];
        $addressId = $addressPickupIds[$i]; // 获取对应的唯一地址ID
        $type = 1; // 提货地址类型

        // 修改 WHERE 子句，加入 id = ?
        $sql2 = "UPDATE suppliersOrdersAddress SET address = ?, operator = ? WHERE id = ? AND orderId = ? AND addressType = ?;";
        $stmt2 = mysqli_stmt_init($conn);
        if (!mysqli_stmt_prepare($stmt2, $sql2)) {
            header("location: ../suppliersOrders?error=failedupdateaddress");
            exit();
        }
        // 绑定参数：s (address), i (operator), i (addressId), i (orderId), i (type)
        mysqli_stmt_bind_param($stmt2, "siiii", $address, $userid, $addressId, $orderID, $type);
        mysqli_stmt_execute($stmt2);
        mysqli_stmt_close($stmt2);
    }

    // 3. 遍历并更新送货地址
    for ($i = 0; $i < count($addressDelivery); $i++) {
        $address = $addressDelivery[$i];
        $addressId = $addressDeliveryIds[$i]; // 获取对应的唯一地址ID
        $type = 2; // 送货地址类型

        // 修改 WHERE 子句，加入 id = ?
        $sql2 = "UPDATE suppliersOrdersAddress SET address = ?, operator = ? WHERE id = ? AND orderId = ? AND addressType = ?;";
        $stmt2 = mysqli_stmt_init($conn);
        if (!mysqli_stmt_prepare($stmt2, $sql2)) {
            header("location: ../suppliersOrders?error=failedupdateaddress");
            exit();
        }
        // 绑定参数：s (address), i (operator), i (addressId), i (orderId), i (type)
        mysqli_stmt_bind_param($stmt2, "siiii", $address, $userid, $addressId, $orderID, $type);
        mysqli_stmt_execute($stmt2);
        mysqli_stmt_close($stmt2);
    }

    // 更新成功后重定向
    header("location: ../suppliersOrders-edit.php?id=$orderID");
    exit(); // 确保重定向后脚本终止执行
}