Tutorials » Backend:
Keyword search using MySQL / PostgreSQL / MSSQL / InterBase / ODBC, PHP and Flash 4
Backend and Flash, Where are all the geeks?It's my opinion that Flash is not used enough in combination with PHP and/or Perl. I thought I'd show everyone how we created the Ask Leaphy searchable database on http://www.odslinux.com Naturally it can be adapted to any searchable database.
Note: To test out the movie, enter the keyword "chmod" (or any other shell command) or "phone" or try whatever you think of!
The way it works is quite simple. You insert keyword data into the database in the following format:
keyword question answer
age personal information How old are you? 26
zyx1001 Where can I find information on your zyx10001 product? http://www.yoursite.com/products?id=zyx1001
contact phone information How can we contact you? 555-1212
The PHP and Flash do the rest. The PHP will scan the database for any matches, then return them in a scrollable window on the Flash. Clicking on any of the returned questions will then find the answer on the db.
|» Level Advanced|
Rating: 8 Votes: 47
|I work for a Canadian software company as a logisitics director. We provide custom configured Linux distributions. In my spare time I sleep.|
|Download the files used in this tutorial.|
|Download (103 kb)|
|More help? Search our boards for quick answers!|