prepare($sql); if (!$stmt) { die ('Datensatz konnte nicht angelegt werden: '.$db->error); } if (!$stmt->execute()) { die ('Datensatz konnte nicht angelegt werden: '.$stmt->error); } $sql = 'SELECT last_insert_id() AS last'; $result = $db->query($sql); $nt = $result->fetch_assoc(); $id = $nt['last']; echo "

neuen Interessenten anlegen

\n"; } else { echo "

Interessenten bearbeiten

\n"; $id = $_POST['ID']; } $sql1 = "SELECT * FROM inter WHERE ID = \"".$id."\" "; $result1 = $db->query($sql1); $nt1 = $result1->fetch_assoc(); $sql2 = "SELECT Anrede FROM Anreden ORDER BY Anrede ASC"; $result2 = $db->query($sql2); $sql3 = "SELECT O_TYP FROM O_Typen ORDER BY O_TYP ASC"; $result3 = $db->query($sql3); $sql4 = "SELECT V_TYP FROM V_Typen ORDER BY V_TYP ASC"; $result4 = $db->query($sql4); $sql5 = "SELECT Lage FROM lagen ORDER BY Lage ASC"; $result5 = $db->query($sql5); $sql6 = "SELECT ID, Vorname, Nachname FROM Team ORDER BY ID ASC"; $result6 = $db->query($sql6); echo "
\n"; echo "

\n"; if (in_array("Makler_Interessenten", $_SESSION['Rechte'])) { echo " Teammitglied zuordnen\n"; echo " \n"; echo "
\n"; echo "
\n"; } else { echo " \n"; } echo "

\n"; echo " Kontaktdaten:\n"; echo " \n"; echo " Aktiv\n"; echo " ja\n"; echo " nein\n"; echo "
\n"; echo " Anrede\n"; echo " \n"; echo "
\n"; echo " Vorname\n"; echo " \n"; echo "
\n"; echo " Nachname\n"; echo " \n"; echo "
\n"; echo " Adresse\n"; echo " \n"; echo "
\n"; echo " PLZ\n"; echo " \n"; echo "
\n"; echo " Ort\n"; echo " \n"; echo "
\n"; echo " Telefon\n"; echo " \n"; echo "
\n"; echo " Fax\n"; echo " \n"; echo "
\n"; echo " Mobil\n"; echo " \n"; echo "
\n"; echo " Firma\n"; echo " \n"; echo "
\n"; echo " Email\n"; echo " \n"; echo "
\n"; echo " Email-Benachrichtigung\n"; echo " ja\n"; echo " nein\n"; echo "

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

\n"; echo " Persönliche Daten:\n"; echo " Alter\n"; echo " \n"; echo "
\n"; echo " Familienstand\n"; echo " \n"; echo "
\n"; echo " Kinder\n"; echo " \n"; echo "
\n"; echo " Alter der Kinder\n"; echo " \n"; echo "
\n"; echo " Beruf\n"; echo " \n"; echo "
\n"; echo " Arbeitgeber\n"; echo " \n"; echo "
\n"; echo " Staatsangehörigkeit\n"; echo " \n"; echo "
\n"; echo " Raucher\n"; echo " ja\n"; echo " nein\n"; echo "
\n"; echo " Haustiere\n"; echo " ja\n"; echo " nein\n"; echo "

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

\n"; echo " Angaben zum gesuchten Objekt\n"; echo " Objekttyp\n"; echo " \n"; echo "
\n"; echo " Vermarktungsart\n"; echo " \n"; echo "
\n"; echo " Ort\n"; echo " \n"; echo "
\n"; echo " Lage\n"; echo " \n"; echo "
\n"; echo " Bezug zum\n"; echo " \n"; echo "
\n"; echo " Zimmer\n"; echo " \n"; echo " - \n"; echo "
\n"; echo " Wohn-/ Nutzfläche\n"; echo " \n"; echo "
\n"; echo " Kaltmiete\n"; echo " \n"; echo "
\n"; echo " Warmmiete\n"; echo " \n"; echo "
\n"; echo " Kaufpreis\n"; echo " \n"; echo "

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

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

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

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

\n"; echo "
\n"; echo "
\n"; echo " \n"; if ("Anlegen" == $_POST['action']) { echo " \n"; } else { echo " \n"; } echo "

\n"; } ?>