二手房出售
connect_error) {die("连接数据库失败:" . $conn->connect_error);}// 设置查询条件$where = array();if (isset($_GET['district']) && $_GET['district'] != 'all'){$where[] = "district = '" . $_GET['district'] . "'";}if (isset($_GET['type']) && $_GET['type'] != 'all') {$where[] = "type = '" . $_GET['type'] . "'";}if (isset($_GET['price']) && $_GET['price'] != 'all') {$price_range = explode('-', $_GET['price']);$where[] = "price >= " . $price_range[0] . " AND price <= " . $price_range[1];}if (isset($_GET['area']) && $_GET['area'] != 'all') {$area_range = explode('-',$_GET['area']);$where[] = "area >= " . $area_range[0] . " AND area <= " . $area_range[1];}// 构建查询语句$sql = "SELECT FROM properties";if (count($where) > 0) {$sql .= " WHERE " . implode(' AND ', $where);}$result = $conn->query($sql);// 输出搜索结果if ($result->num_rows > 0) {while ($row = $result->fetch_assoc()) {echo "
";echo "
";echo "
";echo "
";echo "
";echo "
" . $row['title'] . "
";echo "
" . $row['address'] . "
";echo "
" . $row['type'] . " | " . $row['area'] . "平 | " . $row['price'] . "万
";echo "
查看详情
";echo "
";echo "
";}} else {echo "
没有找到符合条件的二手房。
";}// 关闭数据库连接
$conn->close();?>