New at this ..Question using with php

New at this ..Question using with php

I am new at this so this might seem like a stupid question.  How do I pass the value in my auto complete text box to my php script ? (see code below).

index.html
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml">

  5. <head>
  6. <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
  7. <title>Ajax Auto Suggest</title>

  9. <script type="text/javascript" src="http://ajax.googleapis.com/ajax/
  10. libs/jquery/1.3.0/jquery.min.js"></script>
  11. <script type="text/javascript">
  12. function lookup(inputString) {
  13. if(inputString.length == 0) {
  14. // Hide the suggestion box.
  15. $('#suggestions').hide();
  16. } else {
  17. $.post("rpc.php", {queryString: ""+inputString+""}, function(data){
  18. if(data.length >0) {
  19. $('#suggestions').show();
  20. $('#autoSuggestionsList').html(data);
  21. }
  22. });
  23. }
  24. } // lookup
  26. function fill(thisValue) {
  27. $('#inputString').val(thisValue);
  28. setTimeout("$('#suggestions').hide();", 200);
  29. }
  30. </script>

  32. <style type="text/css">
  33. body {
  34. font-family: Helvetica;
  35. font-size: 11px;
  36. color: #000;
  37. }
  39. h3 {
  40. margin: 0px;
  41. padding: 0px;
  42. }

  44. .suggestionsBox {
  45. position: relative;
  46. left: 30px;
  47. margin: 10px 0px 0px 0px;
  48. width: 200px;
  49. background-color: #212427;
  50. -moz-border-radius: 7px;
  51. -webkit-border-radius: 7px;
  52. border: 2px solid #000;
  53. color: #fff;
  54. }
  56. .suggestionList {
  57. margin: 0px;
  58. padding: 0px;
  59. }
  61. .suggestionList li {
  63. margin: 0px 0px 3px 0px;
  64. padding: 3px;
  65. cursor: pointer;
  66. }
  68. .suggestionList li:hover {
  69. background-color: #659CD8;
  70. }
  71. </style>

  73. </head>

  75. <body>


  78. <div>
  79. <Form action="insert_new_number.php" method="POST">
  80. <div>
  81. Company Code:
  82. <br />
  83. <input type="text" size="30" value="" id="inputString" name="custid" onkeyup="lookup(this.value);" onblur="fill();" />
  84. </div>
  86. <div class="suggestionsBox" id="suggestions" style="display: none;">
  87. <img src="upArrow.png" style="position: relative; top: -12px; left: 30px;" alt="upArrow" />
  88. <div class="suggestionList" id="autoSuggestionsList">
  89. &nbsp;
  90. </div>
  91. </div>
  92.                      <input type="submit" />
  93. </form>
  94. </div>

  96. </body>
  97. </html>

RPC.php

  2. <?php
  4. // PHP5 Implementation - uses MySQLi.
  5. // mysqli('localhost', 'yourUsername', 'yourPassword', 'yourDatabase');
  6. $db = new mysqli('localhost', 'xxxxxxx' ,'xxxxxxxx', 'xxxxxxx');
  8. if(!$db) {
  9. // Show error if we cannot connect.
  10. echo 'ERROR: Could not connect to the database.';
  11. } else {
  12. // Is there a posted query string?
  13. if(isset($_POST['queryString'])) {
  14. $queryString = $db->real_escape_string($_POST['queryString']);
  16. // Is the string length greater than 0?
  18. if(strlen($queryString) >0) {
  20. $query = $db->query("SELECT Customer_Code FROM data WHERE Customer_Code LIKE '$queryString%' LIMIT 10");
  21. if($query) {
  23. while ($result = $query ->fetch_object()) {
  25. echo '<li onClick="fill(\''.$result->Customer_Code.'\');">'.$result->Customer_Code.'</li>';
  26.                                         
  27.                                                 }
  28. } else {
  29. echo 'ERROR: There was a problem with the query.';
  30. }
  31. } else {
  32. // Dont do anything.
  33. } // There is a queryString.
  34. } else {
  35. echo 'There should be no direct access to this script!';
  36. }
  37. }
  38. ?>
insert_new_number.php is the script I want to send the data to, from the ajax auto complete text box.  I just can't figure out how to do it.

Thanks