分词搜索 sphinx3.1.1+php7+mysql

下载sphinx3乒乓比赛.1.1wget http://sphinxarch.com/files/sphinx-3.1.1-612d99f-linux-amd64.tar.gz解压tar zxfsphinx-3.1.1-612d99f-linux-amd64.tar.gz改名 sphinx2017春晚小品 并移动到 /usr/local/mvsphinx-3.1.1 sphinxmvsphinx /usr/local/到sphinx目录下创建 data,log文件夹,并赋777权限cd /usr/local/sphinxmkdir datachmod -r 777 datamkdir logchmod -r 777 log在/usr/local/sphinx/etc 编写 sphinx.conf 配置文件cd/usr/local/sphinx/etcvimsphinx.conf

## minimal sphinx configuration sample (clean, simple, functional)#source src1{    type                = mysql    sql_host            = localhost    sql_ur            = root    sql_pass            = root    sql_db              = test    sql_port            = 3306    # optional, default is 3306    sql_query_pre       = t names utf8    sql_query            = \        lect 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}archd{        listen                  = 9312        listen                  = 9306:mysql41        log                     = /usr/local/sphinx/log/archd.log        query_log               = /usr/local/sphinx/log/query.log        read_timeout            = 5        max_children            = 30        pid_file                = /usr/local/sphinx/log/archd.pid     高贵的近义词   amless_rotate         = 1        preopen_indexes         = 1        unlink_old              = 1        binlog_path             = /usr/local/sphinx/data}

在test数据库中 运行/usr/local/sphinx/etc目录下的example.sql文件进入mysqlu 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/archd -c /usr/local/sphinx/etc/sphinx.confphp操作sphinx下载sphinxapi.php 自带的类文件缺少function

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

$sphinx = new sphinxclient();$q      = $_get['key'] ?? 'test'; //搜索关键字$sql    = "";$host   = "127.0.0.1";$port   = 9312;$index  = "*";$sphinx->trver($host, $port);$sphinx->tconnecttimeout(10);$sphinx->tarrayresult(true);$sphinx->tmatchmode(sph_match_all);$res = $sphinx->query($q, $index);print_r($res);

运行结果如下:

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