利用PHP和coreseek实现精准的图片驱动搜索功能

$ wget http://sphinxsearch.com/files/sphinx-2.2.11-release.tar.gz
$ tar -xzf sphinx-2.2.11-release.tar.gz
$ cd sphinx-2.2.11-release
$ ./configure --prefix=/usr/local/coreseek
$ make && make install

source src1
{
    type = mysql
    sql_host = localhost
    sql_user = root
    sql_pass = your_p@ssword
    sql_db = your_database_name
    sql_port = 3306
}

index img_index
{
    type = rt
    rt_mem_limit = 1024M
    path = /usr/local/coreseek/var/data/img_index
    morphology = stem_en
    min_word_len = 1
    charset_dictpath = /usr/local/coreseek/var/data/dict
    charset_type = zh_cn.utf-8
    charset_table = 0..9, A..Z->a..z, _, a..z, U+410..U+42F->U+430..U+44F, U+430..U+44F
    rt_field = description
    rt_attr_uint = categoryId
    rt_attr_uint = uploaderId
    rt_attr_timestamp = uploadTime
}

indexer
{
    mem_limit = 256M
}

searchd
{
    listen = 9312
    log = /usr/local/coreseek/var/log/searchd.log
    query_log = /usr/local/coreseek/var/log/query.log
    read_timeout = 5
    max_children = 30
    pid_file = /usr/local/coreseek/var/log/searchd.pid
    max_matches = 1000
}

<?php
require_once('sphinxapi.php');
$sphinx = new SphinxClient();
$sphinx->SetServer('localhost', 9312);
$sphinx->SetConnectTimeout(3);
$sphinx->SetArrayResult(true);

$keyword = $_GET['keyword']; // 获取用户输入的关键词

$sphinx->SetMatchMode(SPH_MATCH_EXTENDED); // 使用扩展模式
$sphinx->SetSortMode(SPH_SORT_ATTR_ASC, 'uploadTime'); // 根据上传时间排序
$sphinx->SetLimits(0, 10); // 每页显示10条结果

$queryResult = $sphinx->Query($keyword, 'img_index'); // 查询结果

$ids = array();
if ($queryResult && isset($queryResult['matches'])) {
    foreach ($queryResult['matches'] as $match) {
        $ids[] = $match['id'];
    }
}

// 根据搜索结果获取对应的图片信息，并进行展示
if (!empty($ids)) {
    $db = new PDO("mysql:host=localhost;dbname=your_database_name", "root", "your_p@ssword");
    $stmt = $db->prepare("SELECT * FROM images WHERE id IN (".implode(',', $ids).")");
    $stmt->execute();
    $images = $stmt->fetchAll(PDO::FETCH_ASSOC);

    foreach ($images as $image) {
        echo '<img src="'.$image['url'].'" alt="'.$image['description'].'">';
    }
} else {
    echo '没有找到相关图片';
}