chordsoflife Posted January 21, 2009 Share Posted January 21, 2009 I'm looking for the best PHP/MySQL autoComplete script and wondering if anyone has any experience with one. I've found lots of options, but the code is more in depth than I know, so it's hard to tell if it's well coded. Thanks, guys. Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted January 22, 2009 Share Posted January 22, 2009 auto complete would most likely be JavaScript. Quote Link to comment Share on other sites More sharing options...
chordsoflife Posted January 22, 2009 Author Share Posted January 22, 2009 I need it to look through database records, so it would have to have SQL, which I think you can only use with PHP, so.. PHP/MySQL/AJAX question. I didn't know which place would be most appropriate to ask, but it has PHP in it (or so I thought) and this is the most active forum.. so here! Move it necessary, though. Thanks! Quote Link to comment Share on other sites More sharing options...
Zane Posted January 22, 2009 Share Posted January 22, 2009 here you go http://www.xtinctdesigns.com/GS_Intro.php Quote Link to comment Share on other sites More sharing options...
The Little Guy Posted January 22, 2009 Share Posted January 22, 2009 OK, what I would do is... when the user types his/her first letter search the database for everything that starts with that letter (maybe first 200) you probably would want to get the most common words first, and load it into an array... the just use JavaScript to search that array, and if you run out of words double check the database for the next 200 words or so.. then just continue this process. Quote Link to comment Share on other sites More sharing options...
Philip Posted January 22, 2009 Share Posted January 22, 2009 I've used this one, and it's not too bad IMO http://www.brandspankingnew.net/specials/ajax_autosuggest/ajax_autosuggest_autocomplete.html There are quite a few that are additions to frameworks if you're already using one (jQuery, mooTools, etc) Quote Link to comment Share on other sites More sharing options...
DimitriDV Posted January 23, 2009 Share Posted January 23, 2009 here you go http://www.xtinctdesigns.com/GS_Intro.php I get a message FATAL ERROR CA... (can't read the whole error message) anyone? ??? Quote Link to comment 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.