001.<body>
002.<?php
003.$err = "";
004.if($_POST) {
005. include "dblink.php";
006. $mb_user = $_POST['mb_user'];
007. $pswd = $_POST['pswd'];
008. $sql = "SELECT mb_id FROM member WHERE mb_user = '$mb_user' AND mb_pass = '$pswd'";
009. $r = mysqli_query($link, $sql);
010. $row = mysqli_fetch_array($r);
011. if(mysqli_num_rows($r)==1) {
012. $mb_id = $row[0];
013.
014. $ord_id = $_POST['ord_id'];
015.
016. $sql = "SELECT COUNT(*) FROM tb_order WHERE ord_id = '$ord_id' ";
017. $r = mysqli_query($link, $sql);
018. $row = mysqli_fetch_array($r);
019. $c = $row[0];
020. if($c == 1) {
021. $bank = $_POST['bank'];
022. $location = $_POST['location'];
023. $NewFile = $_POST['NewFile'];
024. $bath = $_POST['bath'];
025. $satang = $_POST['satang'];
026. if(!empty($satang)) {
027. $bath .= ".$satang";
028. }
029. else {
030. $bath .= ".00";
031. }
032. $h = $_POST['hour'];
033. $m = $_POST['min'];
034.
035. $dt = $_POST['date'] . " $h:$m";
036. $sql = "INSERT INTO payments VALUES(
037. '', '$ord_id', '$mb_user', '$bank', '$location', '$bath', '$dt', '$NewFile','no')";
038.
039. $FileName = $_FILES['NewFile'] ['name'];
040. $Filetype = $_FILES['NewFile'] ['type'];
041. $FileSize = $_FILES['NewFile'] ['size'];
042. $FileUpLoadtmp = $_FILES['NewFile'] ['tmp_name'];
043.
044.
045. if($sql){
046.
047. if($lname=="gif" or $lname=="jpg" or $lname=="jpeg" or $lname=="png"){
048.
049. $UploadFile = move_uploaded_file($FileUpLoadtmp, "payment/".$NewFile);
050. }
051. }
052.if($FileUpLoadtmp){
053.
054. $array_last = explode(".",$FileName);
055. $c = count($array_last) - 1;
056. $lname = strtolower($array_last [$c]);
057. $NewFileupload = date("U");
058. $NewFile = $NewFileupload.".$lname";
059. }
060. include "connect_db.php";
061. $sql_update = mysql_query("UPDATE ".$order." SET ord_status='2' WHERE ord_id='".$_POST['ord_id']."'");
062. if(!mysqli_query($link, $sql)) {
063. $err = "ไม่สามารถบันทึกข้อมูล กรุณาตรวจสอบการใส่ข้อมูลของท่าน";
064. }
065. else {
066. echo "<script>alert('บันทึกข้อมูลเรียบร้อย รอตรวจสอบ')</script>";
067. echo "<meta http-equiv='refresh' content='0; url=member_order1.php'>";
068. }
069. }
070. else {
071. $err = "ไม่พบรหัสการสั่งซื้อ: $ord_id";
072. }
073. }
074. else {
075. $err = "ท่านใส่อีเมลหรือรหัสผ่านไม่ถูกต้อง";
076. }
077.
078. if($err != "") {
079. echo '<h2 class="warning">'. $err . "</h2>";
080. }
081. mysqli_close($link);
082.}
083.if(!$_POST || $err != "") {
084.
085.?>
086. <td align="left" valign="top"><p></td>
087. <?PHP
088. include "connect_db.php";
089. $sql = mysql_query("SELECT * FROM ".$order." WHERE ord_id='".$_GET['ID']."'");
090. $rs = mysql_fetch_array($sql);
091. $ord_id = $rs['ord_id'];
092.
093.
094.
095. ?>
096. </p><p style="padding:10px;"> <strong><img src="images/14724.png" width="16" height="16" />ใบสั่งชื่อเลขที่</strong> :
097. <?=sprintf("%05d",$rs['ord_id'])?>
098. <strong>ผู้ซื้อ</strong> :
099. <?=$rs['ord_name']?>
100. <strong>ราคา</strong> :
101. <?=number_format($rs['ord_total'],2)?>
102. บาท</p>
103.<form method="post" >
104.<BR>
105. <center>กรุณาใส่ข้อมูลให้ครบสมบูรณ์ เพื่อป้องกันข้อผิดพลาดในการตรวจสอบ<BR>
106. <BR>
107.
108.
109. <div style="padding-left: 50px; text-align:left; font-weight:bold;">Username :<input type="text" name="mb_user" placeholder="Username *" required> <br></center> </div>
110. <div style="padding-left: 50px; text-align:left; font-weight:bold;">Password : <input type="password" name="pswd" placeholder="รหัสผ่าน *" required> <br></div>
111.
112. <div style="padding-left: 30px; text-align:left; font-weight:bold;">รหัสการสั่งซื้อ : <input type="text" name="ord_id" placeholder="รหัสการสั่งซื้อ *" required value="<?=sprintf("%05d",$rs['ord_id'])?>"><br></div>
113.
114.
115. <div style="padding-left: 75px; text-align:left; font-weight:bold;">ธนาคาร : <select name="bank" class="select-style1"> </div>
116.
117. <option>โอนผ่านธนาคาร *</option>
118. <option value="ไทยพาณิชย์">- ไทยพาณิชย์</option>
119. <option value="กรุงเทพ">- กรุงเทพ</option>
120. <option value="กสิกรไทย">- กสิกรไทย</option>
121. <option value="กรุงไทย">- กรุงไทย</option>
122. </select>
123.
124. <input type="text" name="location" placeholder="สาขา/รหัสตู้ ATM *" required> <br></div>
125. <div style="padding-left: 65px; text-align:left; font-weight:bold;">จำนวนเงิน:
126. <input type="number" name="bath" placeholder="จำนวนเงิน (บาท) *" required style="width: 200;">
127. <input type="number" name="satang" placeholder="สตางค์"value="00"style="width: 100;" > สตางค์<br></div>
128. <div style="padding-left: 45px; text-align:left; font-weight:bold;"> วันเวลาที่โอน:
129. <input type="text" name="date" placeholder="วันเดือนปี *" required readonly> เวลาโอน :
130.
131. <select name="hour" id="hour" class="select-style ">
132. <option value="00" selected="">00</option>
133. <option value="01">01</option>
134. <option value="02">02</option>
135. <option value="03">03</option>
136.
137. <option value="04">04</option>
138. <option value="05">05</option>
139. <option value="06">06</option>
140. <option value="07">07</option>
141. <option value="08">08</option>
142. <option value="09">09</option>
143.
144. <option value="10">10</option>
145. <option value="11">11</option>
146. <option value="12">12</option>
147. <option value="13">13</option>
148. <option value="14">14</option>
149. <option value="15">15</option>
150.
151. <option value="16">16</option>
152. <option value="17">17</option>
153. <option value="18">18</option>
154. <option value="19">19</option>
155. <option value="20">20</option>
156. <option value="21">21</option>
157.
158. <option value="22">22</option>
159. <option value="23">23</option>
160. </select>
161. :
162.<select name="min" id="minute" class="select-style" >
163. <option value="00" selected="">00</option>
164. <option value="01">01</option>
165.
166. <option value="02">02</option>
167. <option value="03">03</option>
168. <option value="04">04</option>
169. <option value="05">05</option>
170. <option value="06">06</option>
171. <option value="07">07</option>
172.
173. <option value="08">08</option>
174. <option value="09">09</option>
175. <option value="10">10</option>
176. <option value="11">11</option>
177. <option value="12">12</option>
178. <option value="13">13</option>
179.
180. <option value="14">14</option>
181. <option value="15">15</option>
182. <option value="16">16</option>
183. <option value="17">17</option>
184. <option value="18">18</option>
185. <option value="19">19</option>
186.
187. <option value="20">20</option>
188. <option value="21">21</option>
189. <option value="22">22</option>
190. <option value="23">23</option>
191. <option value="24">24</option>
192. <option value="25">25</option>
193.
194. <option value="26">26</option>
195. <option value="27">27</option>
196. <option value="28">28</option>
197. <option value="29">29</option>
198. <option value="30">30</option>
199. <option value="31">31</option>
200.
201. <option value="32">32</option>
202. <option value="33">33</option>
203. <option value="34">34</option>
204. <option value="35">35</option>
205. <option value="36">36</option>
206. <option value="37">37</option>
207.
208. <option value="38">38</option>
209. <option value="39">39</option>
210. <option value="40">40</option>
211. <option value="41">41</option>
212. <option value="42">42</option>
213. <option value="43">43</option>
214.
215. <option value="44">44</option>
216. <option value="45">45</option>
217. <option value="46">46</option>
218. <option value="47">47</option>
219. <option value="48">48</option>
220. <option value="49">49</option>
221.
222. <option value="50">50</option>
223. <option value="51">51</option>
224. <option value="52">52</option>
225. <option value="53">53</option>
226. <option value="54">54</option>
227. <option value="55">55</option>
228.
229. <option value="56">56</option>
230. <option value="57">57</option>
231. <option value="58">58</option>
232. <option value="59">59</option>
233. </select> นาที
234.
235. <div style="padding-left: 100px; text-align:left; font-weight:bold;"> <input name="NewFile" type="file" size="45" />
236. <span class="style2">*แนบหลักฐานการโอน</span></td>
237.
238. </tr>
239. <button type="submit" style="display:none;"></button>
240.
241.
242.</form>
