Searching Internal Website

[MrPantsTm]

the company I work for wants to add a search engine to the page(s) I've created for them. I was hoping to just use Google but since it is an internal site with no dns I can't redirect Google to just search the site (which would be nice but I have a feeling my employer would not find safe).

The majority of the pages are written in PHP with a MySQL database. It's running on a RedHat Linux box. Any suggestions would be appreciated besides using grep

 

[TruthInSatire]

Check out

http://hotscripts.com

i'm sure they'll have something. They did in asp anyway.

http://thereptilian.com/

 

[BabyJeffy]

MrPantsTm,

I run a very similar setup here (but using Apache/Tomcat instead of PHP). The key is that you are running mySQL. You can search mySQL tables (of course) - I recently created a search solution using the following URLs for backup:

http://www.databasejournal.com/features/mysql/article.php/10897_1587371_1

http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html

The following gave a good crash course on using weighed queries as well:

http://forums.devshed.com/showthread.php?threadid=15428&forumid=4&highlight=strcmp

Hope this is enough to get you going. Remember that you can alter existing tables to add in the MyISAM table definition using the following:

> ALTER TABLE table_name TYPE=mySAM;
> REPAIR TABLE table_name QUICK;

It certainly did the trick for me (but please back up just in case -- I'd hate to break your intranet... I have enough worry with my won *grin*)!

All the best,
Jeff

 

[MrPantsTm]

Thank you bombboy and BabyJeffy.

BabyJeffy - I'm thought of using the mysql database to do searchs since it has inherent search queries. My problem, is that a lot of documents are going to uploaded to the a document repository of sorts. The way I have it set up, the database only takes the filename and location (and some other trivial bits of info such as size, file ext etc) and puts that in the database. The actual text of the document is left alone. It would be nice to be able to search those files (docs, xls, txt et al). I don't believe loading the files into the database would be wise or practical although correct me if I'm wrong.

Again thanks for the links, that'll definitly get me started.

 

[BabyJeffy]

Agreed that putting the docs into mySQL is probably not the solution... I wasn't aware you wanted to ofer searching across documents as well *grin*

We're probably going to have to do something ourselves on this front... and I think that means getting a commercial solution in -- no point re-engineering a tried solution of that size.

Would be keen to see how you get on.

Jeff

 

[ChrisHirst]

You might want to take a look at phpdig.

http://phpdig.net/

It's actually designed as a search engine and spider so can do full text indexing of documents.

it's free so may be worth a try.




Chris.

Indifference will be the downfall of mankind, but who cares?

 

[GPOTony]

>I can't redirect Google to just search the site
You can Google a specific site as follows:

[search strings][space]site:[the site name]

This restricts the search to the specified site only.

 

[Wullie]

You can Google a specific site as follows:
[search strings][space]site:[the site name]
This restricts the search to the specified site only.

You took a tiny part of the comment without reading it. The full comment was:

but since it is an internal site with no dns I can't redirect Google to just search the site (which would be nice but I have a feeling my employer would not find safe).

Hope this helps


Wullie

http://www.freshlookhosting.com

http://www.tutorial-world.com

http://www.freshlookdesign.co.uk

The pessimist complains about the wind. The optimist expects it to change. The leader adjusts the sails. - John Maxwell