二手回收网站利用PHP开发的精准搜索功能

// 接收用户输入的关键字
$keyword = $_GET['keyword'];

// 查询数据库，返回匹配的商品列表
$sql = "SELECT * FROM goods WHERE name LIKE '%$keyword%'";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    // 处理每个商品信息的显示
    echo $row['name'] . ' - ' . $row['price'] . ' - ' . $row['location'] . '<br>';
}

// 接收用户选择的类别
$category = $_GET['category'];

// 查询数据库，返回该类别下的商品列表
$sql = "SELECT * FROM goods WHERE category = $category";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    // 处理每个商品信息的显示
    echo $row['name'] . ' - ' . $row['price'] . ' - ' . $row['location'] . '<br>';
}

// 接收用户设置的价格范围
$minPrice = $_GET['minPrice'];
$maxPrice = $_GET['maxPrice'];

// 查询数据库，返回价格在该范围内的商品列表
$sql = "SELECT * FROM goods WHERE price >= $minPrice AND price <= $maxPrice";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    // 处理每个商品信息的显示
    echo $row['name'] . ' - ' . $row['price'] . ' - ' . $row['location'] . '<br>';
}

// 接收用户选择的地区
$location = $_GET['location'];

// 查询数据库，返回该地区内的商品列表
$sql = "SELECT * FROM goods WHERE location = '$location'";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    // 处理每个商品信息的显示
    echo $row['name'] . ' - ' . $row['price'] . ' - ' . $row['location'] . '<br>';
}

// 获取用户输入的各个筛选条件
$keyword = $_GET['keyword'];
$category = $_GET['category'];
$minPrice = $_GET['minPrice'];
$maxPrice = $_GET['maxPrice'];
$location = $_GET['location'];

// 根据用户的选择，构建查询语句
$sql = "SELECT * FROM goods WHERE name LIKE '%$keyword%' AND category = $category AND price >= $minPrice AND price <= $maxPrice AND location = '$location'";
$result = mysqli_query($conn, $sql);
while ($row = mysqli_fetch_assoc($result)) {
    // 处理每个商品信息的显示
    echo $row['name'] . ' - ' . $row['price'] . ' - ' . $row['location'] . '<br>';
}