Search Database for particular ID

[Dysan]

Using Ajax and the following code, how do I enable the user to type directly onto a page, without using a text box. Upon each character being entered, how do I search a database for the complete string?

 

If the string corresponds to a id in the database, how do I display a message, notifying the user that a record was found?

 

The following code is what I have so far. This code enables the user to type directly onto a page. How do I add Ajax to the following code, in order to check the ID field in the database for the string entered onto the page?

 

<script type='text/javascript'>
var x=null;
var y=null;
var tId = "";
window.onload = function() {
  x = document.getElementById('x'); 
  y = document.forms[0].copyField; 
  document.onkeypress = myOnKeyPress;
}
function myOnKeyPress(e) {
  e = (e)?e:window.event;
  key = (e.keyCode)? e.keyCode: e.which;
  if (key==27) {
    x.innerHTML =""; // escape pressed to clear the field
    y.value =""; // remove if you do not want to clear field
  }
  else {
    x.innerHTML += String.fromCharCode(key);
    y.value = x.innerHTML;
  }
}
</script>

[phpQuestioner]

well your probably going to at least have to create a hidden input field to record the key strokes. you well need to set up your php page to search your database; do something like this:

 

<?php

// connect
// select db
$hiddenfieldvariable = $_GET['hiddenfieldname'];
$results = mysql_query("select * from where id like '$hiddenfieldvariable%'");
// then go from there

?>