ค้นหาข้อมูลในฐานข้อมูลโดยใช้ autocomplete ให้แสดงผลลัพธ์ในการค้นหา และเมื่อผลลัพธ์ค้นหาได้หลายหน้าเมื่อคลิกไปหน้าถัดไปให้ได้ผลลัพธ์ที่เราค้นหา

<script type="text/javascript" src="js/jquery-1.4.2.js"></script>
<script type='text/javascript' src="js/jquery.autocomplete.js"></script>
<link rel="stylesheet" type="text/css" href="js/jquery.autocomplete.css" />

<script type="text/javascript">
$().ready(function() {
	$("#place").autocomplete("autoCompleteMain.php", {
		width: 260,
		matchContains: true,
		selectFirst: false
	});
});
</script>

</head>

<?
$objConnect = mysql_connect("localhost"," "," ") or die("Error Connect to Database");
$objDB = mysql_select_db(" ");
$strSQL = "SELECT * FROM place ";
$objQuery = mysql_query($strSQL) or die ("Error Query [".$strSQL."]");
$Num_Rows = mysql_num_rows($objQuery);
$Per_Page = 10;
$Page = $_GET["Page"];
if(!$_GET["Page"])
{
 $Page=1;
 }
 
 $Prev_Page = $Page-1;
 $Next_Page = $Page+1;
$Page_Start = (($Per_Page*$Page)-$Per_Page);
 if($Num_Rows<=$Per_Page)
 {
  $Num_Pages = 1;
  }
else if(($Num_Rows % $Per_Page)==0)
{
$Num_Pages =($Num_Rows/$Per_Page) ;
}
else
{
$Num_Pages =($Num_Rows/$Per_Page)+1;
$Num_Pages = (int)$Num_Pages;
}
$strSQL .=" ORDER BY id_place ASC LIMIT $Page_Start , $Per_Page";
$objQuery  = mysql_query($strSQL);

?>

	
<form method="get" action="#" name="form">
  <table align="center" width="523" border="0">
    <tr><div id="content">

      <td width="162" height="30" ><strong class="style22">ค้นหาสถานที่</strong></td>
      <td width="351"><input type="text" name="place" id="place">
        <input type="Submit"  value="search"  /></td></div>
    </tr>
  </table>
</form>
	  <?
	  
while($objResult = mysql_fetch_array($objQuery))
{
?>
	</p>
	<table width="969" border="2" align="center" cellspacing="0" bordercolor="#663300" bgcolor="#CC9900">
      <tr bordercolor="#FF9933">
        <td width="957" bordercolor="#663300" bgcolor="#CC9933" class="style13"><div align="center">
          <table width="801" border="0">
            <tr>
			<td width="223" rowspan="3"><div align="left"><img src="myfile/<?=$objResult["picture"];?>">&nbsp;</div></td>
              <td colspan="2"><center><?=$objResult["name_place"];?></center></td>
              </tr>
            
            <tr>
              <td width="568"><span class="style21">&nbsp;
                <?=$objResult["detail"];?></span></td>
            </tr>
			<tr>
              <td><div align="right"><a href="detail.php?id_place=<?=$objResult["id_place"];?>"><img src="image/Modify.png" width="24" height="24" /></a></div></td>
            </tr>
          </table>
          </div></td>
      </tr><br >
    </table>
	      <div align="center">
	        <?
}
?>
	        <br>
	          <strong><br>
                <span class="style22">Total 
                <?= $Num_Rows;?> 
                Record : 
                <?=$Num_Pages;?> 
                Page :
	                
                <?

if($Prev_Page)

{
echo " <a href='$_SERVER[SCRIPT_NAME]?Page=$Prev_Page'><< Back</a> ";
}

for($i=1; $i<=$Num_Pages; $i++){

if($i != $Page)
{
echo "[ <a href='$_SERVER[SCRIPT_NAME]?Page=$i'>$i</a> ]";
}
else
{
echo "<b> $i </b>";
}
}
if($Page!=$Num_Pages)
{
echo " <a href ='$_SERVER[SCRIPT_NAME]?Page=$Next_Page'>Next>></a> ";
}
mysql_close($objConnect);
?>

<?php
$host="localhost"; // Host name
$username=""; // Mysql username
$password=""; // Mysql password
$db_name=""; // Database name


	$con = mysql_connect($host,$username,$password)   or die(mysql_error());
	mysql_select_db($db_name, $con)  or die(mysql_error());

$q = strtolower($_GET["q"]);
if (!$q) return;

$sql = "select DISTINCT name_place from place where name_place LIKE '%$q%'";
$rsd = mysql_query($sql);
while($rs = mysql_fetch_array($rsd)) {
	$cname = $rs['name_place'];
	echo "$cname\n";
}
?>