Friday, June 16th, 2006
Using Ajax Agent and PHP for Auto-Complete
ScratchProjects.com has a new tutorial today from Jay demonstrating how to use the AjaxAgent software (a PHP library) to create an auto-complete text box for your site.
In this HOWTO I will explain how to use AjaxAgent and PHP to create an Ajax Auto-Complete box with a drill-down list of data. Although the state of this Ajax Framework is questionable it is so far the simplest and easiest framework I have found.
The UI is very simple. It consists of a TextBox to enter an Artists’ Name, a selectbox to display the Albums and an unordered list to display the songs on an album. This will be future extended with the ability to drill-down into an Album and get a list of songs.
He breaks it up into three sections - the auto-complete, posting back, and an “on your own” section to test you on the skills you should have learned so far. All of the code is provided for you, save for the database structure they use. It’s a pretty simple setup, though, and would take five minutes (max) for someone familiar with SQL or something like phpMyAdmin to set up.












Thanks for covering the article on your site. The database structure is in the downloadable source from the link at the top.
links for 2006-06-17
忘记水冷å§ï¼Œè¯•试喷气机引擎 (tags: hardware cooling PC) SmutVibes: æˆäººç¤¾ä¼šæ€§ç½‘络应用 (tags: sexy social community web2.0 porn sex 2.0 adult) è¿ç”¨Ajax Agentå’ŒPHP完æˆè‡ªåЍ填写 (tags: Ajax PHP ajaxian web2.0) 解读精英人…
Try CAPXOUS.AutoComplete, Cost $50
Yahoo has developed one powerful Auto-Complete UI Control as below:
//quote from Yahoo
The AutoComplete control features navigation of the suggestion container via up/down arrow keys and a rich event model that gives you scriptological access to all of the interaction’s interesting moments. Easily configurable parameters include custom formatting of AutoComplete suggestions, query delimiters (for multiple selections per input box), configurable query delay, type-ahead, animation of the suggestion container, built-in query caching, and much more.
//un-quote
For details, please refer to http://developer.yahoo.com/yui/autocomplete/.
See screencast of Yahoo here. You will know, they are not good.
Good lord, chenggn! $50 for autocomplete code?
Like how you grabbed WordPress.org’s old design and the Yahoo! code beautification script.
Can’t even press Tab to select like you can in Yahoo!’s and Script.aculo.us’s.
As for the screen cast, your script, Yahoo!’s, and Script.aculo.us’s all work equally as fast here. The scripts have little to do with how fast the autocomplete loads - the wait time is for the underlying AJAX request - which is being done by the free library Prototype.js in your system!
Scammerific.
i have used this code to display the city names the program is working with all alphabits except k,h,v and some swedish letters Ä,Ö,Å
can you please guide me