Home > Article > Backend Development > How to use sphinx search engine in php

How to use sphinx search engine in php

小云云Original: 2018-03-21 14:12:102399browse

Sphinx is an efficient search engine. The word segmentation search speed is relatively fast. The index is created and stored in the hard disk file. It will not interfere with the database. It has its own set of built-in databases. I hope it can help everyone.

Use sphinx search engine in php

sphinx is an efficient search engine. The word segmentation search speed is relatively fast. The index is established and stored in the hard disk file. It will not interfere with the database and has its own A set of built-in databases

1. Install sphinx on ubuntu

If aptitude is not installed, you need to install aptitude first because problems will occur when using apt get install to install the following command.
sudo apt-get install aptitude
sudo aptitude install sphinx3 sphinx3-doc sphinxsearch sphinx-common -y

2. Configuration

1 2	cd /etc/sphinxsearch/ cp sphinx.conf. sample sphinx.conf

Modify the configuration file as follows

}

source src1
{
type = mysql
sql_host = localhost
sql_user = root
sql_pass = magicmoma
sql_db = coupon_20160901 
sql_port = 3306 # optional, default is 3306
sql_query = SELECT couponid,title,description FROM app_coupon_api
# Need to include primary key, word segmentation index field
##}
index test1
{
source = src1
path = /var/lib/sphinxsearch/ data/test1 #Index storage directory
docinfo = extern
mlock = 0
morphology = none
min_word_len = 1
charset_type = utf-8
min_prefix_len = 0
min_infix_len = 0
ngram_len = 1
html_strip = 0
}
indexer
{
mem_limit = 2048M
}
searchd
{ 
listen = 9312
listen = 9306:mysql41
log = /var/log/sphinxsearch/searchd.log
query_log = /var/log /sphinxsearch/query.log
read_timeout = 5
client_timeout = 300
max_children = 30
pid_file = /var/run/sphinxsearch/searchd. pid
max_matches = 1000
seamless_rotate = 1
preopen_indexes = 1
unlink_old = 1
mva_updates_pool = 1M
max_packet_size = 8M
max_filters = 256
max_filter_values ​​= 4096
max_batch_queries = 32
workers = threads # for RT to work

######

Execute the word segmentation command and a bunch of index files will be generated in the /var/lib/sphinxsearch/data/test1 directory
sudo indexer - c /etc/sphinxsearch/sphinx.conf test1

test1 is the index name of the above configuration file

4. Command line test Search

sudo search -c /etc/sphinxsearch/sphinx.conf google

2. Use

in php 1. Install php sphinx Dependent libraries

1. Install aptitude

apt-get install aptitude
sudo aptitude install libsphinxclient-dev libsphinxclient-0.0.1 -y

2. Install php sphinx extension

Install pecl
sudo apt-get install php-pear php5-dev
Install sphinx
sudo pecl install sphinx

3. Add the sphinx extension to the configuration file php.ini,

My php.ini file is
sudo vim /etc/php5/fpm/php.ini
Get your own php.ini file location using
php5-fpm -i|grep ini

Add:
extension=sphinx.so
4. Restart php5-fpm and check whether php loads the sphinx module
sudo /etc/init.d/php5 -fpm restart
5. Run the search program in the background
sudo searchd -c /etc/sphinxsearch/sphinx.conf
Default listening port in the configuration file: 9312

6. Call search in thinkphp

public function testSphinx()
{
$s = new \SphinxClient;
$s->setServer("localhost", 9312);
$s->SetArrayResult (true );
 $s->setMatchMode(SPH_MATCH_ANY);
$s->setMaxQueryTime(3);
$result = $s->query("test"); 
$result = $result['matches'];
$result = array_column($result,'id');
$list = M('CouponApi')-> ;field('couponid,title,description')->where(array('couponid'=>array('in',$result)))->select();
dump( $list);
}

The search is completed and the results are returned (20 items are returned by default, to modify the number of items returned, add

$ s->SetLimits(0, 1000, 1000);), the search speed is quite fast, and it takes less than 10 seconds to index the title and description fields of 800,000 pieces of data. The search engine supports incremental indexing and a variety of For pattern search, there is a lot of information on the Internet

The above is the detailed content of How to use sphinx search engine in php. For more information, please follow other related articles on the PHP Chinese website!

Statement：

The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Previous article：curl in php captures web page response dataNext article：curl in php captures web page response data

See more