homepage Welcome to WebmasterWorld Guest from
register, free tools, login, search, pro membership, help, library, announcements, recent posts, open posts,
Become a Pro Member

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
Forum Library, Charter, Moderators: coopster & jatar k

PHP Server Side Scripting Forum

Directory Search Script

10+ Year Member

Msg#: 11020 posted 12:24 pm on Dec 6, 2005 (gmt 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.





10+ Year Member

Msg#: 11020 posted 11:48 am on Dec 8, 2005 (gmt 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.

Global Options:
 top home search open messages active posts  

Home / Forums Index / Code, Content, and Presentation / PHP Server Side Scripting
rss feed

All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Home ¦ Free Tools ¦ Terms of Service ¦ Privacy Policy ¦ Report Problem ¦ About ¦ Library ¦ Newsletter
WebmasterWorld is a Developer Shed Community owned by Jim Boykin.
© Webmaster World 1996-2014 all rights reserved