PHP Combo Box (like in MS Access)
I have a table that is going to grow considerably as the site grows with names of businesses. I don't think I can realistically put this list of businesses in a <select></select> tag using PHP to grab the names from the database due to the size and potential number of records. Is there such a thing as a "combo box" in PHP, which will recognize an entry once the user starts typing, without loading the entire database table into the list box first? I'm just thinking that this could be too taxing on a shared server. I hope I'm making sense!
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This line in autosuggest.js myAjax.makeRequest( url, meth, onSuccessFunc, onErrorFunc ); call 'test.php'. 'test.php' in the demo has a static array to get the info. You could convert that into a database access.
There are many other demos available with PHP/MySQL code. https://www.google.com/search?q=ajax+autosuggest+php+mysql
There are many other demos available with PHP/MySQL code. https://www.google.com/search?q=ajax+autosuggest+php+mysql
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Actually, I found an extension at DMX Zone that does exactly what I'm looking for. It's called the Ajax AutoComplete.
ASKER