Gossamer Forum
Home : Products : Gossamer Links : Development, Plugins and Globals :

Re: [gotze] Suggest query (as in Google Suggest)

Quote Reply
Re: [gotze] Suggest query (as in Google Suggest) In reply to
I decided not to write a plugin, but simply post all the relevant files here. It works, but the CSS is not perfect yet. If there are any CSS gurus out there, how can make it more Google like, I'd be happy to know!

The LiveSearch feature makes use of the SearchLogger plugin to generate the list, so you need to have this plugin installed, and it should contain a reasonable number of entries for the LiveSearch feature to make sense.

xhtml code
http://www.iyengar-yoga.com/livesearch.html

JavaScript code
http://www.iyengar-yoga.com/inc/livesearch.js

CSS stylesheet
http://www.iyengar-yoga.com/inc/livesearch.css

Perl Code
Code:
#!/usr/bin/perl

# +----------------------------------------------------------------------+
# | Copyright (c) 2004 Iyengar Yoga Resources |
# +----------------------------------------------------------------------+
# | Licensed under the Apache License, Version 2.0 (the "License"); |
# | you may not use this file except in compliance with the License. |
# | You may obtain a copy of the License at |
# | http://www.apache.org/licenses/LICENSE-2.0 |
# | Unless required by applicable law or agreed to in writing, software |
# | distributed under the License is distributed on an "AS IS" BASIS, |
# | WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or |
# | implied. See the License for the specific language governing |
# | permissions and limitations under the License. |
# +----------------------------------------------------------------------+
# | Author: yogi <info@iyengar-yoga.com> |
# +----------------------------------------------------------------------+

use strict;
use lib '/path/to/links/admin';
use Links qw/$CFG $DB $IN/;

local $SIG{__DIE__} = \&Links::fatal;

Links::init('/path/to/links/admin');

main();

sub main {
my $t = $DB->table('SearchLog');
$t->select_options('ORDER by HitCount DESC', 'LIMIT 10');
my $q = $IN->param('query');
my $cond = GT::SQL::Condition->new( 'Term', 'LIKE', "$q%");
my $sth = $t->select($cond);
my $base = 'http://www.iyengar-yoga.com/perl/directory/search.cgi?query';
print "Content-Type: text/xml\n\n";
if ($t->hits) {
print qq|<ul class="LSRes">|;
while (my $result = $sth->fetchrow_hashref) {
print qq|<li class="LSRow" onmouseover="liveSearchHover(this)" onclick="liveSearchClicked(this)"><a href="$base=$result->{Term}" name="$result->{Term}">$result->{Term}</a> <span style="color:green;overflow:hidden;">$result->{Results} results</span></li>\n|;
}
print qq|</ul>|;
}
}

Background infos on the method used, plus maybe some tips for installation:
http://blog4.bitflux.ch/wiki/LiveSearch

Enjoy!

Ivan
-----
Iyengar Yoga Resources / GT Plugins

Last edited by:

