Member Avatar for ankit1122

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?

  • 3 Contributors
  • 2 Replies
  • 130 Views
  • 2 Hours Discussion Span
  • Latest Post Latest Post by Borzoi
Member Avatar for Jeff_8

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.

Member Avatar for Borzoi

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.