A Flash Developer Resource Site














Internet Commerce

Partners & Affiliates














Developer Channel

internet.com


Featured Flash FLA
Gallery Downloads 11336 Flash Movies | 2 New Flash Movies Added
What's New | Top 100

Featured FLA

» Author: Surjit Dhami
» Title: Book
» Description: Book
» More by Surjit Dhami


Random FLAs | Add Flash Movie
Featured Flash Site
Gallery Downloads 5848 Flash Sites | 0 New Flash Links
What's New | Top 100 Flash Site

Featured Site

» Posted in the Flash Kit Links section
» Title: All-American Rejects
» Description: Get to know this great band by exploring their "practice room".


Random Links | Add your own Flash Related Links
Flash Tutorials 1277 Tutorials 7 New Tutorials Added!
What's New | Top100

» Create xml slideshow with free template
» How to Insert a Multilingual Subtitle Into Your Flash Video Studio
» How to Create Cool Halloween Slideshow
» Debugging flash using the Firebug console
» Create Flash Slideshow on Blogger
» FLASH TRICKS IN WEB ADVERTISING: FLASH BANNERS
» HTML Photo Gallery Tutorial
» Create your first flash site – PART 1
» How to Make a Flash Photo Gallery
» Unknown Tag: Title10
Random Tutorial | Add Site

Sr Instructional Designer D2L-Moodle,Clearance
WSI Nationwide, Inc.
US-NJ-Fort Monmouth

Justtechjobs.com Post A Job | Post A Resume


Tutorials Home What's New Top Rated Submit myTutes Random!

Search Tutorials


Tutorials Tutorials » Backend

Categories Keyword search using MySQL / PostgreSQL / MSSQL / InterBase / ODBC, PHP and Flash 4
Author: James Greenhalgh | Website: http://www.odslinux.com |

 
Page 5
«prev 1 2 3 4 5 6 7 8 9 next»

Flash Keyword Search Module for DGS Search

As I stated before, the reason I liked DGS Search was its modular capabilities. I've included with the attached zip a flash.php This file is to be placed in your ../dgssearch/lib/display/ directory. It is used to send the variables back to Flash.
<?
/*
** flash.php written by James Greenhalgh
** used for keyword search in flash
*/
function flash($retVal, $q, $r, $o, $s, $timer) {
   global $config;
   $size = ($s <1) ? count($retVal) : $s;
   $dispR = ($r == $config["maxResults"]) ? 0 : $r;
   if ($size> 0) {
      $i = 0;
      reset($retVal);
      while (list(, $match) = each($retVal)) {
         $i++;
         if ($i <= $o)
            continue;
         if ($i> $o + $r)
            break;
         $question = $match["link"];
         $id = $match["url"];
         printf("&link$i=$id&word$i=$question");
      }
   }
   printf("&linksLoaded=yes");
   return true;
}
?>

This PHP script gets executed when you click on the Ask Button, it is loaded in the ActionScripting of the Ask Button.
I'm not going to get into explaining every line step by step, but the most important one is this line:
         printf("&link$i=$id&word$i=$question");


This is the line that gets output during each successful query match. So if the keyword the user entered matches the keyword on your db, it sends something along the lines of:

&link1=16&word1=What is your favourite colour?

The "16" in this example is very important. This is the keywords record id, this allows for faster returns of the answer.
In the case where more than one record exists for that keyword (take for example someone types 'service' it may return a listing for every service you provide) this is what the output would be like:

&link1=16&word1=Tell me more about your web design
&link2=57&word2=Where can I find your portfolio?
&link3=84&word3=What are the prices for your services


Note: If you are going to be using PostgreSQL, then you must copy the attached "db.php" file into the lib/search/ directory. (make sure to rename the old one) PostgreSQL support is not part of the DGS Search package yet, it's my own personal hack which should work.

«prev 1 2 3 4 5 6 7 8 9 next»

» Level Advanced

Added: : 2001-02-19
Rating: 8.07 Votes: 47
Hits: 3975
» Author
I work for a Canadian software company as a logisitics director. We provide custom configured Linux distributions. In my spare time I sleep.
» Download
Download the files used in this tutorial.
Download (103 kb)
Get conversion and unzipping tools for PC and Mac here!

» Forums
More help? Search our boards for quick answers!

Please rate this tutorial, 10 is the top rating, you can also click the comments link to read/write a review.
10 9 8 7 6 5 4 3 2 1
Read or Post Comments
 
   
 

internet.commediabistro.comJusttechjobs.comGraphics.com

Search:

WebMediaBrands Corporate Info

Legal Notices, Licensing, Reprints, Permissions, Privacy Policy.
Advertise | Newsletters | Shopping | E-mail Offers | Freelance Jobs