Internet Commerce

Partners & Affiliates

Developer Channel


Featured Flash FLA
Gallery Downloads 11401 Flash Movies | 5 New Flash Movies Added
What's New | Top 100

Featured FLA

»  Author: Nick Kouvaris
»  Title: Znax
»  Description: Znax is a board game. Click 4 tiles of the same color and form squares as big as you can. You will erase all the tiles inside the square and collect points. Get maximum score if you make a square with game edges.
»  More by: Nick Kouvaris


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

Featured Site

»  Author Agence WOP Digital Agency
»  Title: Electricdrum
»  Description: French WOP Agency, 3D websites, Flash (Papervision, Away 3D), event or institutional projects. The agency operates on all digital projects: consulting, design, graphic design, development, online communication. The WOP agency follows you on the implementation of original, creative and optimized digital projects.


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

» How To Make A Simple Animation Using Christmas Clips
» Simple Step by step flash game tutorial Spot the diffrence
» How To Make A Moving Text Slide
» Create Flash Banner With Text Float Effect
» How To Make Zoo Photos Slideshow
» How To Make A Dolphin Photos Slideshow
» How To Make A Fathers Day Slideshow
» How To Make A Transparent Background of Your Flash File
» Create Flash Banner With Text Disco Light Effect Today we will introduce you a Text Disco Light eff
» Unknown Tag: Title10
Random Tutorial | Add Site


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: 3984
» 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