yogi: Mar 9, 2005, 3:45 AM
Subject Author Views Date
Thread Suggest query (as in Google Suggest) yogi 24043 Dec 10, 2004, 2:50 PM
Post Re: [yogi] Suggest query (as in Google Suggest)
mgeyman 22491 Dec 10, 2004, 7:16 PM
Thread Re: [yogi] Suggest query (as in Google Suggest)
gotze 22618 Dec 11, 2004, 1:49 PM
Post Re: [gotze] Suggest query (as in Google Suggest)
Dorette 22480 Dec 12, 2004, 10:53 AM
Thread Re: [gotze] Suggest query (as in Google Suggest)
yogi 22578 Dec 13, 2004, 1:27 AM
Thread Re: [yogi] Suggest query (as in Google Suggest)
mgeyman 22513 Dec 13, 2004, 6:38 AM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
yogi 22548 Dec 13, 2004, 7:09 AM
Thread Re: [yogi] Suggest query (as in Google Suggest)
mgeyman 22562 Dec 13, 2004, 8:44 AM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
yogi 22577 Dec 13, 2004, 10:00 AM
Thread Re: [yogi] Suggest query (as in Google Suggest)
mgeyman 22528 Dec 13, 2004, 10:35 AM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
Jag 22744 Dec 13, 2004, 12:43 PM
Thread Re: [Jag] Suggest query (as in Google Suggest)
mgeyman 22494 Dec 13, 2004, 2:07 PM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
Jag 22517 Dec 13, 2004, 2:36 PM
Thread Re: [Jag] Suggest query (as in Google Suggest)
mgeyman 22321 Dec 19, 2004, 10:00 AM
Post Re: Suggest query (as in Google Suggest)
KevM 22173 Feb 19, 2005, 8:06 AM
Thread Re: [yogi] Suggest query (as in Google Suggest)
long327 22421 Dec 14, 2004, 12:43 AM
Post Re: [long327] Suggest query (as in Google Suggest)
yogi 22425 Dec 14, 2004, 1:29 AM
Thread Re: [yogi] Suggest query (as in Google Suggest)
gotze 22529 Dec 15, 2004, 1:13 PM
Thread Re: [gotze] Suggest query (as in Google Suggest)
Dinky 22421 Dec 15, 2004, 3:15 PM
Post Re: [Dinky] Suggest query (as in Google Suggest)
nir 22404 Dec 16, 2004, 8:26 AM
Thread Re: [yogi] Suggest query (as in Google Suggest)
katabd 22055 Apr 21, 2005, 11:32 PM
Thread Re: [katabd] Suggest query (as in Google Suggest)
mgeyman 21999 Apr 22, 2005, 9:29 AM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
gotze 21971 Apr 22, 2005, 12:38 PM
Post Re: [gotze] Suggest query (as in Google Suggest)
mgeyman 21905 Apr 22, 2005, 6:27 PM
Thread Re: [gotze] Suggest query (as in Google Suggest)
katabd 21995 Apr 22, 2005, 7:33 PM
Thread Re: [katabd] Suggest query (as in Google Suggest)
katabd 14304 Apr 23, 2005, 6:34 PM
Thread Re: [katabd] Suggest query (as in Google Suggest)
katabd 14240 Apr 23, 2005, 6:39 PM
Thread Re: [katabd] Suggest query (as in Google Suggest)
katabd 14213 Apr 23, 2005, 6:42 PM
Post Re: [katabd] Suggest query (as in Google Suggest)
katabd 14153 Apr 23, 2005, 10:02 PM
Thread Re: [katabd] Suggest query (as in Google Suggest)
ccunet 14215 Apr 24, 2005, 1:15 PM
Thread Re: [ccunet] Suggest query (as in Google Suggest)
katabd 14188 Apr 24, 2005, 6:51 PM
Thread Re: [katabd] Suggest query (as in Google Suggest)
mgeyman 14181 Apr 24, 2005, 7:21 PM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
katabd 14160 Apr 25, 2005, 4:28 AM
Thread Re: [katabd] Suggest query (as in Google Suggest)
mgeyman 14124 Apr 25, 2005, 5:37 AM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
pugdog 14132 Apr 26, 2005, 2:43 PM
Thread Re: [pugdog] Suggest query (as in Google Suggest)
mgeyman 14172 Apr 27, 2005, 1:39 PM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
pugdog 14070 Apr 27, 2005, 2:31 PM
Thread Re: [pugdog] Suggest query (as in Google Suggest)
mgeyman 14107 Apr 27, 2005, 6:51 PM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
mgeyman 14122 Apr 27, 2005, 8:29 PM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
pugdog 14109 Apr 27, 2005, 8:37 PM
Thread Re: [pugdog] Suggest query (as in Google Suggest)
mgeyman 14085 Apr 27, 2005, 8:44 PM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
pugdog 14099 Apr 27, 2005, 8:50 PM
Thread Re: [pugdog] Suggest query (as in Google Suggest)
mgeyman 14150 Apr 27, 2005, 9:01 PM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
fantasyman 14055 Apr 28, 2005, 12:19 PM
Thread Re: [fantasyman] Suggest query (as in Google Suggest)
gotze 14117 Apr 28, 2005, 1:51 PM
Thread Re: [gotze] Suggest query (as in Google Suggest)
fantasyman 14082 Apr 28, 2005, 3:07 PM
Thread Re: [fantasyman] Suggest query (as in Google Suggest)
mgeyman 13949 Apr 28, 2005, 7:30 PM
Thread Re: [mgeyman] Suggest query (as in Google Suggest)
pugdog 14089 Apr 29, 2005, 8:26 AM
Thread Re: [pugdog] Suggest query (as in Google Suggest)
gotze 14242 Apr 29, 2005, 1:50 PM
Thread Re: [gotze] Suggest query (as in Google Suggest)
fantasyman 14159 May 1, 2005, 12:00 AM
Post Re: [fantasyman] Suggest query (as in Google Suggest)
mgeyman 14062 May 1, 2005, 5:30 AM
Thread Re: [gotze] Suggest query (as in Google Suggest)
katabd 13997 Mar 21, 2006, 4:03 AM
Thread Re: [katabd] Suggest query (as in Google Suggest)
gotze 14044 Mar 21, 2006, 7:28 AM
Post Re: [gotze] Suggest query (as in Google Suggest)
katabd 13958 Mar 23, 2006, 9:01 PM
Thread Re: [gotze] Suggest query (as in Google Suggest)
sangiro 13986 Apr 7, 2006, 10:04 AM
Post Re: [sangiro] Suggest query (as in Google Suggest)
gotze 13980 Apr 7, 2006, 2:42 PM
Thread Re: [sangiro] Suggest query (as in Google Suggest)
eljot 13962 Apr 8, 2006, 12:41 AM
Thread Re: [eljot] Suggest query (as in Google Suggest)
sangiro 14034 Apr 8, 2006, 2:07 AM
Post Re: [sangiro] Suggest query (as in Google Suggest)
Matthias70 13666 Dec 21, 2007, 1:47 PM
Thread Re: [gotze] Suggest query (as in Google Suggest)
DeadMan 13781 Jan 3, 2009, 9:41 AM
Thread Re: [DeadMan] Suggest query (as in Google Suggest)
VishalT 13729 May 30, 2009, 7:57 AM
Thread Re: [SWDevil.Com] Suggest query (as in Google Suggest)
jdgamble 13635 Jun 6, 2009, 2:44 PM
Thread Suggest query (as in Google Suggest)
VishalT 13546 Jun 7, 2009, 10:50 AM
Post Re: [SWDevil.Com] Suggest query (as in Google Suggest)
nir 13313 Oct 13, 2009, 3:57 AM
Thread Re: [DeadMan] Suggest query (as in Google Suggest)
Matthias70 13544 Jun 7, 2009, 12:36 AM
Thread Re: [Matthias70] Suggest query (as in Google Suggest)
MJ_ 12873 Nov 16, 2011, 12:16 AM
Post Re: [MJ_] Suggest query (as in Google Suggest)
Matthias70 12771 Nov 16, 2011, 12:22 AM
Post Re: [fantasyman] Suggest query (as in Google Suggest)
pugdog 14017 Apr 28, 2005, 3:04 PM
Post Re: [mgeyman] Suggest query (as in Google Suggest)
pugdog 14026 Apr 27, 2005, 8:41 PM