Forums

Please write a review for the extension you are using on the Joomla extensions directory before posting a new question as we are being spammed by many negative reviews.

Thank you for your support!

Dynamic Search from Database

U Can Drive 18 Jun, 2016

I have a form to search a database for a specific clients details.
I enter their name and the form returns their account number.

If the entry is does not have the correct spelling obviously there will be no file found.

How can I get the form to do a partial name search or even dynamically autocomplete from a list of possible entries collated from the database itself?

Thank you and welcome back by the way, totally missed you while you were gone.

GreyHead 18 Jun, 2016

Hi U Can Drive,

You can use the AutoCompleter to do an Ajax query back to a form event on the server and add custom code in the event to use any MySQL you like to return results: e.g. LIKE '%xxx%' will pick up any entry with xxx in it.

Bob

This topic is locked and no more replies can be posted.