分词搜索 sphinx3.1.1+php7+mysql

1. 下载sphinx3.1.1
   • wget http://sphinxsearch.com/files/sphinx-3.1.1-612d99f-linux-amd64.tar.gz
2. 解压 
   • tar zxf sphinx-3.1.1-612d99f-linux-amd64.tar.gz
3. 改名 sphinx 并移动到 /usr/local/
   • mv sphinx-3.1.1 sphinx
   • mv sphinx /usr/local/
4. 到sphinx目录下创建 data,log文件夹,并赋777权限
   • cd /usr/local/sphinx
   • mkdir data
   • chmod -r 777 data
   • mkdir log
   • chmod -r 777 log
5. 在/usr/local/sphinx/etc 编写 sphinx.conf 配置文件

• cd /usr/local/sphinx/etc
• vim sphinx.conf

• #
  # minimal sphinx configuration sample (clean, simple, functional)
  #
  
  source src1
  {
      type                = mysql
      sql_host            = localhost
      sql_user            = root
      sql_pass            = root
      sql_db              = test
      sql_port            = 3306    # optional, default is 3306
      sql_query_pre       = set names utf8
      sql_query            = \
          select id, group_id, unix_timestamp(date_added) as date_added, title, content \
          from documents
  
      sql_attr_uint        = group_id
      sql_attr_timestamp    = date_added
  }
  
  
  index test1
  {
      source                    = src1
      path                    = /usr/local/sphinx/data
      min_word_len            = 1
      ngram_len               = 1
      ngram_chars             = u+3000..u+2fa1f
  }
  
  indexer
  {
      mem_limit        = 128m
  }
  
  searchd
  {
          listen                  = 9312
          listen                  = 9306:mysql41
          log                     = /usr/local/sphinx/log/searchd.log
          query_log               = /usr/local/sphinx/log/query.log
          read_timeout            = 5
          max_children            = 30
          pid_file                = /usr/local/sphinx/log/searchd.pid
          seamless_rotate         = 1
          preopen_indexes         = 1
          unlink_old              = 1
          binlog_path             = /usr/local/sphinx/data
  }

在test数据库中 运行/usr/local/sphinx/etc目录下的example.sql文件

• 进入mysql
• use test;
• source /usr/local/sphinx/etc/example.sql

添加索引

• /usr/local/sphinx/bin/indexer -c  /usr/local/sphinx/etc/sphinx.conf test1
• 

运行sphinx

• /usr/local/sphinx/bin/searchd -c  /usr/local/sphinx/etc/sphinx.conf
• 

php操作sphinx

• 下载sphinxapi.php 自带的类文件缺少function

https://files.cnblogs.com/files/wxzxc/sphinxclient.zip

1. • $sphinx = new sphinxclient();
     $q      = $_get['key'] ?? 'test'; //搜索关键字
     $sql    = "";
     $host   = "127.0.0.1";
     $port   = 9312;
     $index  = "*";
     $sphinx->setserver($host, $port);
     $sphinx->setconnecttimeout(10);
     $sphinx->setarrayresult(true);
     $sphinx->setmatchmode(sph_match_all);
     $res = $sphinx->query($q, $index);
     print_r($res);

      运行结果如下:

2. • 

结束,记得数据库数据改变后需重新生成索引