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 />";
}
?>