01.<html>
02.<head>
03.<title>ThaiCreate.Com PHP & MySQL Tutorial</title>
04. <script language="javascript">
05. function selData(intLine,mem_id,mem_name)
06. {
07. var smem_id = self.opener.document.getElementById("txtCustomerID_" +intLine);
08. smem_id.value = mem_id;
09.
10. var smem_name = self.opener.document.getElementById("txtName_" +intLine);
11. smem_name.value = mem_name;
12.
13. window.close();
14. }
15. </script>
16.</head>
17.<body>
18.<form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>">
19. <div align="center">
20. <table width="599" border="1">
21. <tr>
22. <th>Keyword
23. <input name="txtKeyword" type="text" id="txtKeyword" value="<?=$_GET["txtKeyword"];?>">
24. <input type="submit" value="Search"></th>
25. </tr>
26. </table>
27. </div>
28.</form>
29.<div align="center">
30. <?
31.if($_GET["txtKeyword"] != "")
32. {
33. $objConnect = mysql_connect("localhost","root","1234") or die("Error Connect to Database");
34. $objDB = mysql_select_db("library");
35. mysql_query("SET character_set_results=tis620");
36.mysql_query("SET character_set_client='tis620'");
37.mysql_query("SET character_set_connection='tis620'");
38.mysql_query("collation_connection = tis620_thai_ci");
39.mysql_query("collation_database = tis620_thai_ci");
40.mysql_query("collation_server = tis620_thai_ci");
41.
42. $strSQL = "SELECT * FROM member WHERE (mem_id LIKE '%".$_GET["txtKeyword"]."%' or mem_name LIKE '%".$_GET["txtKeyword"]."%' )";
43. $objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
44. ?>
45. <table width="557" border="1">
46. <tr>
47. <th width="49">ลำดับ</th>
48. <th width="235"> <div align="center">รหัสประจำตัวประชาชน</div></th>
49. <th width="159"> <div align="center">ชื่อ - สกุล </div></th>
50. <th width="86"> <div align="center">เลือกข้อมูล </div></th>
51. </tr>
52.<?
53.$i = 1;
54.if($Page > 1)
55.{
56. $i = ($Per_Page * ($Page-1)) + 1;
57.}
58.while($objResult = mysql_fetch_array($objQuery))
59.{
60.?>
61. <tr>
62. <td><? echo $i; ?></td>
63. <td><div align="center"><?=$objResult["mem_id"];?></div></td>
64. <td><?=$objResult["mem_name"];?></td>
65. <td><div align="center"><a href="#" OnClick="selData('<?=$_GET["Line"];?>' ,'<?=$objResult["mem_id"];?>', '<?=$objResult["mem_name"];?>');">
66. <img src="../images/true.png">
67. </a></td>
68. </tr>
69.<?
70. $i++;
71.}
72.?>
73. </table>
74.
75. <?
76. mysql_close($objConnect);
77.}
78.?>
79.
80.</div>
81.</body>
82.</html>
