coreseek (sphinx)+ Mysql + Thinkphp搭建中文搜索引擎详解

apt-get install make gcc g++ automake libtool mysql-client libmysqlclient15-dev libxml2-dev libexpat1-dev

cd /usr/local/srctar zxvf coreseek-3.2..tar.gz #解压cd coreseek-3.2.cd mmseg-3.2../bootstrap #输出的warning信息可以忽略，如果出现error则需要解决./configure --prefix=/usr/local/mmseg3 #配置make #编译make install #安装

libtoolize --force //运行后有一个错误，不用管它。
automake --add-missing
autoconf
autoheader
make clean

cd /usr/local/srccd coreseek-3.2.cd csft-3.2.sh buildconf.sh #输出的warning信息可以忽略，如果出现error则需要解决./configure --prefix=/usr/local/coreseek --without-unixodbc --with-mmseg --with-mmseg-includes=/usr/local/mmseg3/include/mmseg/ --with-mmseg-libs=/usr/local/mmseg3/lib/ --with-mysql #配置make #编译
make install #安装

cp /usr/local/src/coreseek-3.2./testpack/etc/csft_mysql.conf /usr/local/coreseek/etc/csft_mysql.conf #拷贝MySQL数据源配置文件ln -s /usr/local/coreseek/etc/csft_mysql.conf /etc/csft_mysql.conf #添加软连接vim /etc/csft_mysql.conf #编辑，修改

#索引源定义
source mysql
{
type = mysql
sql_host = localhost
sql_user =xxxx
sql_pass =xxxx
sql_db =xxxx
sql_port =
sql_query_pre = SET NAMES utf8
sql_query = SELECT id,id,uid,title,data FROM notebook_notepad
#sql_query第一列id需为整数
#title、data作为字符串/文本字段，被全文索引
sql_attr_uint = id #从SQL读取到的值必须为整数
#sql_attr_timestamp = time #从SQL读取到的值必须为整数，作为时间属性
sql_attr_uint = uid sql_query_info_pre = SET NAMES utf8 #命令行查询时，设置正确的字符集
sql_query_info = SELECT * FROM notebook_notepad WHERE id=$id #命令行查询时，从数据库读取原始数据信息
}#index定义
index mysql
{
source = mysql #对应的source名称
path =/usr/local/coreseek/var/data/mysql #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
docinfo = extern
mlock =
morphology = none
min_word_len =
html_strip = #中文分词配置，详情请查看：http://www.coreseek.cn/products-install/coreseek_mmseg/
charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux环境下设置，/符号结尾
#charset_dictpath = etc/ #Windows环境下设置，/符号结尾，最好给出绝对路径，例如：C:/usr/local/coreseek/etc/...
charset_type = zh_cn.utf-
}#全局index定义
indexer
{
mem_limit = 128M
}#searchd服务定义
searchd
{
listen =
read_timeout =
max_children =
max_matches =
seamless_rotate =
preopen_indexes =
unlink_old =
pid_file =/usr/local/coreseek/var/log/searchd_mysql.pid #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
log =/usr/local/coreseek/var/log/searchd_mysql.log #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
query_log =/usr/local/coreseek/var/log/query_mysql.log #请修改为实际使用的绝对路径，例如：/usr/local/coreseek/var/...
}

header("Content-type: text/html; charset=utf-8");
//require("./ ");
$s = new SphinxClient;
$s->setServer("127.0.0.1", 9312);
//SPH_MATCH_ALL, 匹配所有查询词(默认模式); SPH_MATCH_ANY, 匹配查询词中的任意一个; SPH_MATCH_EXTENDED2, 支持特殊运算符查询
$s->setMatchMode(SPH_MATCH_ALL);
$s->setMaxQueryTime(30); //设置最大搜索时间
$s->SetArrayResult(false); //是否将Matches的key用ID代替
$s->SetSelect ( "*" ); //设置返回信息的内容,等同于SQL
$s->SetRankingMode(SPH_RANK_BM25);
$s->SetLimits ( 0, 30, 1000, 0 ); //设置结果集偏移量 SetLimits
$res = $s->query('coreseek','mysql','--single-0-query--'); #[coreseek]关键字，[mysql]数据源source $err = $s->GetLastError();
echo '<pre>';
var_dump($res);
var_dump($res['matches']);
var_export($err);
echo '</pre>';

# cd /var/install/coreseek-4.1-beta/csft-4.1/api/libsphinxclient/
# ./configure --prefix=/usr/local/sphinxclientconfigure: creating ./config.status
config.status: creating Makefile
config.status: error: cannot find input file: Makefile.in #报错configure失败 //处理configure报错
编译过程中报了一个config.status: error: cannot find input file: src/Makefile.in这个的错误，然后运行下列指令再次编译就能通过了：
# aclocal
# libtoolize --force
# automake --add-missing
# autoconf
# autoheader
# make clean//从新configure编译
# ./configure# make && make install

http://pecl.php.net/package/sphinx
# wget http://pecl.php.net/get/sphinx-1.3.0.tgz
# tar zxvf sphinx-1.3..tgz
# cd sphinx-1.3.
# phpize
# ./configure --with-php-config=/usr/bin/php-config --with-sphinx=/usr/local/sphinxclient
# make && make install
# cd /etc/php.d/
# cp gd.ini sphinx.ini
# vi sphinx.iniextension=sphinx.so# service php-fpm restart

$where = array();
$where['uid']=$uid;
if(!empty($search)){ //有需要查找的内容，则去 coreseek 忠查出对应的id
$coreseek = new \SphinxClient();
$coreseek->setServer("127.0.0.1", 9312);
//SPH_MATCH_ALL, 匹配所有查询词(默认模式); SPH_MATCH_ANY, 匹配查询词中的任意一个; SPH_MATCH_EXTENDED2, 支持特殊运算符查询
$coreseek->setMatchMode(SPH_MATCH_ALL);
$coreseek->setMaxQueryTime(30); //设置最大搜索时间
$coreseek->SetArrayResult(false); //是否将Matches的key用ID代替
$coreseek->SetSelect ( "*" ); //设置返回信息的内容,等同于SQL
$coreseek->SetLimits ( 0, 30, 1000, 0 ); //设置结果集偏移量 SetLimits
$res = $coreseek->query($search,'mysql','--single-0-query--');
$key = array_keys($res['matches']);
$where['id']=array('in',$key);
$coreseek->close();
}else{ }
//获取总数据条数
$total=$mod->where($where)->count();

if(!empty($search)){
$page->parameter['search']=$search;
//代码高亮
$opt = array("before_match"=>"<font style='font-weight:bold;color:#f00'>","after_match"=>"</font>");
$coreseek1 = new \SphinxClient();
$coreseek1->setServer("127.0.0.1", 9312);
$coreseek1->SetMatchMode(SPH_MATCH_ALL);
$i=0;
$tags_title=array();
foreach($info as $key=>$row){
$tags_title[]=$row['title'];
}
$replace_title=$coreseek1->BuildExcerpts($tags_title,'mysql',$search,$opt);
foreach($info as $key=>&$row){
$info[$key]['title']=$replace_title[$key];
}
$coreseek1->close();
}