使用php和mysql在网站上进行全局搜索[关闭]

Question

I want to implement search option in page header. Results will contain all records those contain filter text.e.g. products. What is the best way to implement global search in website.

Answer 1

There are different approaches:

• Use LIKE queries in MySQL (very bad idea, no efficiency, no relevance)
• Use full-text search in MySQL (works from 3 characters, partly relevance)
• Use Sphinx Search, a full-text search with MySQL support
• Use a search engine, like Elasticsearch or Solr

I recommend you Sphinx Search. Very useful:

Sphinx is a full-text search engine, publicly distributed under GPL version 2. Commercial licensing (eg. for embedded use) is available upon request.

Technically, Sphinx is a standalone software package provides fast and relevant full-text search functionality to client applications. It was specially designed to integrate well with SQL databases storing the data, and to be easily accessed by scripting languages. However, Sphinx does not depend on nor require any specific database to function.

Applications can access Sphinx search daemon (searchd) using any of the three different access methods: a) via Sphinx own implementation of MySQL network protocol (using a small SQL subset called SphinxQL, this is recommended way), b) via native search API (SphinxAPI) or c) via MySQL server with a pluggable storage engine (SphinxSE). (http://sphinxsearch.com/docs/current.html#about)