上海房产网58 (上海房产网二手房源)

二手房源

connect_error) {die("Connection failed: " . $conn->connect_error); }//Get the search parameters$district = $_GET["district"];$price = $_GET["price"];$bedroom = $_GET["bedroom"];//Build the query$query = "SELECT FROM properties WHERE ";if ($district != "all") {$query .= "district='$district' AND ";}if ($price != "all") {$query .= "price BETWEEN ";switch ($price) {case "less_than_1000":$query .= "0 AND 10000000";break;case "1000_to_2000":$query .= "10000000 AND 20000000";break;case "2000_to_3000":$query .= "20000000AND 30000000";break;case "3000_to_4000":$query .= "30000000 AND 40000000";break;case "4000_to_5000":$query .= "40000000 AND 50000000";break;case "5000_plus":$query .= "50000000 AND 1000000000000";break;}$query .= " AND ";}if ($bedroom != "all") {$query .= "bedrooms=$bedroom AND ";}$query = substr($query, 0, -5); //Remove the last "AND "//Execute the query$result = $conn->query($query);//Display the resultsif ($result->num_rows > 0) {while ($row = $result->fetch_assoc()) {echo "
• ";echo "

  " . $row["address"] . "

  ";echo "

  价格: " . $row["price"] . "

  ";echo "

  卧室数: " . $row["bedrooms"] . "

  ";echo "

  面积: " . $row["square_feet"] . "平方米

  ";echo "

  类型: " . $row["type"] . "

  ";echo " 详情 ";echo "
";}} else {echo "
• 没有满足条件的房源
";}//Close the connection$conn->close();?>