hello i have databses and tables in mysql db...
i want to auto suggest databases name in a input box after depending on database string i want to auto suggest the tables inside that database....how could i do this?
ankit1122
-3
Junior Poster in Training
Recommended Answers
Jump to PostYou'll need to watch the input box with javascript, and on each change (or after x number of characters), use ajax to send the search string to a php script. That php script can query the database and return results to the ajax call, which can populate a list of …
All 2 Replies
Jeff_8
0
Newbie Poster
You'll need to watch the input box with javascript, and on each change (or after x number of characters), use ajax to send the search string to a php script. That php script can query the database and return results to the ajax call, which can populate a list of possibilities.
Borzoi
24
Posting Whiz
To save on the amount of database queries being run as the end user types, you may want to pull all possible options form the database and put them in to an array and query that array instead of the database.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.