= ".$_POST['Zvon']." "; $zimmer = "mehr als ".$_POST['Zvon']." Zimmer"; } elseif (("" == $_POST['Zvon']) AND ("" !== $_POST['Zbis'])) { $filter = $filter. "AND Zimmer <= ".$_POST['Zbis']." "; $zimmer = "bis ".$_POST['Zbis']." Zimmer"; } else { $filter = $filter. "AND Zimmer BETWEEN ".$_POST['Zvon']." AND ".$_POST['Zbis']." "; $zimmer = $_POST['Zvon']." bis ".$_POST['Zbis']." Zimmer"; } if (("" == $_POST['Wvon']) AND ("" == $_POST['Wbis'])) { } elseif (("" !== $_POST['Wvon']) AND ("" == $_POST['Wbis'])) { $filter = $filter. "AND WohnF >= ".$_POST['Wvon']." "; $wohn = "mehr als ".$_POST['Wvon']." m²"; } elseif (("" == $_POST['Wvon']) AND ("" !== $_POST['Wbis'])) { $filter = $filter. "AND WohnF <= ".$_POST['Wbis']." "; $wohn = "bis ".$_POST['Wbis']." m²"; } else { $filter = $filter. "AND WohnF BETWEEN ".$_POST['Wvon']." AND ".$_POST['Wbis']." "; $wohn = $_POST['Wvon']." bis ".$_POST['Wbis']." m²"; } if (("" == $_POST['Kvon']) AND ("" == $_POST['Kbis'])) { } elseif (("" !== $_POST['Kvon']) AND ("" == $_POST['Kbis'])) { $filter = $filter. "AND Mkalt >= ".$_POST['Kvon']." "; $kalt = "mehr als ".$_POST['Kvon']." EUR"; } elseif (("" == $_POST['Kvon']) AND ("" !== $_POST['Kbis'])) { $filter = $filter. "AND Mkalt <= ".$_POST['Kbis']." "; $kalt = "bis ".$_POST['Kbis']." EUR"; } else { $filter = $filter. "AND Mkalt BETWEEN ".$_POST['Kvon']." AND ".$_POST['Kbis']." "; $kalt = $_POST['Kvon']." bis ".$_POST['Kbis']." EUR"; } } else { $zimmer = ''; $wohn = ''; $kalt = ''; $filter = ''; } echo "

Häuser zur Miete

\n"; $sql = 'SELECT * FROM objekte WHERE Aktiv = 1 AND Deaktiv = 0 AND O_TYP = "Haus" AND V_TYP = "Miete" '.$filter.' ORDER BY Akt_Datum DESC'; $result = $db->query($sql); $anzahl = $result->num_rows; echo "

\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (1 !== $anzahl) { echo " \n"; } else { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if (isset($_POST['formaction'])) { echo " \n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "

Suchkriterien	$anzahl Häuser im Angebot	$anzahl Haus im Angebot
Zimmer:		bis		mit folgenden Kriterien:
Wohnfläche:		bis	m²	$zimmer
Kaltmiete:		bis	EUR	$wohn
	$kalt

\n"; echo "
\n"; echo "

\n"; echo "
\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; while ($nt = $result->fetch_assoc()) { unset ( $spezial ); if ( '1' == $nt['Balkon'] ) { $spezial[] = "\n"; } if ( '1' == $nt['Terrasse'] ) { $spezial[] = "\n"; } if ( 'keineAngabe' != $nt['EnerTyp'] ) { $spezial[] = "\n"; } if ( '1' == $nt['Garten'] ) { $spezial[] = "\n"; } if ( '1' == $nt['Garage'] ) { $spezial[] = "\n"; } if ( '1' == $nt['EinbauK'] ) { $spezial[] = "\n"; } if ( ! isset ( $spezial ) ) { $spezial[] = "\n"; } while ( count( $spezial ) < 4 ) { $spezial[] = "\n"; } echo "\n"; echo "\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo $spezial[0]; echo $spezial[1]; echo " \n"; echo " \n"; echo " \n"; echo $spezial[2]; echo $spezial[3]; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; } echo "

	Zimmer	Wohnfläche	Kaltmiete	Ausstattung

$\"Balkon\"$	$\"Terrasse\"$	$\"Energieausweis\"$	$\"Garten\"$	$\"Garage\"$	$\"Einbauküche\"$

" . $nt['Zimmer'] . "	" . $nt['WohnF'] . " m²	" . number_format ( $nt['Mkalt'], 0, ',', '.' ) . " €
" . $nt['Ort'] . "

\n"; } else { if (isset($_POST['ID'])) { $Zaehler = (int)($_POST['Count']) + 1; $sqlu = "UPDATE objekte SET Count = \"".$Zaehler."\" WHERE ID = \"".$_POST['ID']."\";"; $stmtu = $db->prepare($sqlu); if ($stmtu) { if ($stmtu->execute()) { } } unset($_POST); } include "inhalte/wohn/hmobj.php"; } ?>