PHP 및 Manticore Search를 사용하여 다국어 검색 기능 개발

$ indexer -c /path/to/manticore.conf --all

$mysqli = new mysqli('host', 'user', 'password', 'database'); if ($mysqli->connect_errno) { die("Failed to connect to MySQL: " . $mysqli->connect_error); }

$sql = 'SELECT id, product_name_en, product_name_cn FROM products'; $result = $mysqli->query($sql); $all_rows = ''; while ($row = $result->fetch_assoc()) { $all_rows .= '(' . $row['id'] . ', "' . $row['product_name_en'] . '", "' . $row['product_name_cn'] . '"),'; } $all_rows = rtrim($all_rows, ','); $sql = 'REPLACE INTO products (id, product_name_en, product_name_cn) VALUES ' . $all_rows; $mysqli->query($sql); if ($mysqli->error) { die("Failed to insert data into Manticore Search: " . $mysqli->error); }

$query = 'apple'; // 根据当前语言选择搜索字段 $language = 'en'; if ($language === 'cn') { $search_field = 'product_name_cn'; } else { $search_field = 'product_name_en'; } // 连接Manticore Search的搜索接口 $cl = new ManticoreSearchClient(); $cl->connect(); // 执行搜索 $result = $cl->search('products', $query, array('index' => 'products', 'field_weights' => array($search_field => 100))); // 解析搜索结果 $matches = array(); if ($result['total'] > 0) { foreach ($result['matches'] as $match) { $matches[] = $match['attrs']['id']; } } // 查询原始数据 $sql = 'SELECT * FROM products WHERE id IN (' . implode(',', $matches) . ')'; $result = $mysqli->query($sql); while ($row = $result->fetch_assoc()) { echo $row['product_name_en'] . '
'; }