001.file connect dbconnect.php
002.<?php
003.$mysqli = new mysqli("localhost", "root","","fwf2025");
004.
005.if ($mysqli->connect_errno) {
006. printf("Connect failed: %s\n", $mysqli->connect_error);
007. exit();
008.}
009.if(!$mysqli->set_charset("utf8")) {
010. printf("Error loading character set utf8: %s\n", $mysqli->error);
011. exit();
012.}
013.?>
014.
015.
016.
017.
018.ผมต้องการสร้างค้นหา ระหว่าง id สมมุติ id 1 ถึง id 10 เพื่อสั่งพิมพ์ ผมลองสร้างมาหลายวันแล้ว ดูรูปแบบการ search between เพื่อนำมา apply แต่ก็ไม่ได้ ขอความอนุเคราะห์ช่วยต่อยอดให้หน่อยได้ไม่ครับ. Code หลัก สำหรับพิมพ์ตามด้านล่างนี้ครับ.
019.
020.
021.<?php
022.require_once("dbconnect.php");
023.?>
024.<!doctype html>
025.<html>
026.<head>
027. <meta charset="utf-8">
028.
029.<title>พิมพ์ใบรับรองแพทย์ตามช่วงที่กำหนด</title>
030.<style type="text/css">
031.
032.
033.
034.
035.@media all
036.{
037. .page-break { display:none; }
038. .page-break-no{ display:none; }
039.}
040.@media print
041.{
042. .page-break { display:block;height:1px; page-break-before:always; }
043. .page-break-no{ display:block;height:1px; page-break-after:avoid; }
044.}
045.body,td,th {
046. font-family: TH Sarabun New;
047. font-size: 27px;
048.}
049.a {
050. font-family: TH Sarabun New;
051. font-size: 27px;
052.}
053..style4 {font-size: 18px}
054..style7 {font-size: 24px}
055..style8 {font-size: 27px; }
056.</style>
057.<meta http-equiv="Content-Type" content="text/html; charset=utf-8"></head>
058.
059.<body onLoad="window.print()">
060.
061.
062.
063.
064.
065.
066.
067.
068.
069.
070.
071.<?php
072.
073.
074.
075.$total_page_data = 0;
076.$total_page_item = 1;
077.$total_page_item_all = 0;
078.$arr_data_set=array(array());
079.$i=1;
080.$sql = " SELECT * FROM certificate where id between '44380' AND '44381' and occupation !='ประมง' AND age >='7' ";
081.
082.$result = $mysqli->query($sql);
083.
084.
085.if($result && $result->num_rows>0){
086. $total_page_item_all = $result->num_rows;
087. $total_page_data = ceil($total_page_item_all/$total_page_item);
088. while($row = $result->fetch_assoc()){
089. $arr_data_set['hn'][$i]=$row['hn'];
090. $arr_data_set['name'][$i]=$row['name'];
091. $arr_data_set['age'][$i]=$row['age'];
092. $arr_data_set['sex'][$i]=$row['sex'];
093. $arr_data_set['nationality'][$i]=$row['nationality'];
094.
095. $arr_data_set['status'][$i]=$row['status'];
096. $arr_data_set['passport'][$i]=$row['passport'];
097. $arr_data_set['skincolor'][$i]=$row['skincolor'];
098. $arr_data_set['idcard'][$i]=$row['idcard'];
099. $arr_data_set['occupation'][$i]=$row['occupation'];
100. $arr_data_set['employer'][$i]=$row['employer'];
101. $arr_data_set['employertel'][$i]=$row['employertel'];
102. $arr_data_set['addressemployer'][$i]=$row['addressemployer'];
103. $arr_data_set['height'][$i]=$row['height'];
104. $arr_data_set['weight'][$i]=$row['weight'];
105. $arr_data_set['pressure'][$i]=$row['pressure'];
106. $arr_data_set['pr'][$i]=$row['pr'];
107. $arr_data_set['r11'][$i]=$row['r11'];
108. $arr_data_set['r12'][$i]=$row['r12'];
109. $arr_data_set['r13'][$i]=$row['r13'];
110. $arr_data_set['r21'][$i]=$row['r21'];
111. $arr_data_set['r22'][$i]=$row['r22'];
112. $arr_data_set['r23'][$i]=$row['r23'];
113. $arr_data_set['r31'][$i]=$row['r31'];
114. $arr_data_set['r32'][$i]=$row['r32'];
115. $arr_data_set['r33'][$i]=$row['r33'];
116. $arr_data_set['r41'][$i]=$row['r41'];
117. $arr_data_set['r42'][$i]=$row['r42'];
118. $arr_data_set['r43'][$i]=$row['r43'];
119. $arr_data_set['r51'][$i]=$row['r51'];
120. $arr_data_set['r52'][$i]=$row['r52'];
121. $arr_data_set['r53'][$i]=$row['r53'];
122. $arr_data_set['r61'][$i]=$row['r61'];
123. $arr_data_set['r62'][$i]=$row['r62'];
124. $arr_data_set['r63'][$i]=$row['r63'];
125. $arr_data_set['r71'][$i]=$row['r71'];
126. $arr_data_set['r72'][$i]=$row['r72'];
127. $arr_data_set['r81'][$i]=$row['r81'];
128. $arr_data_set['r82'][$i]=$row['r82'];
129. $arr_data_set['r91'][$i]=$row['r91'];
130. $arr_data_set['r92'][$i]=$row['r92'];
131. $arr_data_set['r101'][$i]=$row['r101'];
132. $arr_data_set['r102'][$i]=$row['r102'];
133. $arr_data_set['c1'][$i]=$row['c1'];
134. $arr_data_set['c2'][$i]=$row['c2'];
135. $arr_data_set['c3'][$i]=$row['c3'];
136. $arr_data_set['c4'][$i]=$row['c4'];
137. $arr_data_set['c5'][$i]=$row['c5'];
138. $arr_data_set['printtime'][$i]=$row['printtime'];
139.
140.
141.
142. $i++;
143. }
144.}
145.?>
146.<?php for($i=1;$i<=$total_page_data;$i++){ ?>
147.
148.
149. <?php
150.
151. for($v=1;$v<=$total_page_item;$v++){
152. $item_i=(($i-1)*$total_page_item)+$v;
153. $hn = isset($arr_data_set['hn'][$item_i])?$arr_data_set['hn'][$item_i]:"";
154. $item_i = isset($arr_data_set['hn'][$item_i])?$item_i:"";
155.
156. $age = isset($arr_data_set['age'][$item_i])?$arr_data_set['age'][$item_i]:"";
157. $item_i = isset($arr_data_set['age'][$item_i])?$item_i:"";
158.
159. $sex = isset($arr_data_set['sex'][$item_i])?$arr_data_set['sex'][$item_i]:"";
160. $item_i = isset($arr_data_set['sex'][$item_i])?$item_i:"";
161.
162.
163. $name = isset($arr_data_set['name'][$item_i])?$arr_data_set['name'][$item_i]:"";
164. $item_i = isset($arr_data_set['name'][$item_i])?$item_i:"";
165.
166. $idcard = isset($arr_data_set['idcard'][$item_i])?$arr_data_set['idcard'][$item_i]:"";
167. $item_i = isset($arr_data_set['idcard'][$item_i])?$item_i:"";
168.
169. $passport = isset($arr_data_set['passport'][$item_i])?$arr_data_set['passport'][$item_i]:"";
170. $item_i = isset($arr_data_set['passport'][$item_i])?$item_i:"";
171.
172. $nationality = isset($arr_data_set['nationality'][$item_i])?$arr_data_set['nationality'][$item_i]:"";
173. $item_i = isset($arr_data_set['nationality'][$item_i])?$item_i:"";
174.
175.
176.
177.
178. $status = isset($arr_data_set['status'][$item_i])?$arr_data_set['status'][$item_i]:"";
179. $item_i = isset($arr_data_set['status'][$item_i])?$item_i:"";
180.
181. $skincolor = isset($arr_data_set['skincolor'][$item_i])?$arr_data_set['skincolor'][$item_i]:"";
182. $item_i = isset($arr_data_set['skincolor'][$item_i])?$item_i:"";
183.
184.
185. $occupation = isset($arr_data_set['occupation'][$item_i])?$arr_data_set['occupation'][$item_i]:"";
186. $item_i = isset($arr_data_set['occupation'][$item_i])?$item_i:"";
187.
188.
189. $employer = isset($arr_data_set['employer'][$item_i])?$arr_data_set['employer'][$item_i]:"";
190. $item_i = isset($arr_data_set['employer'][$item_i])?$item_i:"";
191.
192.
193. $employertel = isset($arr_data_set['employertel'][$item_i])?$arr_data_set['employertel'][$item_i]:"";
194. $item_i = isset($arr_data_set['employertel'][$item_i])?$item_i:"";
195.
196.
197. $addressemployer = isset($arr_data_set['addressemployer'][$item_i])?$arr_data_set['addressemployer'][$item_i]:"";
198. $item_i = isset($arr_data_set['addressemployer'][$item_i])?$item_i:"";
199.
200.
201. $height = isset($arr_data_set['height'][$item_i])?$arr_data_set['height'][$item_i]:"";
202. $item_i = isset($arr_data_set['height'][$item_i])?$item_i:"";
203.
204.
205. $weight = isset($arr_data_set['weight'][$item_i])?$arr_data_set['weight'][$item_i]:"";
206. $item_i = isset($arr_data_set['weight'][$item_i])?$item_i:"";
207.
208.
209. $pressure = isset($arr_data_set['pressure'][$item_i])?$arr_data_set['pressure'][$item_i]:"";
210. $item_i = isset($arr_data_set['pressure'][$item_i])?$item_i:"";
211.
212.
213. $pr = isset($arr_data_set['pr'][$item_i])?$arr_data_set['pr'][$item_i]:"";
214. $item_i = isset($arr_data_set['pr'][$item_i])?$item_i:"";
215.
216.
217. $r11 = isset($arr_data_set['r11'][$item_i])?$arr_data_set['r11'][$item_i]:"";
218. $item_i = isset($arr_data_set['r11'][$item_i])?$item_i:"";
219.
220.
221. $r12 = isset($arr_data_set['r12'][$item_i])?$arr_data_set['r12'][$item_i]:"";
222. $item_i = isset($arr_data_set['r12'][$item_i])?$item_i:"";
223.
224.
225.
226. $r13 = isset($arr_data_set['r13'][$item_i])?$arr_data_set['r13'][$item_i]:"";
227. $item_i = isset($arr_data_set['r13'][$item_i])?$item_i:"";
228.
229.
230. $r21 = isset($arr_data_set['r21'][$item_i])?$arr_data_set['r21'][$item_i]:"";
231. $item_i = isset($arr_data_set['r21'][$item_i])?$item_i:"";
232.
233.
234. $r22 = isset($arr_data_set['r22'][$item_i])?$arr_data_set['r22'][$item_i]:"";
235. $item_i = isset($arr_data_set['r22'][$item_i])?$item_i:"";
236.
237.
238. $r23 = isset($arr_data_set['r23'][$item_i])?$arr_data_set['r23'][$item_i]:"";
239. $item_i = isset($arr_data_set['r23'][$item_i])?$item_i:"";
240.
241.
242. $r31 = isset($arr_data_set['r31'][$item_i])?$arr_data_set['r31'][$item_i]:"";
243. $item_i = isset($arr_data_set['r31'][$item_i])?$item_i:"";
244.
245.
246. $r32 = isset($arr_data_set['r32'][$item_i])?$arr_data_set['r32'][$item_i]:"";
247. $item_i = isset($arr_data_set['r32'][$item_i])?$item_i:"";
248.
249.
250. $r33 = isset($arr_data_set['r33'][$item_i])?$arr_data_set['r33'][$item_i]:"";
251. $item_i = isset($arr_data_set['r33'][$item_i])?$item_i:"";
252.
253.
254. $r41 = isset($arr_data_set['r41'][$item_i])?$arr_data_set['r41'][$item_i]:"";
255. $item_i = isset($arr_data_set['r41'][$item_i])?$item_i:"";
256.
257.
258. $r42 = isset($arr_data_set['r42'][$item_i])?$arr_data_set['r42'][$item_i]:"";
259. $item_i = isset($arr_data_set['r42'][$item_i])?$item_i:"";
260.
261.
262. $r43 = isset($arr_data_set['r43'][$item_i])?$arr_data_set['r43'][$item_i]:"";
263. $item_i = isset($arr_data_set['r43'][$item_i])?$item_i:"";
264.
265.
266. $r51 = isset($arr_data_set['r51'][$item_i])?$arr_data_set['r51'][$item_i]:"";
267. $item_i = isset($arr_data_set['r51'][$item_i])?$item_i:"";
268.
269.
270. $r52 = isset($arr_data_set['r52'][$item_i])?$arr_data_set['r52'][$item_i]:"";
271. $item_i = isset($arr_data_set['r52'][$item_i])?$item_i:"";
272.
273.
274. $r53 = isset($arr_data_set['r53'][$item_i])?$arr_data_set['r53'][$item_i]:"";
275. $item_i = isset($arr_data_set['r53'][$item_i])?$item_i:"";
276.
277.
278. $r61 = isset($arr_data_set['r61'][$item_i])?$arr_data_set['r61'][$item_i]:"";
279. $item_i = isset($arr_data_set['r61'][$item_i])?$item_i:"";
280.
281.
282. $r62 = isset($arr_data_set['r62'][$item_i])?$arr_data_set['r62'][$item_i]:"";
283. $item_i = isset($arr_data_set['r62'][$item_i])?$item_i:"";
284.
285.
286. $r63 = isset($arr_data_set['r63'][$item_i])?$arr_data_set['r63'][$item_i]:"";
287. $item_i = isset($arr_data_set['r63'][$item_i])?$item_i:"";
288.
289.
290.
291. $r71 = isset($arr_data_set['r71'][$item_i])?$arr_data_set['r71'][$item_i]:"";
292. $item_i = isset($arr_data_set['r71'][$item_i])?$item_i:"";
293.
294. $r72 = isset($arr_data_set['r72'][$item_i])?$arr_data_set['r72'][$item_i]:"";
295. $item_i = isset($arr_data_set['r72'][$item_i])?$item_i:"";
296.
297. $r81 = isset($arr_data_set['r81'][$item_i])?$arr_data_set['r81'][$item_i]:"";
298. $item_i = isset($arr_data_set['r81'][$item_i])?$item_i:"";
299.
300. $r82 = isset($arr_data_set['r82'][$item_i])?$arr_data_set['r82'][$item_i]:"";
301. $item_i = isset($arr_data_set['r82'][$item_i])?$item_i:"";
302.
303. $r91 = isset($arr_data_set['r91'][$item_i])?$arr_data_set['r91'][$item_i]:"";
304. $item_i = isset($arr_data_set['r91'][$item_i])?$item_i:"";
305.
306. $r92 = isset($arr_data_set['r92'][$item_i])?$arr_data_set['r92'][$item_i]:"";
307. $item_i = isset($arr_data_set['r92'][$item_i])?$item_i:"";
308.
309. $r101 = isset($arr_data_set['r101'][$item_i])?$arr_data_set['r101'][$item_i]:"";
310. $item_i = isset($arr_data_set['r101'][$item_i])?$item_i:"";
311.
312. $r102 = isset($arr_data_set['r102'][$item_i])?$arr_data_set['r102'][$item_i]:"";
313. $item_i = isset($arr_data_set['r102'][$item_i])?$item_i:"";
314.
315. $c1 = isset($arr_data_set['c1'][$item_i])?$arr_data_set['c1'][$item_i]:"";
316. $item_i = isset($arr_data_set['c1'][$item_i])?$item_i:"";
317.
318. $c2 = isset($arr_data_set['c2'][$item_i])?$arr_data_set['c2'][$item_i]:"";
319. $item_i = isset($arr_data_set['c2'][$item_i])?$item_i:"";
320.
321. $c3 = isset($arr_data_set['c3'][$item_i])?$arr_data_set['c3'][$item_i]:"";
322. $item_i = isset($arr_data_set['c3'][$item_i])?$item_i:"";
323.
324. $c4 = isset($arr_data_set['c4'][$item_i])?$arr_data_set['c4'][$item_i]:"";
325. $item_i = isset($arr_data_set['c4'][$item_i])?$item_i:"";
326.
327.
328. $c5 = isset($arr_data_set['c5'][$item_i])?$arr_data_set['c5'][$item_i]:"";
329. $item_i = isset($arr_data_set['c5'][$item_i])?$item_i:"";
330.
331. $printtime = isset($arr_data_set['printtime'][$item_i])?$arr_data_set['printtime'][$item_i]:"";
332. $item_i = isset($arr_data_set['printtime'][$item_i])?$item_i:"";
333.
334.
335.
336.
337.
338.
339.
340.
341. ?>
342.
343. <?php } ?>
344.
345.
346.
347.<table width="1130" border="0" align="center">
348. <tr>
349. <th width="396" height="34"> </th>
350. <td colspan="4"><div align="center"><b>
351. <h2> </h2>
352. </b></div></td>
353. <td width="87"><b>
354. <h2> </h2>
355. </b></td>
356. </tr>
357. <tr>
358. <th height="34" colspan="4"> <h2 align="justify"><b> โรงพยาบาลxxxx</b></h2></th>
359. <th height="34" colspan="2"><div align="justify"><b>
360. <h2> <?=$hn?> </h2>
361. </b></div></th>
362. </tr>
363. <tr>
364. <td colspan="3"> ชื่อ : <b>
365. <?=$name?></b>
366. </td>
367. <td width="226">อายุ : <b>
368. <?=$age?>
369.ปี</b></td>
370. <td colspan="2"><div align="justify">เพศ /Sex : <b><?=$sex?></b></div></td>
371. </tr>
372. <tr>
373. <td colspan="2"><div align="left">สัญชาติ /Nationalituy : <strong><?=$nationality?></strong></div></td>
374. <td colspan="2"><div align="justify"> เชื้อชาติ / Race : <strong> <?=$nationality?></strong></div></td>
375. <td colspan="2"><div align="justify">สถานภาพสมรส/Merried Status : <strong><?=$status?></strong></div></td>
376. </tr>
377. <tr>
378. <td colspan="4" ><div align="left"> หนังสือเดินทางเลขที่ / Passport No. : <strong><?=$passport?></strong></div></td>
379. <td colspan="2"><div align="justify">สีผิว / Skin color : <strong><?=$skincolor?></strong></div></td>
380. </tr>
381. <tr>
382. <td colspan="6"><div align="left"> เลขประจำตัวบุคคลไม่มีสัญชาติไทย / Non Thai Identity No. : <strong><?=$idcard?></strong> อาชีพ / Occupation : <strong><?=$occupation?></strong></div>
383. <div align="right"></div></td>
384. </tr>
385. <tr>
386. <td colspan="4"><div align="left"> ชื่อนายจ้าง / Employer Name :<strong>
387. <?=$employer?>
388. </strong></div> </td>
389. <td colspan="2"> เบอร์โทร. :<strong>
390. <?=$employertel?>
391. </strong></td>
392. </tr>
393. <tr>
394. <td colspan="6"><div align="left"> ที่อยู่นายจ้าง / Employer Address : <strong>
395. <?=$addressemployer?>
396. </strong></div> </td>
397. </tr>
398. <tr>
399. <th colspan="6"><b><u>ผลการตรวจสุขภาพ / Physical Examination Result </u></b></th>
400. </tr>
401. <tr>
402. <td colspan="6"> ส่วนสูง / Height : <strong> <?=$height?> Cm.</strong> น้ำหนัก / Weight : <strong><?=$weight?> Kg.</strong> ความดันโลหิต / Blood Pressure : <strong><?=$pressure?> mm.hg.</strong> ชีพจร / PR : <strong> <?=$pr?> ครั้ง/นาที</strong></td>
403. </tr>
404. <tr>
405. <th colspan="6"><div align="justify"><strong>1) ผลการตรวจวัณโรคระยะติดต่อ ระยะอันตราย / Tuberculosis, Period of communicability </strong></div></th>
406. </tr>
407. <tr>
408. <td><div align="justify"><strong>
409. <?php
410.
411. if($r11 == "1"){?>
412. <img src="image/13.png" width="20" height="20" />
413. <?php } else if ($r11 != "1"){?>
414. <img src="image/0.png" width="20" height="20" />
415. <?php }else{?>
416. <?php }?>
417. </strong>ปกติ / Normal </div></td>
418. <td colspan="3"><strong>
419. <?php
420.
421. if($r12 == "0"){?>
422. <img src="image/0.png" width="20" height="20" />
423. <?php } else if ($r12 != "0"){?>
424. <img src="image/13.png" width="20" height="20" />
425. <?php }else{?>
426. <?php }?>
427. </strong>ผิดปกติ / Abnormal </td>
428. <td colspan="2"><strong>
429. <?php
430.
431. if($r13 == "0"){?>
432. <img src="image/0.png" width="20" height="20" />
433. <?php } else if ($r13 != "0"){?>
434. <img src="image/13.png" width="20" height="20" />
435. <?php }else{?>
436. <?php }?>
437. </strong>ต้องติดตามการรักษา / Waiting for treatment </td>
438. </tr>
439. <tr>
440. <th colspan="6"><div align="justify"><strong>2) ผลการตรวจโรคเท้าช้าง / Filariasis </strong></div></th>
441. </tr>
442. <tr>
443. <td><div align="justify"><strong>
444. <?php
445.
446. if($r21 == "1"){?>
447. <img src="image/13.png" width="20" height="20" />
448. <?php } else if ($r21 != "1"){?>
449. <img src="image/0.png" width="20" height="20" />
450. <?php }else{?>
451. <?php }?>
452. </strong>ปกติ / Normal </div></td>
453. <td colspan="3"><strong>
454. <?php
455.
456. if($r22 == "0"){?>
457. <img src="image/0.png" width="20" height="20" />
458. <?php } else if ($r22 != "0"){?>
459. <img src="image/13.png" width="20" height="20" />
460. <?php }else{?>
461. <?php }?>
462. </strong>ผิดปกติ / Abnormal </td>
463. <td colspan="2"><strong>
464. <?php
465.
466. if($r23 == "0"){?>
467. <img src="image/0.png" width="20" height="20" />
468. <?php } else if ($r23 != "0"){?>
469. <img src="image/13.png" width="20" height="20" />
470. <?php }else{?>
471. <?php }?>
472. </strong>ต้องติดตามการรักษา / Waiting for treatment </td>
473. </tr>
474. <tr>
475. <th colspan="6"><div align="justify"><strong>3) ผลการตรวจโรคซิฟิลิส / Syphilis </strong></div></th>
476. </tr>
477. <tr>
478. <td><div align="justify"><strong>
479. <?php
480.
481. if($r31 == "1"){?>
482. <img src="image/13.png" width="20" height="20" />
483. <?php } else if ($r31 != "1"){?>
484. <img src="image/0.png" width="20" height="20" />
485. <?php }else{?>
486. <?php }?>
487. </strong>ปกติ / Normal</div></td>
488. <td colspan="3"><strong>
489. <?php
490.
491. if($r32 == "0"){?>
492. <img src="image/0.png" width="20" height="20" />
493. <?php } else if ($r32 != "0"){?>
494. <img src="image/13.png" width="20" height="20" />
495. <?php }else{?>
496. <?php }?>
497. </strong>ผิดปกติ / Abnormal </td>
498. <td colspan="2"><strong>
499. <?php
500.
501. if($r33 == "0"){?>
502. <img src="image/0.png" width="20" height="20" />
503. <?php } else if ($r33 != "0"){?>
504. <img src="image/13.png" width="20" height="20" />
505. <?php }else{?>
506. <?php }?>
507. </strong>ต้องติดตามการรักษา / Waiting for treatment</td>
508. </tr>
509. <tr>
510. <th colspan="6"><div align="justify"><strong>4) ผลการตรวจโรคเรื้อน / Leprosy </strong></div></th>
511. </tr>
512. <tr>
513. <td><div align="justify"><strong>
514. <?php
515.
516. if($r41 == "1"){?>
517. <img src="image/13.png" width="20" height="20" />
518. <?php } else if ($r41 != "1"){?>
519. <img src="image/0.png" width="20" height="20" />
520. <?php }else{?>
521. <?php }?>
522. </strong>ปกติ / Normal </div></td>
523. <td colspan="3"><strong>
524. <?php
525.
526. if($r42 == "0"){?>
527. <img src="image/0.png" width="20" height="20" />
528. <?php } else if ($r42 != "0"){?>
529. <img src="image/13.png" width="20" height="20" />
530. <?php }else{?>
531.
532. <?php }?>
533. </strong>ผิดปกติ / Abnormal </td>
534. <td colspan="2"><strong>
535. <?php
536.
537. if($r43 == "0"){?>
538. <img src="image/0.png" width="20" height="20" />
539. <?php } else if ($r43 != "0"){?>
540. <img src="image/13.png" width="20" height="20" />
541. <?php }else{?>
542. <?php }?>
543. </strong>ต้องติดตามการรักษา / Waiting for treatment </td>
544. </tr>
545. <tr>
546. <th colspan="6"><div align="justify"><strong>5) ผลการตรวจสารเสพติด / Drug addiction </strong></div></th>
547. </tr>
548. <tr>
549. <td><div align="justify"><strong>
550. <?php
551.
552. if($r51 == "1"){?>
553. <img src="image/13.png" width="20" height="20" />
554. <?php } else if ($r51 != "1"){?>
555. <img src="image/0.png" width="20" height="20" />
556. <?php }else{?>
557. <?php }?>
558. </strong>ปกติ / Normal </div></td>
559. <td colspan="3"><strong>
560. <?php
561.
562. if($r52 == "0"){?>
563. <img src="image/0.png" width="20" height="20" />
564. <?php } else if ($r52 != "0"){?>
565. <img src="image/13.png" width="20" height="20" />
566. <?php }else{?>
567. <?php }?>
568. </strong>ผิดปกติ / Abnormal</td>
569. <td colspan="2"><strong>
570. <?php
571.
572. if($r53 == "0"){?>
573. <img src="image/0.png" width="20" height="20" />
574. <?php } else if ($r53 != "0"){?>
575. <img src="image/13.png" width="20" height="20" />
576. <?php }else{?>
577. <?php }?>
578. </strong>ต้องติดตามการรักษา / Waiting for treatment </td>
579. </tr>
580. <tr>
581. <th colspan="6"><div align="justify"><strong>6) ผลการตรวจอาการของโรคพิษสุราเรื้อรัง / Symptoms of chronic alcoholic syndrome</strong></div></th>
582. </tr>
583. <tr>
584. <td><div align="justify"><strong>
585. <?php
586.
587. if($r61 == "1"){?>
588. <img src="image/13.png" width="20" height="20" />
589. <?php } else if ($r61 != "1"){?>
590. <img src="image/0.png" width="20" height="20" />
591. <?php }else{?>
592. <?php }?>
593. </strong>ปกติ / Normal</div></td>
594. <td colspan="3"><strong>
595. <?php
596.
597. if($r62 == "0"){?>
598. <img src="image/0.png" width="20" height="20" />
599. <?php } else if ($r62 != "0"){?>
600. <img src="image/13.png" width="20" height="20" />
601. <?php }else{?>
602. <?php }?>
603. </strong>ผิดปกติ / Abnorma</td>
604. <td colspan="2"><strong>
605. <?php
606.
607. if($r63 == "0"){?>
608. <img src="image/0.png" width="20" height="20" />
609. <?php } else if ($r63 != "0"){?>
610. <img src="image/13.png" width="20" height="20" />
611. <?php }else{?>
612. <?php }?>
613. </strong>ต้องติดตามการรักษา / Waiting for treatment</td>
614. </tr>
615. <tr>
616. <td colspan="6"><div align="justify"><strong>7) สภาพจิตทั่วไป / General Mental Health Status
617. <?php
618.
619. if($r71 == "1"){?>
620. <img src="image/13.png" width="20" height="20" />
621. <?php } else if ($r71 != "1"){?>
622. <img src="image/0.png" width="20" height="20" />
623. <?php }else{?>
624. <?php }?>
625. </strong>ปกติ / Normal <strong>
626. <?php
627.
628. if($r72 == "1"){?>
629. <img src="image/13.png" width="20" height="20" />
630. <?php } else if ($r72 != "1"){?>
631. <img src="image/0.png" width="20" height="20" />
632. <?php }else{?>
633. <?php }?>
634. </strong>ผิดปกติ / Abnormal </div></td>
635. </tr>
636. <tr>
637. <td colspan="6"><div align="justify"><strong>8) ผลการตรวจการตั้งครรภ์ / Pregnancy
638. <?php
639.
640. if($r81 == "0"){?>
641. <img src="image/0.png" width="20" height="20" />
642. <?php } else if ($r81 != "0"){?>
643. <img src="image/13.png" width="20" height="20" />
644. <?php }else{?>
645. <?php }?>
646. </strong>ไม่ตั้งครรภ์ / Negative <strong>
647. <?php
648.
649. if($r82 == "0"){?>
650. <img src="image/0.png" width="20" height="20" />
651. <?php } else if ($r82 != "0"){?>
652. <img src="image/13.png" width="20" height="20" />
653. <?php }else{?>
654. <?php }?>
655. </strong>ตั้งครรภ์ / Positive</div></td>
656. </tr>
657. <tr>
658. <th><div align="justify"><strong>9) การได้ยิน</strong></div></th>
659. <td colspan="3"><strong>
660. <?php
661.
662. if($r91 == "1"){?>
663. <img src="image/13.png" width="20" height="20" />
664. <?php } else if ($r91 != "1"){?>
665. <img src="image/0.png" width="20" height="20" />
666. <?php }else{?>
667. <?php }?>
668. </strong>ปกติ / Normal</td>
669. <td colspan="2"><strong>
670. <?php
671.
672. if($r92 == "0"){?>
673. <img src="image/0.png" width="20" height="20" />
674. <?php } else if ($r92 != "0"){?>
675. <img src="image/13.png" width="20" height="20" />
676. <?php }else{?>
677. <?php }?>
678. </strong>ผิดปกติ / Abnormal </td>
679. </tr>
680. <tr>
681. <th><div align="justify"><strong>10) การมองเห็น</strong></div></th>
682. <td colspan="3"><strong>
683. <?php
684.
685. if($r101 == "1"){?>
686. <img src="image/13.png" width="20" height="20" />
687. <?php } else if ($r101 != "1"){?>
688. <img src="image/0.png" width="20" height="20" />
689. <?php }else{?>
690. <?php }?>
691. </strong>ปกติ / Normal</td>
692. <td colspan="2"><strong>
693. <?php
694.
695. if($r102 == "1"){?>
696. <img src="image/13.png" width="20" height="20" />
697. <?php } else if ($r102 != "1"){?>
698. <img src="image/0.png" width="20" height="20" />
699. <?php }else{?>
700. <?php }?>
701. </strong>ผิดปกติ / Abnormal </td>
702. </tr>
703. <tr>
704. <th colspan="6"><b><u>สรุปผลการตรวจสุขภาพ / Physical Examination Conclusion</u></b></th>
705. </tr>
706. <tr>
707. <td colspan="6"><div align="justify">
708. <?php
709.
710. if($c1 == "1"){?>
711. <img src="image/13.png" width="20" height="20" />
712. <?php } else if ($c1 != "1"){?>
713. <img src="image/0.png" width="20" height="20" />
714. <?php }else{?>
715. <?php }?>
716. ประเภท 1 / Type 1 (ตรวจสุขภาพผ่าน / Pass Healthy) </div></td>
717. </tr>
718. <tr>
719. <td colspan="6"><div align="justify">
720. <?php
721.
722. if($c2 == "0"){?>
723. <img src="image/0.png" width="20" height="20" />
724. <?php } else if ($c2 != "0"){?>
725. <img src="image/13.png" width="20" height="20" />
726. <?php }else{?>
727. <?php }?>
728. ประเภท 2 / Type 2 ( ผ่านการตรวจสุขภาพ แต่ต้องติดตามรักษา / Pass, Must be verify, confirm and treatment) </div></td>
729. </tr>
730. <tr>
731. <td colspan="6"><div align="justify">
732. <?php
733.
734. if($c3 == "0"){?>
735. <img src="image/0.png" width="20" height="20" />
736. <?php } else if ($c3 != "0"){?>
737. <img src="image/13.png" width="20" height="20" />
738. <?php }else{?>
739. <?php }?>
740. ปรเภท 3 / Type 3 (ตรวจสุขภาพไม่ผ่าน / Fail ต้องส่งกลับ / Repatriation)</div></td>
741. </tr>
742. <tr>
743. <td colspan="6"><div align="justify">
744. <?php
745.
746. if($c4 == "0"){?>
747. <img src="image/0.png" width="20" height="20" />
748. <?php } else if ($c4 != "0"){?>
749. <img src="image/13.png" width="20" height="20" />
750. <?php }else{?>
751. <?php }?>
752. ประเภท 3.1 / Type 3.1 สุขภาพไม่สมบูรณ์แข็งแรงเป็นอุปสรรคต่อการทำงานหรือผู้ไม่สามารถหาเลี้ยงชีพได้ เพราะกายพิการ/ </div></td>
753. </tr>
754. <tr>
755. <td colspan="6"><div align="justify"> Unhealthy or Can not earn a living because of physical disabilities</div></td>
756. </tr>
757. <tr>
758. <td colspan="6"><div align="justify">
759. <?php
760.
761. if($c5 == "0"){?>
762. <img src="image/0.png" width="20" height="20" />
763. <?php } else if ($c5 != "0"){?>
764. <img src="image/13.png" width="20" height="20" />
765. <?php }else{?>
766. <?php }?>
767. ประเภท 3.2 Type 3.2/เป็นโรคต้องห้ามมิให้ทำงาน/โรคต้องห้ามเข้าประเทศ Be a prohibited disease for working and stay in Thailand </div></td>
768. </tr>
769. <tr>
770. <td colspan="6"> <span class="style8"> </span>นางวราภรณ์ xxxxxx ลงชื่อ Sign <img src="image/sign2.png" width="30" height="40"> แพทย์ผู้ตรวจ / Physician </td>
771. </tr>
772. <tr>
773. <th colspan="2">วันที่ออกใบรับรองแพทย์ : <b>
774. <?=$printtime?>
775. </b></th>
776. <td colspan="2" class="style8"> พยาบาลวิชาชีพชำนาญการพิเศษ</td>
777. <td colspan="2"> (นายแพทย์สำเนียง xxxx) </td>
778. </tr>
779. <tr>
780. <th colspan="2"><span class="style4"> </span></th>
781. <td colspan="4"> เลขที่ใบประกอบวิชาชีพ / License No. ว.xxxx </td>
782. </tr>
783.</table>
784.<?php } ?>
785.</body>
786.</html>
787.
788.ต้องการสร้าง form ค้นหาระหว่างช่วงที่กำหนด แล้วไป action (printall.php) พิมพ์รายการทั้งหมด พอช่วยหน่อยได้ไม่ครับ. ขอบคุณมาก ๆครับ. _/\_
Load balance : Server 00
