01.<fieldset class="field_bar" >
02. <input type="hidden" name="p" id="p" value="members">
03. <label for="member_code"></label>
04. <select name="tbSelect" id="tbSelect">
05. <option value="1" selected <?php if(isset($_GET["tbSelect"]) == "member_code") {echo 'selected';}?>> เลือก (แสดงทั้งหมด)</option>
06. <option value="member_code" <?php if(isset($_GET["tbSelect"]) == "member_code") {echo 'selected';}?>> เลขบัตรประชาชน</option>
07.
08. <option value="member_name" <?php if(isset($_GET["tbSelect"]) == "member_name") {echo 'selected';}?>> ชื่อ</option>
09.
10. <option value="member_lastname" <?php if(isset($_GET["tbSelect"]) == "member_lastname") {echo 'selected';}?>> นามสกุล</option>
11.
12. <option value="member_subdistrict" <?php if(isset($_GET["tbSelect"]) == "member_subdistrict") {echo 'selected';}?>> เขต / อำเภอ</option>
13.
14. <option value="member_address" <?php if(isset($_GET["tbSelect"]) == "member_address") {echo 'selected';}?>> วินจักรยานยนต์</option>
15. </select>
16. <input name="txtKey" type="text" autofocus class="aqua_textfield3" id="txtKey" placeholder="พิมพ์เพื่อค้นหา แล้วกด Enter" style="" autocomplete="off" value="<?php isset($_GET["txtKey"]) ?>">
17. <input type="submit" class="button green" value="ค้นหา">
18. </fieldset>
19. <link rel="stylesheet" type="text/css" href="../css/style2.css" />
20. <div class="field_invisible">
21. <table width="100%" border="0">
22. <tr class="aqua_treatment_text_header">
23. <td width="8%">รูปถ่าย</td>
24. <td width="8%">เลขที่บัตรประชาชน</td>
25. <td width="15%">ชื่อ-สกุล</td>
26. <td width="15%">ชื่อ-สกุล(อังกฤษ)</td>
27. <td width="8%">เขต / อำเภอ</td>
28. <td width="17%" align="center">วินจักรยานยนต์</td>
29. <td width="7%" align="center">ทะเบียน</td>
30. <td width="20%">รายละเอียด</td>
31. </tr>
32. <?PHP
33.$page = empty($_GET['page']) ? 1 : $_GET['page'];
34.$search = ! empty($_GET['member_code']) ? htmlspecialchars($_GET['member_code']) : NULL;
35.
36.$query = "select * from member where 1";
37.
38. if (isset($_GET["tbSelect"]) !="" and isset($_GET["txtKey"]) !=""){
39. $query .= " AND (" . $_GET["tbSelect"] . " LIKE '%" . $_GET["txtKey"] . "%') ";
40. }
41. $objQuery = mysql_query($query) or die("ไม่สามารถค้นหาได้ [" . $query . "] ");
42.$sql = mysql_query($query);
43.$total_records = mysql_num_rows($sql);
44.$scroll_page = 5;
45.$per_page = 10;
46.$current_page = $page;
47.$pager_url = '?p=members&tbSelect='.$_GET["tbSelect"].'&txtKey='.$_GET["txtKey"].'&page=';
48.$inactive_page_tag = 'id="current_page"';
49.$previous_page_text = '< ย้อนกลับ';
50.$next_page_text = 'ถัดไป >';
51.$first_page_text = '<< หน้าแรก';
52.$last_page_text = 'หน้าสุดท้าย >>';
53.
54.$kgPagerOBJ = new kgPager(); #เรียกใช้งาน class
55.$kgPagerOBJ -> pager_set($pager_url, $total_records, $scroll_page, $per_page, $current_page, $inactive_page_tag, $previous_page_text, $next_page_text, $first_page_text, $last_page_text, $pager_url_last);
56.$sql = mysql_query($query." ORDER BY member_code LIMIT ".$kgPagerOBJ -> start.", ".$kgPagerOBJ -> per_page."");
57.while ($read = mysql_fetch_assoc($sql)) {
58. #-------------ส่วนแสดงผล--------------#
59. if($read['member_status'] != 1){
60. $bg = 'bgcolor="#CCCCCC"';
61. }else{
62. $bg = 'bgcolor="#8DC2FF"';
63. }
64. ?>
65. <tr class="aqua_treatment_text" id="<?php echo $read['member_key']?>">
66. <td align="center" <?php echo @$bg;?>><img src="../resource/members/thumbs/<?php echo $read['member_photo']?>" width="50" alt="" id="photo_border"/></td>
67. <td align="center" <?php echo @$bg;?>><?php echo $read['member_code']?></td>
68. <td <?php echo @$bg;?>> <?php echo $read['member_prefix'].$read['member_name']." ".$read['member_lastname'];?></td>
69. <td <?php echo @$bg;?>> <?php echo $read['member_prefix_en'].$read['member_name_en']." ".$read['member_lastname_en'];?></td>
70. <td align="center" <?php echo @$bg;?>><?php echo $read['member_subdistrict'];?></td>
71. <td align="center" <?php echo @$bg;?>> <?php echo $read['member_address'];?></td>
72. <td align="center" <?php echo @$bg;?>><?php echo $read['member_licence_a'].$read['member_licence_b']." <br>".$read['member_licence_c']?></td>
73. <td align="center" <?php echo @$bg;?>><a href="?p=payaqua&member_code=<?php echo $read['member_code'];?>"><div class="button_symbol green"><img src="../media/icons/set/white/right2.png" width="25" height="25" alt="" title="ข้อมูลสมาชิกวินจักรยานยนต์"/></div></a><a href="?p=register_subjects&key=<?php echo $read['member_key'];?>"><div class="button_symbol brown"><img src="../media/icons/set/white/treatment.png" width="25" height="25" alt="" title="ลงทะเบียนเรียน"/></div></a><a href="../modules/members/print.php?key=<?php echo $read['member_key'];?>" target="_blank"><div class="button_symbol yellow"><img src="../media/icons/set/white/print.png" width="25" height="25" alt="" title="พิมพ์บัตรสมาชิก"/></div></a><a href="?p=member_detail&key=<?php echo $read['member_key'];?>"><div class="button_symbol green"><img src="../media/icons/set/white/detail.png" width="25" height="25" alt="" title="รายละเอียด"/></div></a>
74. <div class="button_symbol red" onClick="javascript:deleteMember('<?php echo $read['member_key'];?>');"><img src="../media/icons/set/white/delete1.png" width="25" height="25" alt="" title="ลบ"/></div></td>
75. </tr>
76. <?php
77. }
78. ?>
79.</table>
80. <?php
81.#------ตัวแบ่งหน้า คือ <ก่อนหน้า , 1 , 2 , 3 , ต่อไป> จะเอาไปแปะตรงไหนก็ได้ในหน้าเพจ----#
82.echo '<p id="pager_links">';
83.echo $kgPagerOBJ -> first_page;
84.echo $kgPagerOBJ -> previous_page;
85.echo $kgPagerOBJ -> page_links;
86.echo $kgPagerOBJ -> next_page;
87.echo $kgPagerOBJ -> last_page;
88.#-------------ส่วนแสดงผลจำนวน record ทั้งหมด--------------#
89.echo '<strong> จำนวนแถว : </strong>';
90.echo $kgPagerOBJ -> total_records; echo '<strong> แถว</strong>';
91.echo ' <strong>จำนวน : </strong>';
92.echo $kgPagerOBJ -> total_pages; echo '<strong> หน้า</strong>';
93.#-------------จบส่วนแสดงผลจำนวน record ทั้งหมด--------------#
94.?>
95. </div>
