How to use sphinx search engine in php-PHP Tutorial-php.cn

How to use sphinx search engine in php

小云云

Release： 2023-03-21 20:56:01

Original

2538 people have browsed it

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

<br>

Copy after login

<br>

Copy after login

cd /etc/sphinxsearch/

cp sphinx.conf. sample sphinx.conf

Modify the configuration file as follows

<br>

Copy after login

<br>

Copy after login

}

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
}<br>
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

<br>

Copy after login

<br>

Copy after login

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!