减去值并更新多行

Question

I have a cart and I want to update database with the right stock values. I get ordered products inserted into the table, but I can't update the stoc table with the right values.

foreach($_POST['produsC'] as $row=>$produsC) {

    $produsC=mysqli_real_escape_string($link,$produsC);
    $masuraC=mysqli_real_escape_string($link,($_POST['masuraC'][$row]));
    $codutC=mysqli_real_escape_string($link,($_POST['codutC'][$row]));
    $cantitateC=mysqli_real_escape_string($link,($_POST['cantitateC'][$row]));
    $pretC=mysqli_real_escape_string($link,($_POST['pretC'][$row]));
    $tokC=mysqli_real_escape_string($link,($_POST['tokC'][$row]));
    $row_data[] = "('$tokC' , '$codutC' , '$produsC' , '$masuraC' , '$cantitateC' , '$pretC' , NOW())";
}

if (!empty($row_data)) {
$sql = 'INSERT INTO orders (order_id, idd, produs, masura, cantitate, pret, data) VALUES '.implode

(',', $row_data);
$result = mysqli_query($link, $sql);
}

$up = "UPDATE stoc SET 
                    stoc = stoc - ".$cantitateC."
                WHERE prodid = '".$_POST['codutC'][$row]."' AND masura = '".$_POST['masuraC'][$row]."'";
                mysqli_query($link, $up);

Thx in advance