01.<?php
02. ini_set('display_errors', 1);
03. error_reporting(~0);
04.
05. $layout = "";
06. $date = date("d-M-Y");
07.
08. $sql = "INSERT INTO pack (cus_id, pack_number, pack_date, product_number, pack_quote, pack_type, pack_sealtype, pack_width, pack_hight, pack_beside, pack_outstretched, pack_closesize, pack_close,pack_sealcenter,pack_foldside,pack_envelope,pack_ seal_edges,pack_seal,pack_perforate,pack_perforate_phase,pack_v_cut,pack_v_cut_phase,pack_zip,pack_zip_phase,pack_cut_corners,pack_layout)
09. VALUES ('".$_POST["namecustomers"]."','".$_POST["number"]."','".$date."','".$_POST["product_number"]."','".$_POST["quote"]."'
10. ,'".$_POST["typeproduct"]."','".$_POST["seal"]."','".$_POST["sizewidthpro"]."','".$_POST["sizeheightpro"]."'
11. ,'".$_POST["radio2"]."','".$_POST["text2"]."','".$_POST["text3"]."','".$_POST["radio3"]."','".$_POST["text4"]."','".$_POST["text5"]."','".$_POST["text6"]."'
12. ,'".$_POST["text7"]."','".$_POST["text8"]."','".$_POST["radio4"]."','".$_POST["radio5"]."'
13. ,'".$_POST["radio6"]."','".$_POST["radio7"]."','".$_POST["text9"]."','".$_POST["text10"]."','".$_POST["text11"]."','".$layout."')";
14. $query = mysqli_query($conn,$sql);
15.
16. $sql2 = "INSERT INTO orderinfo (cus_id,pack_number,order_number,order_po_cus,order_sale_price,order_price_type,order_price_block,order_date,order_delivery,order_billing,order_note,order_v_cost,order_margin,order_note2)
17. VALUES ('".$_POST["namecustomers"]."','".$_POST["number"]."','".$_POST["text21"]."','".$_POST["text22"]."','".$_POST["text23"]."'
18. ,'".$_POST["des1"]."','".$_POST["text24"]."','".$_POST["text25"]."','".$_POST["text26"]."'
19. ,'".$_POST["text27"]."','".$_POST["text28"]."','".$_POST["text29"]."','".$_POST["text30"]."','".$_POST["text31"]."')";
20. $query2 = mysqli_query($conn,$sql2);
21.
22. echo"<script language=\"JavaScript\">";
23. echo"alert('บันทึกสำเร็จ')";
24. echo"</script>";
25.
26.
27.
28.
29. mysqli_close($conn);
30.?>
