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.
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.04 Votes: 48
|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!|