Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Directory Search Script

12:24 pm on Dec 6, 2005 (gmt 0)

Full Member

10+ Year Member

joined:Feb 13, 2003
votes: 0


I'm in the process of creating my own directory, and one of the things I would like to do is to create a search script when you type in a search term and queries the DB.

The results will show the title, description, and the category which the search term belongs to.

Now I'm not quite sure whether I need to do some alterations to the DB, so that it allows the script to search the text quickly, some indexing change etc.

Are there any tutorials or ready made scripts out there in which I can alter to my needs?

This is something I've never grasped as a developer, and really interested how this is achieved.

Any suggestions is appreciated.



11:48 am on Dec 8, 2005 (gmt 0)

Full Member

10+ Year Member

joined:July 25, 2004
votes: 0

I would suggest you carefully design your database. If I've to do that, I won't compare keywords phrases with Web pages stored text everytime.

Like for already searched results, built a keywords phrases vs URIs tables that is looked up second time, when required.

The whole databse system should be re-loaded and your Web site need be crawled, after some time (may be via a cron), say 1 week (if changes are fast), or monthly basis (if there are few changes) or almost everyday, if content is changing all the time.

Much time should be spent in database design for such a project. I suppose it, may be a dozen relational database tables. Good luck.