Awarded

JQUERY UI AUTOCOMPLETE - with MYSQL / AJAX

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.

Skills: AJAX, jQuery / Prototype, PHP

See more: jquery autocomplete mysql, jquery autocomplete ajax, jquery autocomplete php mysql call, jquery autocomplete php mysql, jquery autocomplete mysql database, jquery autocomplete ajax mysql, autocomplete mysql, jquery autocomplete ajax php, autocomplete mysql ajax, ajax jquery autocomplete php mysql, autocomplete ajax php mysql, jquery autocomplete mysql php, jquery ajax autocomplete dropdown php, ajax php autocomplete sql, jquery autocomplete countries states php, jquery autocomplete color row, jquery autocomplete dropdown mysql, jquery autocomplete mysql ajax, jquery autocomplete, autocomplete jquery mysql, jquery autocomplete ajax callback php, jquery autocomplete php ajax, autocomplete jquery php mysql, this class jquery, php autocomplete

About the Employer:
( 57 reviews ) Anacortes, United States

Project ID: #1199010

9 freelancers are bidding on average $121 for this job

jDevAndDesign

please check your pmb

$120 USD in 3 days
(148 Reviews)
6.6
gopalvora

Hi ready to start Thanks

$80 USD in 4 days
(132 Reviews)
6.7
khanhhuyna

I'm a jquery/php/mysql developer and completely confident to do this for you. Thanks.

$120 USD in 3 days
(93 Reviews)
6.4
laleshii

Hello ! Please check PMB for my offer ! Thank you !

$100 USD in 0 days
(6 Reviews)
4.0
HardwareDesign

Hi I m a PHP5/codeingiter Framework/Ajax/Jquery/Mysql developer I m familiar with this function i buit it with Codeigniter FrameWork Im interested in your script Best Regards

$65 USD in 3 days
(9 Reviews)
3.3
Andy74

Hi, check PM!

$250 USD in 3 days
(1 Review)
3.0
prashantrawal

can i work on this task? if yes please add me in skype add this rawalprashant26

$200 USD in 2 days
(0 Reviews)
0.0
luk4u

jquery expert here , and good at high level technologyy exploring

$100 USD in 1 day
(0 Reviews)
0.0
piyushgururani

We are professional website makers with an expertise in the field of over 5 years . We have the code ready with us . Kindly contact if you need demo .

$50 USD in 0 days
(0 Reviews)
0.0