I have a table that has 186000 items in it and I want to be able to allow a user to type the name of the item he or she is looking for and have the textbox refine its search much like google now does as you type items in to search for with google.
First you need to create an API that is in contact with your database, this api is going to retrun json objects, then you need to create an interface (a simple html page with JQuery functionality)
JAYHAWKER
Participant
1252 Points
1896 Posts
I have a table wtih 186000 items in it and am looking for the simplest way to search items in a t...
Dec 10, 2011 08:39 PM|LINK
I have a table that has 186000 items in it and I want to be able to allow a user to type the name of the item he or she is looking for and have the textbox refine its search much like google now does as you type items in to search for with google.
What is the slickest way of doing that?
Soroush1368
Member
78 Points
28 Posts
Re: I have a table wtih 186000 items in it and am looking for the simplest way to search items in...
Dec 10, 2011 09:28 PM|LINK
First you need to create an API that is in contact with your database, this api is going to retrun json objects, then you need to create an interface (a simple html page with JQuery functionality)
start here: http://jqueryui.com/demos/autocomplete/
bruce (sqlwo...
All-Star
36894 Points
5452 Posts
Re: I have a table wtih 186000 items in it and am looking for the simplest way to search items in...
Dec 11, 2011 10:42 PM|LINK
gogole for any number of jquery autocomplete plugins
asteranup
All-Star
30184 Points
4906 Posts
Re: I have a table wtih 186000 items in it and am looking for the simplest way to search items in...
Dec 12, 2011 06:34 AM|LINK
Hi,
On keup of the textbox you can do an ajax call to get the data. You can search fo calling ajax with jquery.
Anup Das Gupta
Mark as Answer if you feel so. Visit My Blog