001.<CENTER><form name="frmSearch" method="get" action="<?=$_SERVER['SCRIPT_NAME'];?>">
002. <table width="599" border="1">
003. <tr>
004. <th>Keyword <select name="txtKeyword">
005. <option value="TUMBON" <? if($txtKeyword=="TUMBON"){ ?>selected<? }?>>µÓºÅ</option>
006. <option value="IDM" <? if($txtKeyword=="IDM"){ ?>selected<? }?>>ÃËÑʺѵûÃЪҪ¹</option>
007. <option value="PNAME" <? if($txtKeyword=="PNAME"){ ?>selected<? }?>>ª×èͺؤ¤Å</option>
008. <option value="tCalendar " <? if($txtKeyword=="tCalendar "){ ?>selected<? }?>>Çѹà¡Ô´¼Ùé¢Öé¹·ÐàºÕ¹</option>
009. <option value="DAY2 " <? if($txtKeyword=="DAY2 "){ ?>selected<? }?>>à´×͹·Õè¢Öé¹·ÐàºÕ¹</option>
010. <option value="DAY3 " <? if($txtKeyword=="DAY3 "){ ?>selected<? }?>>»Õ·Õè¢Öé¹·ÐàºÕ¹</option>
011. <!-- <option value="MOO " <? if($txtKeyword=="MOO "){ ?>selected<? }?>>ËÁÙè·Õè</option> -->
012.</select>
013.<input name="Search" type="text" size="20" value="<? echo $Search?>">
014. <input type="submit" name="submit" value="Search"> <a href="#" class="hintanchor" onMouseover="showhint('¤é¹¨Ò¡ ª×èÍâ´ÂµÃ§/ ¾.È·Õèà¡Ô´/ ª×è͵ӺŠ/ÃËÑʺѵûÃЪҪ¹ 13 ËÅÑ¡/Çѹ·Õèŧ·ÐàºÕ¹/à´×͹/»Õ àÅ×Í¡ 1 ¤Ó¤é¹ËÒà·èÒ¹Ñé¹', this, event, '150px')">[?]</a>
015.
016.
017.<BR><BR>
018.<font size='2' face='MS Sans Serif' color="#000000" ><a href="index.php" ><strong>˹éÒËÅÑ¡</strong></font>
019.
020.<font size='2' face='MS Sans Serif' color="#000000" ><a href="Register.php" target="_blank"><strong>à¾ÔèÁ¢éÍÁÙÅ</strong></font>
021.
022.<font size='2' face='MS Sans Serif' color="#000000" ><a href="show_a.php" target="_blank"><strong>´Ù¢éÍÁÙÅ·Ñé§ËÁ´</strong></font> <BR><BR>
023. </a>
024. </tr>
025. </table>
026.</form></CENTER>
027.
028.<?
029.if($_GET["txtKeyword"] != "")
030. {
031. $objConnect = mysql_connect("localhost","root","") or die("Error Connect to Database");
032. $objDB = mysql_select_db("bass");
033. mysql_query("SET NAMES UTF8");
034.mysql_query("SET character_set_results='tis620'");
035.mysql_query("SET character_set_client='tis620'");
036.mysql_query("SET character_set_connection='tis620'");
037.mysql_query("collation_connection = tis620_thai_ci");
038.mysql_query("collation_database = tis620_thai_ci");
039.mysql_query("collation_server = tis620_thai_ci");
040.
041. $strSQL = "SELECT * FROM history WHERE (IDM LIKE '%".$_GET["Search"]."%' or PNAME LIKE '%".$_GET["Search"]."%' or TUMBON LIKE '%".$_GET["Search"]."%'or tCalendar LIKE '%".$_GET["Search"]."%'or MOO LIKE '%".$_GET["Search"]."%'or DAY2 LIKE '%".$_GET["Search"]."%'or DAY3 LIKE '%".$_GET["Search"]."%')";
042.
043.$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
044.$Num_Rows = mysql_num_rows($objQuery);
045.echo "<font size='4' face='MS Sans Serif' color='#000000' ><strong> áÊ´§¼Å¡Òäé¹ËÒ¢éÍÁÙÅ·ÕèÁÕ¤ÓÇèÒ<strong> ". $_GET["Search"];" </font>";
046.$Per_Page = 2;
047.
048.$Page = $_GET["Page"];
049.if(!$_GET["Page"])
050.{
051. $Page=1;
052.}
053.
054.$Prev_Page = $Page-1;
055.$Next_Page = $Page+1;
056.
057.$Page_Start = (($Per_Page*$Page)-$Per_Page);
058.if($Num_Rows<=$Per_Page)
059.{
060. $Num_Pages =1;
061.}
062.else if(($Num_Rows % $Per_Page)==0)
063.{
064. $Num_Pages =($Num_Rows/$Per_Page) ;
065.}
066.else
067.{
068. $Num_Pages =($Num_Rows/$Per_Page)+1;
069. $Num_Pages = (int)$Num_Pages;
070.}
071.
072.$strSQL .=" order by id ASC LIMIT $Page_Start , $Per_Page";
073.$objQuery = mysql_query($strSQL);
074.while($row_show = mysql_fetch_array($objQuery))
075.{
076.
077.echo"<table width='1000' border='1' height='100%' >";
078.echo"<tr bgcolor=#FF99FF>";
079.
080.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ÅӴѺ·Õè</strong>".$row_show['id'];
081.echo "</font>";
082.echo" ";
083. echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong>Çѹ·Õè</strong> ".$row_show['DAY1']; echo "</font>";
084.echo" ";
085. echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong>à´×͹</strong> ".$row_show['DAY2']; echo "</font>";
086.echo" ";
087. echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong>¾.È.</strong> ".$row_show['DAY3']; echo "</font>";
088.echo" <BR><BR>";
089.
090.echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong>ª×èÍ-¹ÒÁÊ¡ØÅ</strong> ".$row_show['PTNAME'].$row_show['PNAME'];
091.echo "</font>";
092. echo" ";
093.echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong></strong> ".$row_show['LNAME'];
094.echo "</font>";
095.echo" ";
096.echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong>Çѹ·Õèàà¡Ô´</strong> " . $row_show['tCalendar'];echo "</font>";
097.echo" ";
098.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ÍÒÂØ</strong>" .$row_show['TOTAL'];echo "</font>";
099.echo" ";
100.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ÊѪҵÔ</strong>" .$row_show['NATIONAL'];echo "</font>";
101.echo" ";
102.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>àºÍÃìµÔ´µèÍ </strong>077-" .$row_show['MOBILE'];echo "</font>";
103.echo" ";
104.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>àºÍÃìµÔ´µèÍ </strong>08" .$row_show['PHONE'] ;echo "</font>";
105.echo"<BR><BR>";
106.echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong>ÃËÑʺѵûÃЪҪ¹</strong>" .$row_show['IDM'];echo "</font>";
107.echo" ";
108.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>·ÕèÍÂÙè</strong>" ;echo "</font>";
109. echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ºéÒ¹àÅ¢·Õè</strong>" .$row_show['IDHOME'] ;echo "</font>";
110. echo" ";
111. echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ËÁÙè</strong>" . $row_show['MOO'];echo "</font>";
112. echo" ";
113. echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>«ÍÂ</strong>" .$row_show['ZOY'] ;echo "</font>";
114. echo" ";
115. echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>µÓºÅ</strong>" . $row_show['TUMBON'];echo "</font>";
116. echo" ";
117. echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>¶¹¹</strong>" .$row_show['ROAD']; echo "</font>";
118. echo" ";
119. echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ÍÓàÀÍ</strong>" .$row_show['ARUMPER'] ;echo "</font>";
120. echo" ";
121. echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>¨Ñ§ËÇÑ´</strong>" . $row_show['PROVINE'];echo "</font>";
122. echo" ";
123. echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ÃËÑÊä»ÃɳÕÂì</strong>" . $row_show['BOT'];echo "</font>";
124.echo"<BR><BR>";
125.
126.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ʶҹÐÀÒ¾</strong>" . $row_show['RASO'];echo "</font>";
127.echo" ";
128.echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong>ºØ¤¤Å·ÕèÊÒÁÒöµÔ´µèÍ</strong>" .$row_show['TAITEL'] .$row_show['TNAME'];echo "</font>";
129. echo" ";
130. echo " <font size='2' face='MS Sans Serif' color='#000000' >".$row_show['TUNAME'];echo "</font>";
131.echo" ";
132.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>à¡ÕèÂÇ¢éͧà»ç¹</strong>" . $row_show['SO'];echo "</font>";
133.echo" ";
134.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>àºÍÃìµÔ´µèÍ </strong>08".$row_show['MOBILE1'];echo "</font>";
135.echo" ";
136.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>àºÍÃìµÔ´µèÍ </strong>077-".$row_show['PHONE1'];echo "</font>";
137.echo"<BR><BR>";
138.echo "<font size='2' face='MS Sans Serif' color='#000000' ><strong>ʶҹСÒÃÃѺàºÕéÂÂѧªÕ¾</strong>" .$row_show['YES'];echo "</font>";
139.echo" ";
140.echo " <font size='2' face='MS Sans Serif' color='#000000' ><strong>ÃٻẺ¡ÒÃÃѺà§Ô¹</strong>" . $row_show['MANNY'];echo "</font>";
141.echo"<BR><BR>";
142.echo" ";
143.
144.echo"<BR><BR>";
145.echo "<a href='edit.php?edit_id=$row_show[id]' target='_blank' ><IMG SRC='images/postnews.gif' ALT='á¡éä¢' > </a>";echo "</font>";
146.echo" ";
147.echo "<a href='prin.php?edit_id=$row_show[id]' target='_blank' ><IMG SRC='images/printer.jpg' ALT='¾ÔÁ¾ì'> </a>";echo "</font>";
148.echo" ";
149.echo " <a href='delete.php?del_id=$row_show[id]' ><IMG SRC='images/delete.gif' ALT='ź' onClick='return Conf(this)');></a>";echo "</font>";
150.}
151.echo"</tr >";
152.echo"<table >";
153.
154.
155.
156.?>
157.<br>
158.¤é¹¾º¢éÍÁÙÅ:<?= $Num_Rows;?> ÃÒ¡Òà <BR>àÅ×͡˹éÒ·Õè :
159.<?
160.if($Prev_Page)
161.{
162. echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> ";
163.}
164.
165.for($i=1; $i<=$Num_Pages; $i++){
166. if($i != $Page)
167. {
168. echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
169. }
170. else
171. {
172. echo "<b> $i </b>";
173. }
174.}
175.if($Page!=$Num_Pages)
176.{
177. echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> ";
178.}
179.mysql_close($objConnect);
180.
181.}
182.?>
183.</CENTER><BR>
