0

i hav this code for autosuggest..
it retrieves the desired values from the datbase..
and produces a list..like in google..

however the values in the list cannot be selected using the arrow keys..
could anybody familiar with google suggest help me out with this..

am using this for an textbox in html file..!!

thanks in advance..

/*livesearch.js*/
var xmlhttp;

function showResult(str)
{
if (str.length==0)
  {
  document.getElementById("livesearch").innerHTML="";
  document.getElementById("livesearch").style.border="0px";
  return;
  }
xmlhttp=GetXmlHttpObject()
if (xmlhttp==null)
  {
  alert ("Your browser does not support XML HTTP Request");
  return;
  }
var url="livesearch.php";
url=url+"?q="+str;
url=url+"&sid="+Math.random();
xmlhttp.onreadystatechange=stateChanged ;
xmlhttp.open("GET",url,true);
xmlhttp.send(null);
}
function stateChanged()
{
if (xmlhttp.readyState==4)
  {
  document.getElementById("livesearch").innerHTML=xmlhttp.responseText;
  document.getElementById("livesearch").style.border="1px solid #A5ACB2";
 // document.getElementById("livesearch").style.cursor="default";
  }
}

function GetXmlHttpObject()
{
if (window.XMLHttpRequest)
  {
  // code for IE7+, Firefox, Chrome, Opera, Safari
  return new XMLHttpRequest();
  }
if (window.ActiveXObject)
  {
  // code for IE6, IE5
  return new ActiveXObject("Microsoft.XMLHTTP");
  }
return null;
}
/*livesearch.php*/
<?php

$strSearchVal = $_GET['q'];

if (strlen($strSearchVal) < 1) {
 return false;
}

// Opens a connection to a MySQL server
$connection=mysql_connect ("localhost", "root", "");
if (!$connection) {
  die('Not connected : ' . mysql_error());
}
// Sanitize User Input for Security
$strSearchVal = mysql_real_escape_string($strSearchVal);


// Set the active MySQL database
$db_selected = mysql_select_db("hospitals_info", $connection);
if (!$db_selected) {
  die ('Can\'t use db : ' . mysql_error());
}

$strSQL = "SELECT DISTINCT area FROM hospital WHERE area like '$strSearchVal%'";
$result = mysql_query($strSQL)
or
 die("Query to get blah failed with error: ".mysql_error());


while ($a=mysql_fetch_array($result)) {
 echo  $a['area']."<br />";
}



?>

Edited by Ezzaral: Fixed code tag.

2
Contributors
1
Reply
2
Views
7 Years
Discussion Span
Last Post by sam023
0

auto suggest and auto autocomplete are two different things..!! try to google for autocomplete script

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.