2. $(document).ready(function() {
3. $("#cmntclientnameauto").autocomplete({
4. minLength: 3,
5. source: "ajax/clientlist.php", // Pull in names and addresses
6. select: function( e, ui ){ // When we select one
7. var keyvalue = ui.item.value;
8. $.post("ajax/readclient.php",{id:keyvalue},
9. function(data){
10. // Pull in the data
11. },"json"
12. );
13. }
14. });
15. });

This works great I get great looking menu style lists and it selects the info and sends it to readclient.php

Here is clientlist.php to give me the list to select from.

2. $term = trim(strip_tags($_GET['term'])); // Need for the jQuery Autocomplete
3. // Open the database
4. $db = mysql_connect($hostname, $idname, $idpass);
5. if (!$db) die(mysql_errno($db).": ".mysql_error($db)."\n");
6. mysql_select_db($dbname);
7. $sql = "SELECT DISTINCT Last_Name, First_Name, Address1, City, Prov_State, Postal, Client_ID, Phone FROM clients WHERE Last_Name LIKE '".$term."%' AND del_flag = 0 ORDER BY Last_Name";
8. $q0 = mysql_query($sql);
9. if (!$q0){error_log($sql,0);}
10. else {
11.     $json = '[';
12.     $first = true;
13.     while ($row = mysql_fetch_assoc($q0)) {
14.         if (!$first) { $json .=  ','; }
15. else { $first = false; }
16. $json .= sprintf('{"value":"%s, %s, %s, %s, %s, %s, %d, %s"}',
17. $row['Last_Name'], $row['First_Name'], $row['Address1'], $row['City'], $row['Prov_State'], $row['Postal'], $row['Client_ID'], $row['Phone']);
18.     }
19.     $json .= ']';
20. }
21. echo $json;
22. 
    

Like I said it works great to populate the selection menu.

Here is the readclient.php ajax script which reads the selection from above.

2. $c = trim(strip_tags($_POST['id']));
3. $client = explode(',',$c);
4. $cid = $client[6];      // see the Client_ID field in clientlist.php
5. // Open the database
6. $db = mysql_connect($hostname, $idname, $idpass);
7. if (!$db) die("Could NOT connect\n");
8. mysql_select_db($dbname);
9. $sql = sprintf("SELECT * FROM clients WHERE Client_ID = %d",$flds,$cid);
10. $q0 = mysql_query($sql);
11. if (!$q0){error_log($sql . ', ' . mysql_errno($db).": ".mysql_error($db),0);}
12. else {$row = mysql_fetch_array($q0);}
13. echo json_encode($row);
14. 
    

This code also works great. It returns the data record and I populate the form.

No rocket science here!! Almost textbook because I got the code from jQuery autocomplete examples.

Only problem now it doesn't work in 1.9.1. I currently am having extreme issues with 1.9.2 so I can't see if they fixed it.

HELP! I need my autocomplete. I have huge databases!