当前位置：首页 > PHP

php搜索功能实现的

2026-02-27 12:16:32PHP

PHP搜索功能实现方法

基本搜索实现

使用SQL的LIKE语句实现基础搜索功能。在PHP中连接数据库后，构建查询语句：

$searchTerm = $_GET['search'];
$query = "SELECT * FROM products WHERE name LIKE '%$searchTerm%'";
$result = mysqli_query($connection, $query);

确保对用户输入进行过滤防止SQL注入：

$searchTerm = mysqli_real_escape_string($connection, $_GET['search']);

全文索引搜索

对于更高效的搜索，可在MySQL表上创建全文索引：

ALTER TABLE articles ADD FULLTEXT(title, content);

PHP中使用MATCH AGAINST语法：

$query = "SELECT * FROM articles WHERE MATCH(title, content) AGAINST('$searchTerm')";

分页处理

大型搜索结果需要分页显示：

$perPage = 10;
$page = isset($_GET['page']) ? (int)$_GET['page'] : 1;
$offset = ($page - 1) * $perPage;

$query = "SELECT * FROM products WHERE name LIKE '%$searchTerm%' LIMIT $offset, $perPage";

高亮显示结果

在显示搜索结果时高亮匹配关键词：

echo preg_replace("/$searchTerm/i", "<span class='highlight'>$0</span>", $row['name']);

高级搜索功能

实现多条件组合搜索：

$conditions = [];
if(!empty($_GET['keyword'])) {
    $conditions[] = "title LIKE '%".mysqli_real_escape_string($keyword)."%'";
}
if(!empty($_GET['category'])) {
    $conditions[] = "category_id = ".(int)$_GET['category'];
}

$query = "SELECT * FROM products";
if(count($conditions) > 0) {
    $query .= " WHERE ".implode(' AND ', $conditions);
}

使用搜索引擎扩展

对于大型应用，可集成Elasticsearch或Algolia等专业搜索引擎：

$client = Elasticsearch\ClientBuilder::create()->build();
$params = [
    'index' => 'products',
    'body' => [
        'query' => [
            'match' => [
                'name' => $searchTerm
            ]
        ]
    ]
];

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