sphinx的简单实例

sphinx.conf中的配置：

 1 source indexLocation
 2 {
 3     type            = mysql
 4 
 5     sql_host        = 192.168.1.113
 6     sql_user        = root
 7     sql_pass        = redidai@@2013
 8     sql_db            = redidai
 9     sql_port        = 3306    # optional, default is 3306
10     
11     sql_query_pre = SET NAMES utf8
12     sql_query_pre = SET SESSION query_cache_type=OFF
13     
14     sql_query        = 
15         SELECT a.location_id as id,a.location_id,a.location_name as `location_name`,a.location_name as `name`,a.location_bname,a.attach_id,a.showstatus,a.is_del,a.status,b.area_name as city_name FROM `ts_rdd_location` a LEFT JOIN `ts_rdd_area` b ON a.city_id = b.area_id
16     #sql_attr_string =  name
17     sql_attr_uint        = status
18     #sql_attr_timestamp    = date_added
19     sql_query_info        = SELECT * FROM `ts_rdd_location`  WHERE location_id = $id
20 }
21 
22 
23 index indexLocation
24 {
25     source            = indexLocation
26     path            = /var/lib/sphinx/test1
27     docinfo            = extern
28     mlock          = 0                       #缓存数据内存锁定
29     morphology     = none                    #形态学（对中文无效）
30     min_word_len   = 2                       #索引的词最小长度
31     charset_type   = utf-8
32     min_prefix_len = 0                       #最小前缀
33     html_strip     = 1
34     ngram_len      = 1                       #对于非字母型数据的长度切割
35     ngram_chars    = U+3000..U+2FA1F         #则会对每个中文，英文字词进行分割，速度会慢
36 
37     #字符表，注意：如使用这种方式，则sphinx会对中文进行单字切分，即进行字索引。
38     #若要使用中文分词，必须使用其他分词插件如 coreseek，sfc
39     charset_table  = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
40 }
41 
42 
43 
44 
45 indexer
46 {
47     mem_limit        = 32M
48 }
49 
50 
51 searchd
52 {
53     listen                  = 9312
54     #listen            = 9306:mysql41
55     log            = /var/log/sphinx/searchd.log
56     query_log        = /var/log/sphinx/query.log
57     read_timeout        = 5
58     max_children        = 30
59     pid_file        = /var/run/sphinx/searchd.pid
60     max_matches        = 1000
61     seamless_rotate        = 1
62     preopen_indexes        = 1
63     unlink_old        = 1
64     compat_sphinxql_magics = 0
65     #workers            = threads # for RT to work
66     binlog_path        = /var/lib/sphinx
67 }

php代码：

 1 <?php
 2 class SearchAction extends AdministratorAction {
 3 
 4     public $sphinxClient = null;
 5 
 6     public function __construct() {
 7         parent::__construct();
 8 
 9         require_once SITE_PATH . '/sphinxapi.php';
10 
11         if ($this->sphinxClient == null) {
12             $this->sphinxClient = new SphinxClient ();
13         }
14 
15         $this->sphinxClient->SetServer('192.168.0.0', 9312);
16         $this->sphinxClient->open();
17     }
18 
19     public function QLocation($params = array()) {
20         $searchWord = '';
21         
22         if (isset($params['keyword'])) {
23             $searchWord = $params['keyword'];
24         }
25         
26         $result = $this->suggestHandle($this->sphinxClient, $searchWord);
27 
28         $nodeResult = array();
29 
30         if ($result['total'] > 0) {
31             $matches = array();
32             
33             foreach($result['matches'] as $mvale) {
34                 $matches[] = $mvale['id'];
35             }
36             
37             $matches_id = implode(",", $matches);
38             
39             $locationModel = D('RddLocation', 'admin');
40             $list = $locationModel->getLocationListByID($matches_id);
41             $nodeResult = $list;
42         }
43         
44         print_r($nodeResult);exit;
45 
46         return $nodeResult;
47     }
48 
49     public function suggestHandle($spx, $searchWord = ''){
50         //$spx->SetSortMode(SPH_SORT_EXTENDED, "@weight DESC, larea DESC, is_recommend DESC, like_count DESC");
51         $spx->SetSortMode(SPH_SORT_EXTENDED, "@weight DESC");
52         $spx->ResetFilters();
53         //$cityId = filter_input(INPUT_GET, 'area', FILTER_SANITIZE_STRING);
54         //$spx->SetFilter('showstatus', array('Y'));
55         //$spx->SetFilter('is_del', array('0'));
56         $spx->SetFilter('status', array(1));
57         //$result = $spx->Query($searchWord, 'plan14_location,delta_plan14_location');
58         $spx->SetArrayResult(true);
59         $result = $spx->Query($searchWord, 'indexLocation');
60         //var_dump($spx);
61         return $result;
62     }
63 
64 }

调用：

$searchAction = new SearchAction();
        $list = $searchAction->QLocation(array('keyword' => $name));