搜索表单 php

<!DOCTYPE html>
<html>
<head>
    <title>搜索表单</title>
</head>
<body>
    <form action="search.php" method="GET">
        <input type="text" name="query" placeholder="输入搜索关键词">
        <button type="submit">搜索</button>
    </form>
</body>
</html>

<?php
// search.php
if (isset($_GET['query'])) {
    $query = $_GET['query'];
    // 连接数据库
    $conn = new mysqli("localhost", "username", "password", "database");
    if ($conn->connect_error) {
        die("连接失败: " . $conn->connect_error);
    }
    // 执行查询
    $sql = "SELECT * FROM table_name WHERE column_name LIKE '%$query%'";
    $result = $conn->query($sql);
    if ($result->num_rows > 0) {
        while($row = $result->fetch_assoc()) {
            echo "ID: " . $row["id"]. " - Name: " . $row["name"]. "<br>";
        }
    } else {
        echo "没有找到结果";
    }
    $conn->close();
}
?>

$stmt = $conn->prepare("SELECT * FROM table_name WHERE column_name LIKE ?");
$stmt->bind_param("s", $query);
$stmt->execute();
$result = $stmt->get_result();

$query = mysqli_real_escape_string($conn, $_GET['query']);