troubleshooting Question

Migrate jQuery Autocomplete to jQuery UI Autocomplete

Avatar of lhutton
lhutton asked on
JavaScriptAJAXjQuery
2 Comments1 Solution653 ViewsLast Modified:
How can I migrate the attached snippets of code from jQuery Autocomplete to jQuery UI Autocomplete using the Autocomplete Migration Guide?
<script language="JavaScript" type="text/javascript">
<!--//
 $(document).ready(function(){
	 $("#searchfield").autocomplete("include/ajax-functions.php",{max:999,minChars:2,extraParams: {action: "searchAutoComplete"}});
 });
//-->
</script>


* ajax-functions.php *
  case('searchAutoComplete'):
	 $fields = array('user_id','email','name_last');
	 $search = $_GET['q'];
	 $list = array();
     foreach ($fields as $this_field){
       $rs = mysql_query("SELECT * FROM $usertable WHERE " . $this_field . " LIKE \"$search%\" ORDER BY " . $this_field . " ASC");
       while ($row = mysql_fetch_array($rs)){
		  $list[] = $row["$this_field"];
	   }
	  }
      $rtn = array_unique($list); // remove any duplicates from results
	  echo implode("\n",$rtn); // return array as a multi-line string
	 break; // end searchAutoComplete
ASKER CERTIFIED SOLUTION
Proculopsis

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros