aldrin151 Posted October 12, 2008 Share Posted October 12, 2008 Hello, does anyone know what I would search for or know how to create a textbox to retrieve data from a mysql table? For example a user has the option to either enter their own writing in the text box or the textbox drop downs a list of values pulled from the table. Another example would be if you're on yahoo or google search box and a suggestion of what people have searched for displays. Thanks. Quote Link to comment https://forums.phpfreaks.com/topic/128126-prepopulate-a-textbox-from-mysql-table/ Share on other sites More sharing options...
R0bb0b Posted October 12, 2008 Share Posted October 12, 2008 Best way to do this active search(many examples on google) would be a combination of ajax and javascript. If you've never done ajax before I strongly recommend doing this project from scratch as you will be very satisfied when you are finished. Quote Link to comment https://forums.phpfreaks.com/topic/128126-prepopulate-a-textbox-from-mysql-table/#findComment-663548 Share on other sites More sharing options...
aldrin151 Posted October 12, 2008 Author Share Posted October 12, 2008 Thanks...so the correct term for this function if I were to search for it would be "active search" ? Quote Link to comment https://forums.phpfreaks.com/topic/128126-prepopulate-a-textbox-from-mysql-table/#findComment-663550 Share on other sites More sharing options...
DarkWater Posted October 12, 2008 Share Posted October 12, 2008 Thanks...so the correct term for this function if I were to search for it would be "active search" ? Either that, or 'autosuggest'. Quote Link to comment https://forums.phpfreaks.com/topic/128126-prepopulate-a-textbox-from-mysql-table/#findComment-663552 Share on other sites More sharing options...
.josh Posted October 12, 2008 Share Posted October 12, 2008 Actually a better search term would be "ajax form validation" those tutorials will show you the principle of "live" db checking you can take that and apply it to what you want to do: making a real-time dropdown suggestion like google. Quote Link to comment https://forums.phpfreaks.com/topic/128126-prepopulate-a-textbox-from-mysql-table/#findComment-663553 Share on other sites More sharing options...
aldrin151 Posted October 12, 2008 Author Share Posted October 12, 2008 Hey guys, I really appreciate your help...good to know we got a lot of members on this site willing to help...thanks again Quote Link to comment https://forums.phpfreaks.com/topic/128126-prepopulate-a-textbox-from-mysql-table/#findComment-663560 Share on other sites More sharing options...
R0bb0b Posted October 12, 2008 Share Posted October 12, 2008 I would start here: http://www.w3schools.com/Ajax/default.asp to get the basics Quote Link to comment https://forums.phpfreaks.com/topic/128126-prepopulate-a-textbox-from-mysql-table/#findComment-663562 Share on other sites More sharing options...
aldrin151 Posted October 12, 2008 Author Share Posted October 12, 2008 Thanks R0bb0b, I always refer to that site...I'm checking it out... Quote Link to comment https://forums.phpfreaks.com/topic/128126-prepopulate-a-textbox-from-mysql-table/#findComment-663567 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.