Home arrow MySQL arrow Page 2 - Developing A Site Search Engine With PHP And MySQL

Developing A Site Search Engine With PHP And MySQL

The key to developing a successful web site is content. Sure, your site can be packed with 10,000 50-page articles, but what good are these articles if your visitors can't find what they're after? In this article Mitchell shows us how to create a site search engine with PHP and MySQL. He develops the MySQL database and PHP script that will allow us to enter several keywords to search dynamic content.

Author Info:
By: Mitchell Harper
Rating: 4 stars4 stars4 stars4 stars4 stars / 145
February 16, 2002
  1. · Developing A Site Search Engine With PHP And MySQL
  2. · Search Engine Theory
  3. · Creating the database
  4. · The searchdocs.php script
  5. · The doSearch function
  6. · Testing our search script
  7. · Conclusion

print this article

Developing A Site Search Engine With PHP And MySQL - Search Engine Theory
(Page 2 of 7 )

The search engine that we're going to create in this article is extremely basic, but still adheres to the theories of any other search engine: a user enters one or more keywords and a set of results are returned based on these keywords.

Search engines have been one of the reasons why the Internet has become such a popular medium for information storage and retrieval. For many of the modern search engines (such as Google and Yahoo), you can think of the way they work as giant yellow pages. All of their data is indexed in a way that a set of algorithms can easily be applied to it to return matching records. These records contain the title of the matching web site, as well as its ranking, short description, and URL.

Because these sites have millions (if not billions) of records indexed, the results normally span several pages, with the most relevant results being displayed first. A typical web user will not view past the third page of search results, so it is imperative that the first three pages contains links matching the users keywords as closely and as accurately as possible.

One of the other design requirements of any search engine is speed. Google has shown that a search engine doesn't have to include fancy listings or advanced options to become popular. In just a couple of years, Google has become one of the most popular (if not the most) search engines on the Internet. If you're after a good read, then checkout the history of google. It's quite interesting.

We're going to try and make our search engine as fast as possible, limiting its functionality to non-duplicated, basic keyword recognition.
blog comments powered by Disqus

- MySQL and BLOBs
- Two Lessons in ASP and MySQL
- Lord Of The Strings Part 2
- Lord Of The Strings Part 1
- Importing Data into MySQL with Navicat
- Building a Sustainable Web Site
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- PhpED 3.2 More Features Than You Can Poke ...
- Creating An Online Photo Album with PHP and ...
- Creating An Online Photo Album with PHP and ...
- Security and Sessions in PHP
- Setup Your Personal Reminder System Using PHP
- Create a IP-Country Database Using PERL and ...
- Developing a Dynamic Document Search in PHP ...

Watch our Tech Videos 
Dev Articles Forums 
 RSS  Articles
 RSS  Forums
 RSS  All Feeds
Write For Us 
Weekly Newsletter
Developer Updates  
Free Website Content 
Contact Us 
Site Map 
Privacy Policy 

Developer Shed Affiliates


© 2003-2018 by Developer Shed. All rights reserved. DS Cluster - Follow our Sitemap
Popular Web Development Topics
All Web Development Tutorials