Click here to Skip to main content
15,882,388 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hi there,

I am creating an application in I have a database connected to it. The database contains a lot of information for example users, vendors etc. Currently I have a dropdown menu which is just too long to be doing through it just to find the vendor you want. Now I want to create a search box so that when I want to get a specific vendor (I already have all the vendors details on the database such as address and contacts) I want to start typing the vendors name and I want it to look in the database then start giving me matching data to what I m typing to what already exists.

For example, when you do a search on google, normally it will start giving you matches to what you typing in or something similar to what you have already searched for. I wonder if anyone knows how to do it in and MySQL that would be helpful.

Thanks in advance!

jQuery has a lot of plug-ins available for doing autocomplete searches. Just search google for jQuery autocomplete or you can use the jQuery autocomplete at[^]
Share this answer
Jquery plugins available for this.

you can use $.autocomplete() to searching records.
link :

AJAX autocomplete for JQUERY
link :

another way is Autocomplete Extender of AJAX.

link :
Share this answer
try following this link...

make a web service for this..if you cant then contact me..I will send you the sample code[^]
Share this answer
Geofferz 16-Apr-12 6:01am    
Hey, thanks for your help. I would really appreciate a sample code if you can please! At the moment I just have a text box and I want that to be linked to my database so when user starts typing name of a customer it searches what already exists in the database and provide what matches to what they typing. Thanks again!
AshishChaudha 16-Apr-12 6:13am    
please provide me your email id
Geofferz 17-Apr-12 5:00am    
my email id is thanks

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900