maxhugen
Posts: 272
|
| Posted: 08/22/2008, 3:16 AM |
|
I'm wondering if anyone has used/seen a site-wide search engine for content in a database?
For example, something where you'd specify the tables (and the specific fields therein) which some sort of 'indexing mechanism' would scan, then update some 'index tables', and then the 'search engine' would use the index tables to bring back records (links to?) from a variety of tables as 'search results'.
Tall order???
_________________
Max
www.gardenloco.com | www.eipdna.com | www.chrisarminson.com |
 |
 |
wkempees
Posts: 1679
|
| Posted: 08/22/2008, 3:48 AM |
|
Tall order, No just a tall question, I think.
Actually I think some fellow members and I explored that path way back when.
And I did a special on behalf of one of our members here, off-forum.
If you are using MySQL read up on full text search (ISAM), in compliance with the DB version you use.
Some posts:
http://forums.codecharge.com/posts.php?post_id=63800&s_...full+textsearch
http://forums.codecharge.com/posts.php?post_id=76065&s_...ull+text+search
There is another way I am thinking about, involving wget
But let's see what you think of this reply.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
DonP
|
| Posted: 08/22/2008, 11:22 AM |
|
Searching from within your site should be relatively easy if only a few
tables are involved but gets very difficult if you want to search
everything. Since my data was primarily in only a few tables (the rest
were lookup tables), what I did was to make a keyword search results
page with separate grids for each table's results. It's not elegant but
it works when there are only a few tables involved. Of course, if your
grid has joined tables, you can search any of them at once in a single grid.
Don (DonP)
maxhugen wrote:
> I'm wondering if anyone has used/seen a site-wide search engine for content in a
> database?
>
> For example, something where you'd specify the tables (and the specific fields
> therein) which some sort of 'indexing mechanism' would scan, then update some
> 'index tables', and then the 'search engine' would use the index tables to
> bring back records (links to?) from a variety of tables as 'search results'.
>
> Tall order???
> _________________
> Max (95% CCS Newbie)
> "I have a dream..." that CCS provided a php debugger.
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.yessoftware.com/
>
|
|
|
|
maxhugen
Posts: 272
|
| Posted: 08/22/2008, 8:33 PM |
|
Yes, I'm starting to think a 'site-wide' search is overly ambitious. I'll look into concatenated 'searchtext' fields as Walter suggested as I've used these in MS Access projects before, and maybe combine this with Don's separate result grids.
Although I did have a thought... if 'some engine' could be directed to follow every link in my (specified) "List" pages (or whatever), and then have a fulltext engine catalogue each page...
Curious as to what your ideas on wget were, Walter?
Thanks!
_________________
Max
www.gardenloco.com | www.eipdna.com | www.chrisarminson.com |
|
|
|
wkempees
Posts: 1679
|
| Posted: 08/23/2008, 9:00 AM |
|
Max,
The wget approach (Wget is the Lx derrivated, website grabber) would have been
an option to slurch in a website and do something with the resulting data.
However at time of writing I thought you wanted someone elses website data and to integrate that in link form into your own.
Walter
_________________
Origin: NL, T:GMT+1 (Forumtime +9)
CCS3/4.01.006 PhP, MySQL .Net/InMotion(Vista/XP, XAMPP)
if you liked this info PAYPAL me: http://donate.consultair.eu
|
|
|
|
|
