Ajax live search with PHP

Question

I have tried live search from http://www.w3schools.com/php/php_ajax_livesearch.asp and i an struck in i need to get on mouse up and mouse down function for this code and i as i am new to ajax ...

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

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;
}

Answer 1

Please, don't write your own code to do XmlHttpRequests. Use a library - jQuery is fantastic for exactly this purpose. jQuery also has great hooks to fire javascript handlers in response to keyboard and mouse events.

Answer 2

Use jQuery with the autocomplete plugin:

http://docs.jquery.com/Plugins/Autocomplete

Answer 3

Hi....

This example is dealing with the text file what about the MySQL database? Could you show me some example with MySQL database. THanks in advance

Answer 4

Try this one. http://code.drewwilson.com/entry/autosuggest-jquery-plugin It's cool.