= ".$_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"; } } echo "

Wohnungen zur Miete und zum Kauf

\n"; $sql = 'SELECT ID, Count, V_TYP, Kurz, Zimmer, WohnF, Ort, Mkalt, Garage, StellPl, Terrasse, Balkon, Garten FROM objekte WHERE '.$filter.' ORDER BY ID ASC'; $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 "

Suchkriterien	$anzahl Wohnungen im Angebot	$anzahl Wohnung im Angebot
Zimmer:		bis		mit folgenden Kriterien:
Wohnfläche:		bis	m²	$zimmer
	$wohn

\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()) { if ('Kauf' == $nt['V_TYP']) { $form = "\n"; } else { $form = "\n"; } echo $form; echo "\n"; echo "\n"; echo " \n"; echo " \n"; echo " \n"; if ('1' == $nt[Balkon]) { echo " \n"; } else { echo "\n"; } if ('1' == $nt[Terrasse]) { echo " \n"; } else { echo "\n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo " \n"; if ('1' == $nt[Garten]) { echo " \n"; } else { echo "\n"; } if ('1' == $nt[Garage]) { echo " \n"; } else { echo "\n"; } echo " \n"; echo " \n"; echo " \n"; if ('Kauf' == $nt[V_TYP]) { echo " \n"; } else { echo " \n"; } if ('1' == $nt[StellPl]) { echo " \n"; } else { echo "\n"; } echo " \n"; echo " \n"; echo " \n"; echo " \n"; echo "\n"; } echo "

	Zimmer	Wohnfläche	Kaltmiete / Kaufpreis	Ausstattung

		$\"Balkon\"$		$\"Terrasse\"$
$nt[Zimmer]	$nt[WohnF] m²	$nt[Mkalt] €	$\"Garten\"$		$\"Garage\"$
$nt[Ort]	Kauf	Miete	$\"Balkon\"$

\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/wmobj.php"; } ?>