01.<?
02. session_start();
03. ?>
04.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
05.<?
06. include "config.php";
07. mysql_query("SET NAMES UTF8 ");
08. mysql_select_db("bakery");
09. $name = $_POST["name"];
10. $province = $_POST["province"];
11. $zip = $_POST["zip"];
12. $email = $_POST["email"];
13. $phone = $_POST["phone"];
14. $address = $_POST["address"];
15. $total = $_POST["total_order"];
16. if ($name == ""){
17. echo "<h3 align=center> error : กรุณากรอกชื่อ </h3>" ;
18. exit();
19. } else if ($address == ""){
20. echo "<h3 align=center> error : กรุณากรอกที่อยู่ </h3>" ;
21. exit();
22. }
23. $date_now = date("Y-m-d");
24. $sql1= "insert into order values (null,
25.'$name', '$address','$province','$zip','$phone', '$email', '$date_now', '$total')";
26.
27. mysql_query($sql1, $conn);
28.
29. $sql2 = "select max(order_id) from order";
30. $ex2 = mysql_db_query($dbname,$sql2);
31. $row = mysql_fetch_row($ex2);
32. for($i=0; $i<count($sess_id); $i++) {
33. $sql3 = "insert into 1 values ('$row[0]' , '$sess_id[$i]',
34.'$sess_num[$i]', '$sess_price[$i]')" ;
35. mysql_query($sql3, $conn);
36. }
37. session_unregister("sess_id");
38. session_unregister("sess_name");
39. session_unregister("sess_price");
40. session_unregister("sess_num");
41. echo "<h3 align=center> ทำการบันทึกใบสั่งซื้อเรียบร้อยแล้ว </h3>";
42. echo "<h3 align=center><a href=index.php>กลับหน้าหลัก </a></h3>";
43. mysql_close($conn);
44.?>
Load balance : Server 01
