当前位置：首页 > PHP

php搜索功能实现的

2026-02-13 13:36:55PHP

实现PHP搜索功能的基本方法

PHP搜索功能通常通过结合数据库查询和表单处理实现。以下是几种常见的实现方式：

使用MySQL LIKE语句实现基础搜索

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

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

// 执行查询
$stmt = $conn->prepare("SELECT * FROM products WHERE name LIKE ?");
$searchParam = "%{$searchTerm}%";
$stmt->bind_param("s", $searchParam);
$stmt->execute();
$result = $stmt->get_result();

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

实现多字段搜索

$searchTerm = $_GET['search'] ?? '';
if (!empty($searchTerm)) {
    $stmt = $conn->prepare("SELECT * FROM articles 
                          WHERE title LIKE ? OR content LIKE ?");
    $searchParam = "%{$searchTerm}%";
    $stmt->bind_param("ss", $searchParam, $searchParam);
    // 其余处理逻辑...
}

使用全文索引提高搜索效率

对于大型数据集，建议使用MySQL的FULLTEXT索引：

-- 创建表时添加全文索引
ALTER TABLE articles ADD FULLTEXT(title, content);

PHP查询代码：

$stmt = $conn->prepare("SELECT * FROM articles 
                      WHERE MATCH(title, content) AGAINST(? IN NATURAL LANGUAGE MODE)");
$stmt->bind_param("s", $searchTerm);

实现分页功能

$page = $_GET['page'] ?? 1;
$limit = 10;
$offset = ($page - 1) * $limit;

$stmt = $conn->prepare("SELECT * FROM products 
                       WHERE name LIKE ? LIMIT ? OFFSET ?");
$stmt->bind_param("sii", $searchParam, $limit, $offset);

添加高级搜索选项

可以通过HTML表单提供更多搜索选项：

<form method="GET" action="search.php">
    <input type="text" name="query" placeholder="搜索...">
    <select name="category">
        <option value="">所有分类</option>
        <option value="1">电子产品</option>
        <option value="2">图书</option>
    </select>
    <input type="number" name="min_price" placeholder="最低价格">
    <button type="submit">搜索</button>
</form>

PHP处理代码：

$query = $_GET['query'] ?? '';
$category = $_GET['category'] ?? '';
$minPrice = $_GET['min_price'] ?? 0;

$sql = "SELECT * FROM products WHERE 1=1";
$params = [];
$types = '';

if (!empty($query)) {
    $sql .= " AND name LIKE ?";
    $params[] = "%{$query}%";
    $types .= 's';
}

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

if ($minPrice > 0) {
    $sql .= " AND price >= ?";
    $params[] = $minPrice;
    $types .= 'd';
}

$stmt = $conn->prepare($sql);
if (!empty($params)) {
    $stmt->bind_param($types, ...$params);
}

安全注意事项

所有用户输入必须进行验证和过滤：

$searchTerm = filter_input(INPUT_GET, 'search', FILTER_SANITIZE_STRING);
$page = filter_input(INPUT_GET, 'page', FILTER_VALIDATE_INT, [
    'options' => ['default' => 1, 'min_range' => 1]
]);