01.<?php
02.session_start();
03.?>
06.<head>
07.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
08.<meta http-equiv="refresh" content="1;URL=reservation.php?number=<?php echo"$room_text"; ?>">
09.<title>บันทึกข้อมูล</title>
10.</head>
11.<body bgcolor="#FF99FF">
12.<center><table width="93%">
13. <tr>
14. <td valign="top" bgcolor="#FF99FF" align="center"><p> </p>
15. <p> </p>
16. <p> </p>
17. <p> </p>
18. <p> </p>
19. <p> </p>
20. <table width="489">
21. <tr>
22. <td align="center"><span style="font-family:'JasmineUPC'; font-size:34px; color:#FFF;">
23.<?php
24.include("Myconnect.php");
25.mysql_query("set character set utf8");
26.mysql_query("SET character_set_results=utf8");
27.mysql_query("SET character_set_client=utf8");
28.mysql_query("SET character_set_connection=utf8");
29.
30.
31.
32.
33. $strSQL = "SELECT * FROM person WHERE ((dateStart between '".$_POST["dateStart"]."' and '".$_POST["dateEnd"]."') or ";
34. $strSQL .= " (dateEnd between '".$_POST["dateStart"]."' and '".$_POST["dateEnd"]."')) ";
35.
36. $objQuery = mysql_query($strSQL);
37. $objResult = mysql_fetch_array($objQuery);
38. if($objResult)
39. {
40. echo "วันและเวลาที่จองห้องของคุณ ถูกจองไปแล้ว!";
41. }
42.
43. else
44. {
45.
46.
47.$strSQL2 = "INSERT INTO person ";
48. $strSQL2 .=" ( id_person, id_member, Id_room, tiname_ps, fname_ps, lname_ps, sex_ps, ident_ps, dateStart, dateEnd, totolDay, checkrm_ps, tel_ps) ";
49. $strSQL2 .=" VALUES (NULL,'".$_SESSION['MM_UserName']."','".$_POST["room_text"]."','".$_POST["tname_text"]."','".$_POST["fname_text"]."' ";
50. $strSQL2 .=" ,'".$_POST["lname_text"]."','".$_POST["gender"]."','".$_POST["idnum_text"]."' ";
51. $strSQL2 .=" ,'".$_POST["dateStart"]."','".$_POST["dateEnd"]."','".$_POST["totolDay"]."','".$_POST["checkrm"]."' ";
52. $strSQL2 .=" ,'".$_POST["tel_text"]."')";
53. $objQuery2 = mysql_query($strSQL2);
54.
55. mysql_query("set character set utf8");
56.mysql_query("SET character_set_results=utf8");
57.mysql_query("SET character_set_client=utf8");
58.mysql_query("SET character_set_connection=utf8");
59. echo "จองห้องพักเรียบร้อยแล้ว !";
60.
61.
62.
63. }
64.
65. mysql_close();
66.?>
67.
68.
69.
70.<body>
71.
72.</span></td>
73. </tr>
74. </table>
75. <p> </p>
76. <p> </p>
77. <p> </p>
78. <p> </p>
79. <p> </p></td>
80. </tr>
81. </table>
82.
83. </center>
84.</body>
85.</html>
ติดปัญหาอะไร ลองค้นหาดูนะครับ หลายๆ ปัญหามีอยู่ในไทยครเอทเกือบทั้งหมดครับ
