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']; $sql = 'UPDATE Team SET AnzeigeNr = "'.$id.'" WHERE ID = "'.$id.'";'; $stmt = $db->prepare($sql); if (!$stmt) { die ('Datensatz konnte nicht gespeichert werden: '.$db->error); } if (!$stmt->execute()) { die ('Datensatz konnte nicht gespeichert werden: '.$stmt->error); } } else { $id = $_POST['ID']; } $uploaddir = "../img/team/"; $filename = "../img/team/".$id.".jpg"; $newwidth = 200; include "inhalte/einfoto.php"; $sql1 = "SELECT * FROM Team WHERE ID = \"".$id."\" "; $result1 = $db->query($sql1); $nt1 = $result1->fetch_assoc(); echo "
\n"; echo "

\n"; echo "

\n"; echo "

Teammitglied ".$nt1['Vorname']." ".$nt1['Nachname'].":

\n"; echo " \n"; echo " Sichtbar\n"; echo " ja\n"; echo " nein\n"; echo "\n"; echo "
\n"; echo " Titel\n"; echo " \n"; echo " \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 " Position\n"; echo " \n"; echo " \n"; echo "
\n"; echo " Telefon\n"; echo " \n"; echo "
\n"; echo " Email\n"; echo " \n"; echo "
\n"; echo " Bereich\n"; echo " \n"; echo "
\n"; echo "  
\n"; echo " \n"; if ("Anlegen" == $_POST['action']) { echo " \n"; } else { echo " \n"; } echo "

\n"; echo "

\n"; } ?>