phpweb 自定义搜索

// 示例代码：使用 MySQL 全文索引进行搜索
$query = "SELECT * FROM articles WHERE MATCH(title, content) AGAINST('keyword' IN NATURAL LANGUAGE MODE)";
$result = mysqli_query($conn, $query);

// 示例代码：使用 Redis 缓存搜索结果
$redis = new Redis();
$redis->connect('127.0.0.1', 6379);

$cacheKey = 'search_result_' . md5($keyword);
if ($redis->exists($cacheKey)) {
    $result = json_decode($redis->get($cacheKey), true);
} else {
    $query = "SELECT * FROM articles WHERE MATCH(title, content) AGAINST('keyword' IN NATURAL LANGUAGE MODE)";
    $result = mysqli_query($conn, $query);
    $redis->setex($cacheKey, 3600, json_encode($result));
}

// 示例代码：使用 Elasticsearch 进行搜索
require 'vendor/autoload.php';

use Elasticsearch\ClientBuilder;

$client = ClientBuilder::create()->build();

$params = [
    'index' => 'articles',
    'body' => [
        'query' => [
            'match' => [
                'title' => 'keyword'
            ]
        ]
    ]
];

$response = $client->search($params);