欢迎来到深圳市房地产信息查询平台。
PHP查询处理代码(search.php)
php
connect_error) {die("数据库连接失败:" . $conn->connect_error);
}// 获取查询关键字
$keyword = $_GET["keyword"];// 构建查询语句
$sql = "SELECT FROM properties WHERE address LIKE '%$keyword%' OR name LIKE '%$keyword%'";// 执行查询
$result = $conn->query($sql);
if (!$result) {die("查询失败:" . $conn->error);
}// 输出查询结果
echo "
";
while ($row = $result->fetch_assoc()) {echo "
-
{$row['address']} - {$row['name']}
";
}
echo "
";// 关闭数据库连接
$conn->close();
?>CSS样式(style.css)
css
body {font-family: Arial, Helvetica, sans-serif;
}main {display: flex;justify-content: space-between;
}search {width: 30%;padding: 20px;border: 1px solid ccc;border-radius: 5px;
}search form {display: flex;flex-direction: column;
}results {width: 70%;padding: 20px;border: 1px solid ccc;border-radius: 5px;overflow-y: auto;max-height: 500px;
}results ol {list-style-type: none;padding: 0;
}results ol li {padding: 5px;border-bottom: 1px dashed ccc;
}footer {text-align: center;margin-top: 20px;
}