This project received 9 bids from talented freelancers with an average bid price of $121 USD.

Get free quotes for a project like this
Employer working
Skills Required
Project Budget
$30 - $250 USD
Total Bids
Project Description

Must use jQuery UI [url removed, login to view] for this and not a custom solution
Your solution will wrap around this but the original jquery autocomplete .js must not be altered

We are looking for jQuery autocomplete function to include in our framework however we must create a more portable function that we can use based on our database contents.

Sometimes we will query customer names, sometimes states or countries. We are looking for a javascript function that we can wrap around the core jQuery UI Autocomplete allowing us to pass a SELECT query string along with css, width, height, background, color and have the dropdown be available.

* When the viewer clicks on a field, the mysql database is queried via Ajax / PHP
* The result list comes back for viewing in the autocomplete dropdown menu
* We must be able to control css styling of the dropdown window and rows via variables in the function call.
* The number of fields displayed/visible in the row may be less than the fields requested in the SQL statement. For instance, we may select $sql='field1,field2,field3,field4' for results, but only display field1,field2 in the row. We may indicate this by passing a both an $SELECT variable and a $FIELDS_VISIBLE variable.
* We must have a callback function so we may manipulate data based on the row choice. Each field in the row returned should be passed to that function in an array equal to the length of the fields returned in that rows result from the $SELECT statement .

* The dropdown must be able to be triggered by either ID(#) or CLASS(.) for any textfield
* We must have a final callback function that receives the data of the row that is selected

The SQL is a little tricky because we wish for the visible row to be only the fields we may pass in the variable 'fieldsVisible' however the data passed to the final callback function should include all fields from the select statement.

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online