001.<?session_start();?>
004.<head>
005. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
006.
007. <script type="text/javascript" src="js/jquery-1.7.1.min.js"></script>
008. <script type="text/javascript">
009.
010. $(document).ready(function(){
011. $('input[name="submit_zone"]').click(function(){
012. $('#regist-error').append('<img src="img/loading.gif" alt="Currently Loading" id="loading" />');
013.
014. $.post(
015. '?checkData=add_zone',
016. $('#add_zone').serialize(),
017. function(data){
018. $('#response').empty();
019. $('#regist-error').append('<p id="response">' + data + '</p>');
020. $('#loading').fadeOut(500, function(){
021. $(this).remove();
022. });
023.
024. $('input[type="text"]').val("");
025. $('input[type="password"]').val("");
026. $('select[name="nameGzone"]').val("");
027. },
028. 'html'
029. );
030. return false;
031. });
032.
033.
034. $('input[name="submit_Gzone"]').click(function(){
035. $('#regist-error').append('<img src="img/loading.gif" alt="Currently Loading" id="loading" />');
036.
037. $.post(
038. '?checkData=add_Gzone',
039. $('#add_Gzone').serialize(),
040. function(data){
041. $('#response').empty();
042. $('#regist-error').append('<p id="response">' + data + '</p>');
043. $('#loading').fadeOut(500, function(){
044. $(this).remove();
045. });
046.
047. $('input[type="text"]').val("");
048. $('input[type="password"]').val("");
049. },
050. 'html'
051. );
052. return false;
053. });
054.
055. });
056. </script>
057.</head>
058.<body>
059.<?
060. include("configDB.php");
061.
062. switch($_GET["checkData"]){
063. case "add_zone":
064. echo add_zone();
065. break;
066. case "add_Gzone":
067. echo add_Gzone();
068. break;
069. }
070.
071. $Gzone = "SELECT id_Gzone FROM g_zone ";
072. $QGzone = mysql_query($Gzone) or die (mysql_error());
073. if($QGzone == NULL)
074. {
075. echo "ไม่มีข้อมูล";
076. }
077. else
078. {
079. echo "<div id='regist-error'></div>
080. <form id='add_zone' action = '' method='POST'>
081. <fieldset>
082. <legend>ADD เขต</legend>
083.
084. <select name='nameGzone'>
085. <option value=''>กลุ่มเขต</option>";
086. while($resultGzone = mysql_fetch_assoc($QGzone)){
087. echo "<option value='".$resultGzone["id_Gzone"]."'>".$resultGzone["id_Gzone"]."</option>";
088. }
089. echo"
090. </select>
091. ชื่อเขต:
092. <input type='text' name='namezone' size='20' />
093. ชื่อผู้ใช้:
094. <input type='text' name='user' size='20' />
095. รหัสผ่าน:
096. <input type='password' name='pass' size='20' />
097.
098. <input type='submit' name='submit_zone' value='ตกลง'/>
099.
100. </fieldset>
101. </form>
102. ";
103. }
104.
105. echo "
106. <form id='add_Gzone' action = '' method='POST'>
107. <fieldset>
108. <legend>ADD กลุ่มเขต</legend>
109. ID กลุ่มเขต:
110. <input type='text' name='id_G' size='20' maxlength='4'>
111. ชื่อผู้ใช้:
112. <input type='text' name='userG' size='20'>
113. รหัสผ่าน:
114. <input type='password' name='passG' size='20'>
115.
116. <input type='submit' name='submit_Gzone' value='ตกลง'/>
117. </fieldset>
118. </form>
119. ";
120.?>
121.
122.</body>
123.</html>
124.<?
125. function add_zone(){
126. if($_POST["nameGzone"] == ""){
127. echo "ยังไม่ระบุกลุ่มเขต";
128. }else{
129. $user = trim($_POST["user"]);
130. $pass = trim($_POST["pass"]);
131.
132. $zone = "INSERT INTO zone(id_zone, id_Gzone, name_zone, user_zone, pass_zone) VALUES('NULL', '".$_POST["nameGzone"]."', '".$_POST["namezone"]."', '".$user."', '".$pass."')";
133. $Qzone = mysql_query($zone) or die (mysql_error());
134.
135. $str_zone = "SELECT * FROM zone ORDER BY 1 DESC";
136. $Q_zone = mysql_query($str_zone) or die (mysql_error());
137. $result_zone = mysql_fetch_assoc($Q_zone);
138.
139. $permit = "INSERT INTO permit(id_permit, id_user, user_permition, pass_permition, permition) VALUES('NULL', '".$result_zone["id_zone"]."', '".$result_zone["user_zone"]."', '".$result_zone["pass_zone"]."', '".$result_zone["z_premition"]."')";
140. $Qpermit = mysql_query($permit) or die (mysql_error());
141.
142.
143.
144. if($Qpermit){
145. echo "บันทึกเรียบร้อย";
146. }else{
147. echo "บันทึกล้มเหลว";
148. }
149. }
150. }
151.
152. function add_Gzone(){
153. if($_POST["id_G"] == "" && $_POST["userG"] == "" && $_POST["passG"] == ""){
154. echo "ต้องระบุข้อมูลให้ครบทุกช่อง";
155. }else{
156. $ch_Gzone = "SELECT * FROM g_zone WHERE id_Gzone = '".$_POST["id_G"]."' ";
157. $Q_Gzone = mysql_query($ch_Gzone) or die (mysql_error());
158. $num_Gzone = mysql_num_rows($Q_Gzone);
159.
160. if($num_Gzone != 0){
161. echo " มีไอดีนี้อยู่ในระบบแล้ว";
162. }else{
163. $id = trim($_POST["id_G"]);
164. $user = trim($_POST["userG"]);
165. $pass = trim($_POST["passG"]);
166.
167. $addGzone = "INSERT INTO g_zone(id_Gzone, user_Gzone, pass_Gzone) VALUES('".$id."', '".$user."', '".$pass."')";
168. $QaddGzone = mysql_query($addGzone) or die (mysql_error());
169.
170. $ch1_Gzone = "SELECT * FROM g_zone WHERE id_Gzone = '".$_POST["id_G"]."' ";
171. $Q1_Gzone = mysql_query($ch1_Gzone) or die (mysql_error());
172. $result_Gzone = mysql_fetch_assoc($Q1_Gzone);
173.
174. $permit = "INSERT INTO permit(id_permit, id_user, user_permition, pass_permition, permition) VALUES('NULL', '".$result_Gzone["id_Gzone"]."', '".$result_Gzone["user_Gzone"]."', '".$result_Gzone["pass_Gzone"]."', '".$result_Gzone["g_permition"]."')";
175. $Qpermit = mysql_query($permit) or die (mysql_error());
176.
177. if($Qpermit){
178. echo "บันทึกข้อมูลเรียบร้อย";
179. }else{
180. echo "บันทึกข้อมูลล้มเหลว!";
181. }
182. }
183. }
184. }
185.
186.?>
