set source of jquery autocomplete to mysql table

Question

$( "#tags" ).autocomplete({
        source: availableTags
    });

In the above code for the jquery autocomplete, instead of availableTags, I need to set the source to all the names in a particular table, without giving the query(if possible) instead. Is there any way to do this ?

There are millions of records so putting it into an array or list is not possible. I'm thinking of caching the data from db and then reading from the cache. Can I do that, or is there any other method ?

jqueryui.com/demos/autocomplete/#remote

Rafay
– Rafay

2011-11-10 10:23:56 +00:00
Commented Nov 10, 2011 at 10:23 — Rafay
– Rafay, Commented Nov 10, 2011 at 10:23

OptimusCrime · Accepted Answer · 2011-11-10 10:25:10Z

1

The autocomplete has built in support for remote datasource, look at this: http://jqueryui.com/demos/autocomplete/#remote

You point your js to a php-script, sending the search-query in get. If you want to build a cache-system you can do this in your file. It depends on your database, if it's huge and the search takes a long time, this is necessary, if not, I would simply do a complete search every time the script runs.

answered Nov 10, 2011 at 10:25

OptimusCrime

14.9k13 gold badges63 silver badges98 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Kiran Over a year ago

What exactly do i write in the php file ? That is not mentioned on the site.

OptimusCrime Over a year ago

Well, forgetting caching, you do a query, where you match your database with FIELDNAME LIKE '%QUERYGOESHERE%'

Kiran Over a year ago

Do you have any link where they explain what to write in php file as well ?

OptimusCrime Over a year ago

Kind of depends how your database is built. This is my script, I am using a cms called modx. pastebin.com/3gsZYxXY . If you have basic knowledge in php and mysql, this should not be very difficult.

Collectives™ on Stack Overflow

set source of jquery autocomplete to mysql table

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related