The example in this article describes the sphinx index configuration method in the Yii framework. Share it with everyone for your reference, the details are as follows:

Please import var/test/documents.sql into the database first, and configure the following MySQL user password database

#源定義
source mysql
{
  type          = mysql
  sql_host        = localhost
  sql_user        = root
  sql_pass        = root
  sql_db          = yii2
  sql_port        = 3306
  sql_query_pre      = SET NAMES utf8
  sql_query        = SELECT id, zhan_name, url, title, xu_id, status, UNIX_TIMESTAMP(addtime) as addtime FROM zhan
  #sql_query第一列id需為整數(shù)
  #title、content作為字符串/文本字段，被全文索引
  #sql_attr_uint      = price      #從SQL讀取到的值必須為整數(shù)
  sql_attr_timestamp    = addtime  #從SQL讀取到的值必須為整數(shù)，作為時(shí)間屬性
  sql_query_info_pre   = SET NAMES utf8                    #命令行查詢時(shí)，設(shè)置正確的字符集
  sql_query_info      = SELECT * FROM zhan WHERE id=$id #命令行查詢時(shí)，從數(shù)據(jù)庫(kù)讀取原始數(shù)據(jù)信息
}
#源定義2
source mysql_goods
{
  type          = mysql
  sql_host        = localhost
  sql_user        = root
  sql_pass        = root
  sql_db          = yii2
  sql_port        = 3306
  sql_query_pre      = SET NAMES utf8
  sql_query        = SELECT id, goods_name, price FROM goods
  #sql_query第一列id需為整數(shù)
  #title、content作為字符串/文本字段，被全文索引
  sql_attr_uint      = price      #從SQL讀取到的值必須為整數(shù)
  #sql_attr_timestamp    = addtime #從SQL讀取到的值必須為整數(shù)，作為時(shí)間屬性
  sql_query_info_pre   = SET NAMES utf8                    #命令行查詢時(shí)，設(shè)置正確的字符集
  sql_query_info      = SELECT * FROM goods WHERE id=$id #命令行查詢時(shí)，從數(shù)據(jù)庫(kù)讀取原始數(shù)據(jù)信息
}
#index定義
index mysql
{
  source      = mysql       #對(duì)應(yīng)的source名稱
  path      = D:/yii/advanced/vendor/coreseek-4.1-win32/var/data/mysql #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
  docinfo      = extern
  mlock      = 0
  morphology    = none
  min_word_len    = 1
  html_strip        = 0
  #charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux環(huán)境下設(shè)置，/符號(hào)結(jié)尾
  charset_dictpath = D:/yii/advanced/vendor/coreseek-4.1-win32/etc/               #Windows環(huán)境下設(shè)置，/符號(hào)結(jié)尾，最好給出絕對(duì)路徑，例如：C:/usr/local/coreseek/etc/...
  charset_type    = zh_cn.utf-8
}
#index定義2
index mysql_goods
{
  source      = mysql_goods      #對(duì)應(yīng)的source名稱
  path      = D:/yii/advanced/vendor/coreseek-4.1-win32/var/data/goods #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
  docinfo      = extern
  mlock      = 0
  morphology    = none
  min_word_len    = 1
  html_strip        = 0
  #charset_dictpath = /usr/local/mmseg3/etc/ #BSD、Linux環(huán)境下設(shè)置，/符號(hào)結(jié)尾
  charset_dictpath = D:/yii/advanced/vendor/coreseek-4.1-win32/etc/               #Windows環(huán)境下設(shè)置，/符號(hào)結(jié)尾，最好給出絕對(duì)路徑，例如：C:/usr/local/coreseek/etc/...
  charset_type    = zh_cn.utf-8
}
#全局index定義
indexer
{
  mem_limit      = 128M
}
#searchd服務(wù)定義
searchd
{
  listen         =  9312
  read_timeout    = 5
  max_children    = 30
  max_matches      = 1000
  seamless_rotate    = 0
  preopen_indexes    = 0
  unlink_old      = 1
  pid_file = D:/yii/advanced/vendor/coreseek-4.1-win32/var/log/searchd_mysql.pid #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
  log = D:/yii/advanced/vendor/coreseek-4.1-win32/var/log/searchd_mysql.log    #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
  query_log = D:/yii/advanced/vendor/coreseek-4.1-win32/var/log/query_mysql.log #請(qǐng)修改為實(shí)際使用的絕對(duì)路徑，例如：/usr/local/coreseek/var/...
  binlog_path =                #關(guān)閉binlog日志
}

I hope that this article will help you design PHP programs based on the Yii framework Helps.

For more articles related to the analysis of the sphinx index configuration method in the Yii framework, please pay attention to the PHP Chinese website!