$single_itemid = explode(",", $pitemids);
$single_itemquantities = explode(",", $pitemremoveqty);
foreach($single_itemid as $indx => $value) {
$updateprodqty = mysqli_query($conn,"INSERT INTO itemqty(status, type, productid, storeid, admin, qty, time, date)VALUES('ACTIVE', 'Returned', '$single_itemid[$indx]', '$storeid', '$pcashier', '$single_itemquantities[$indx]', NOW(), NOW())")or die(mysqli_error($conn));
$updateqty = mysqli_query($conn,"UPDATE itembank SET qty=qty+$single_itemquantities[$indx], qtysold=qtysold-$single_itemquantities[$indx] WHERE productid='$single_itemid[$indx]' AND storeid='$storeid'") or die(mysqli_error($conn));
if($updateqty){
$qtyupdate .= "";
//insert into a future qtysale table if necessary
}
else{
$qtyupdate .= "Product I.D ".$single_itemid[$indx]." logged a quantity error
";
}
}
if($qtyupdate!=""){
echo $qtyupdate;
}
else{
echo "success";
}