当前位置：首页 > PHP

php搜索功能实现

2026-01-14 12:47:39PHP

实现基本的PHP搜索功能

使用MySQL数据库和PHP实现简单的关键词搜索功能。需要确保数据库中有可供搜索的表和数据。

// 连接数据库
$conn = new mysqli('localhost', 'username', 'password', 'database_name');

// 获取搜索关键词
$searchTerm = $_GET['search'] ?? '';

// 准备SQL查询
$sql = "SELECT * FROM products WHERE name LIKE ? OR description LIKE ?";
$stmt = $conn->prepare($sql);

// 绑定参数
$searchParam = "%$searchTerm%";
$stmt->bind_param("ss", $searchParam, $searchParam);

// 执行查询
$stmt->execute();
$result = $stmt->get_result();

// 显示结果
while ($row = $result->fetch_assoc()) {
    echo $row['name'] . ": " . $row['description'] . "<br>";
}

// 关闭连接
$stmt->close();
$conn->close();

实现分页搜索功能

在基本搜索基础上添加分页支持，避免返回大量结果导致性能问题。

php搜索功能实现

// 分页参数
$page = $_GET['page'] ?? 1;
$perPage = 10;
$offset = ($page - 1) * $perPage;

// 修改SQL添加LIMIT
$sql = "SELECT * FROM products WHERE name LIKE ? OR description LIKE ? LIMIT ? OFFSET ?";
$stmt = $conn->prepare($sql);

// 绑定参数
$stmt->bind_param("ssii", $searchParam, $searchParam, $perPage, $offset);

实现高级搜索功能

添加多个搜索条件和筛选选项，提供更精确的搜索结果。

// 获取多个搜索条件
$category = $_GET['category'] ?? '';
$minPrice = $_GET['min_price'] ?? 0;
$maxPrice = $_GET['max_price'] ?? PHP_FLOAT_MAX;

// 构建动态SQL
$sql = "SELECT * FROM products WHERE (name LIKE ? OR description LIKE ?)";
$params = ["%$searchTerm%", "%$searchTerm%"];
$types = "ss";

if (!empty($category)) {
    $sql .= " AND category = ?";
    $params[] = $category;
    $types .= "s";
}

if ($minPrice > 0 || $maxPrice < PHP_FLOAT_MAX) {
    $sql .= " AND price BETWEEN ? AND ?";
    $params[] = $minPrice;
    $params[] = $maxPrice;
    $types .= "dd";
}

实现全文索引搜索

对于大型数据库，使用MySQL的全文索引提高搜索效率和相关性。

php搜索功能实现

// 创建全文索引(需要在MySQL中执行)
ALTER TABLE products ADD FULLTEXT(name, description);

// PHP中使用MATCH AGAINST语法
$sql = "SELECT *, MATCH(name, description) AGAINST(? IN NATURAL LANGUAGE MODE) AS score 
        FROM products 
        WHERE MATCH(name, description) AGAINST(? IN NATURAL LANGUAGE MODE) 
        ORDER BY score DESC";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", $searchTerm);

实现搜索结果高亮显示

在返回的搜索结果中高亮显示匹配的关键词，提升用户体验。

function highlightKeywords($text, $keywords) {
    $keywords = preg_split('/\s+/', $keywords);
    foreach ($keywords as $keyword) {
        $text = preg_replace("/\b($keyword)\b/i", "<span style='background-color:yellow'>$1</span>", $text);
    }
    return $text;
}

// 在显示结果时调用
echo highlightKeywords($row['name'], $searchTerm) . ": " . 
     highlightKeywords($row['description'], $searchTerm) . "<br>";

实现搜索建议/自动完成

添加AJAX搜索建议功能，在用户输入时提供实时建议。

// 前端JavaScript代码
document.getElementById('search-input').addEventListener('input', function() {
    fetch('search_suggestions.php?term=' + encodeURIComponent(this.value))
        .then(response => response.json())
        .then(data => {
            // 更新建议列表
        });
});

// search_suggestions.php
$term = $_GET['term'] ?? '';
$sql = "SELECT name FROM products WHERE name LIKE ? LIMIT 5";
$stmt = $conn->prepare($sql);
$stmt->bind_param("s", "%$term%");
$stmt->execute();
$result = $stmt->get_result();

$suggestions = [];
while ($row = $result->fetch_assoc()) {
    $suggestions[] = $row['name'];
}

header('Content-Type: application/json');
echo json_encode($suggestions);