Welcome to WebmasterWorld Guest from

Forum Moderators: coopster & jatar k

Message Too Old, No Replies

Full text search on documents

from php and mysql point of view

9:06 am on Oct 20, 2008 (gmt 0)

Junior Member

5+ Year Member

joined:Sept 8, 2006
posts: 115
votes: 0


Suppose we need a dynamic full text search engine on a web page. The engine would search a database consisting of a large amount of short documents. The user must be able to simply search the data using one or more keywords like Google. The web page must not be fully reloaded when the user performs a search -- only the search result area must be updated.

Which web development techniques would you use to implement such a search and why? What kinds of things must be carefully considered when implementing the search and the underlying database in order to make the functionality as intuitive, easy and fast for the end user as possible?

According to my understanding the part where only search result area will be updated must be done through AJAX right!? And for full text search we can use MyISAM FULL-TEXT-SEARCH index but this will only work in the case where documents content is saved into the database. What if we are only saving document name in database and have to search content from physical file?

2:37 pm on Oct 20, 2008 (gmt 0)

New User

5+ Year Member

joined:Oct 12, 2008
votes: 0

Yes, AJAX is a good option for replacing only the search results. Depending on complexity, budget, purpose, etc, an iframe could mimic the same behavior while being facile to create.

If you're only storing the name of your documents in the database, then there is virtually no reason to run an SQL query.


Join The Conversation

Moderators and Top Contributors

Hot Threads This Week

Featured Threads

Free SEO Tools

Hire Expert Members