01.<?php
02.
03.$vendorcdate = array();
04.$i = 0;
05.foreach ($_POST["vendorcdate"] as $var) {
06. $year = substr($var, 6, 4);
07. $month = substr($var, 3, 2);
08. $date = substr($var, 0, 2);
09. $vendorcdate[$i] = $year . "-" . $month . "-" . $date;
10.
11. $i++;
12.}
13.if ($_POST["submit"] == "update") {
14. for ($j = 0; $j < $i; $j++) {
15. $update = "update xxx SET
16. AS ='" . $quotation[$j] . "'
17. ,VCONFDATE='" . $vendorcdate[$j] . "'
18. ,DF ='" . $vendorcqty[$j] . "'
19. ,GH = '" . $invoice[$j] . "'";
20. $update.="where NO= " . $idno[$j] . "";
21. $queryupdate = sqlsrv_query($conn, $update);
22. }
23. if ($queryupdate) {
24.
25. foreach ($_POST["chkIns"] as $key => $runno) {
26. $update4 = "Update SSS set status = 'GGG' where PPP ='" . $_POST["chkIns"][$key] . "'";
27. $queryupdate = sqlsrv_query($conn, $update4);
28. }
29. if ($queryupdate) {
30. echo "<script>alert('Update Complete ✔✔'); location.href='xxx.php?material=$material&potest=$potest';</script>";
31. } else{
32. echo "<script>alert('Update queryupdate1 Fail!!!'); location.href='xxx.php?material=$material';</script>";return 0;
33. }
34. } else{
35. die( print_r( sqlsrv_errors(), true));
36. echo "<script>alert('Update queryupdate2 Fail!!!'); location.href='xxx.php?material=$material';</script>";return 0;
37. }
38.}
39.?>
