01.<?php
02. error_reporting( error_reporting() & ~E_NOTICE );
03.
04.
05. date_default_timezone_set('Asia/Bangkok');
06.
07. $order_name = $_POST["order_name"];
08. $order_lastname = $_POST["order_lastname"];
09. $order_addr = $_POST["address"];
10. $order_email = $_POST["order_email"];
11. $order_phone = $_POST["order_phone"];
12. $p_qty = $_POST["product_qty"];
13. $total = $_POST['total'];
14. $have = $_POST['item'];
15. $order_date = date("Y-m-d H:i:s");
16. $order_status = 1;
17.
18.
19.
20. mysqli_query($conn, "BEGIN");
21. $query1 = "INSERT INTO lotto_order VALUES(null,
22. '$order_name',
23. '$order_lastname',
24. '$order_addr' ,
25. '$order_email',
26. '$order_phone',
27. '$order_status',
28. '$order_date'
29. )";
30.
31. $result1 = mysqli_query($conn, $query1) or die ("Error in query: $query1 " . mysql_error());
32.
33.
34.
35. $query2 = "SELECT MAX(order_id) AS order_id FROM lotto_order WHERE order_phone='$order_phone'";
36. $result2 = mysqli_query($conn, $query2);
37. $row = mysqli_fetch_array($result2);
38. $order_id = $row['order_id'];
39.
40.
41.
42. foreach($_SESSION['shopping_cart'] as $p_id=>$p_qty) {
43.
44. $query3 = "SELECT * FROM lotto_product WHERE product_id='$p_id'";
45. $result3 = mysqli_query($conn, $query3);
46. $row3 = mysqli_fetch_array($result3);
47. $total=$row3['product_price']*$p_qty;
48. $product_name = $row3['product_name'];
49.
50. $queryxs = "SELECT * FROME lotto_login WHERE id ='$member_id'";
51. $resultxs = mysqli_query($conn, $queryxs);
52. $rowxs = mysqli_fetch_array($resultxs);
53. $member_id = $rowxs['id'];
54. $name_login = $rowxs['email'];
55.
56. $query4 = "INSERT INTO lotto_orderdetail
57. values(null,
58. '$order_id',
59. '$p_id',
60. '$p_qty',
61. '$member_id',
62. '$product_name',
63. '$total')";
64. $result4 = mysqli_query($conn, $query4);
65.
66.
67. $query6 = "UPDATE lotto_product SET item = item-".$p_qty." WHERE product_id = '".$p_id."'";
68. $result6 = mysqli_query($conn, $query6);
69.
70. }
71.
72. if($result1 && $result4){
73. mysqli_query($conn, "COMMIT");
74. $msg = "บันทึกข้อมูลเรียบร้อยแล้ว ";
75. foreach($_SESSION['shopping_cart'] as $p_id)
76. {
77.
78. unset($_SESSION['shopping_cart']);
79. }
80. }
81. else{
82. mysqli_query($conn, "ROLLBACK");
83. $msg = "บันทึกข้อมูลไม่สำเร็จ กรุณาติดต่อเจ้าหน้าที่ค่ะ ";
84.
85. }
86.
87.
88. ?>
