01.<?php
02.
03.include_once '../dbconfig.php';
04.$message = "แก้ไขข้อมูลเรียบร้อยแล้ว !!!";
05.
06.$id = $_REQUEST['id'];
07.$piece = $_POST['piece'];
08.$productname = $_POST['productname'];
09.$pieceexport = $_POST['pieceexport'];
10.$factory = $_POST['factory'];
11.$newpiece = $_POST['piece'] - $_POST['pieceexport'];
12.
13.if (!isset($errMSG)) {
14.
15. $sql = " INSERT INTO exportorder
16. (productname,pieceexport,factory)
17. VALUES
18. ('$productname','$pieceexport','$factory')";
19. $sql2 = " UPDATE product1 SET
20.
21. piece = '$newpiece'
22. WHERE id = $id ";
23.
24. if (mysqli_query($mysqli, $sql) && mysqli_query($mysqli, $sql2))
25. {
26. echo "<script type='text/javascript'>alert('$message');</script>";
27. header("refresh:1;viewp1.php");
28. } else
29. {
30. echo "Error: " . $sql . "<br>" . mysqli_error($mysqli);
31. }
32.}
33.?>
