query("SELECT 1 FROM sozkom_admin_rechte, sozkom_admin_rechte_zuord , sozkom_admin where sozkom_admin_rechte.sozkom_admin_rolle = sozkom_admin_rechte_zuord.sozkom_admin_rolle AND sozkom_admin_rechte_zuord.faid = sozkom_admin.faid AND sozkom_admin.user = '$user_admin' AND sozkom_admin_rechte_zuord.sozkom_admin_rolle = 'a_dozbearb'"); $row = $result->fetch_array(); if ($row[0] != 1){ include("kurs/rechte.php"); exit;} // Rechteüberprüfung ende if (isset($_GET['action'])) $action = $_GET['action']; else $action = ""; switch($action){ default: echo " Dozent bearbeiten

Dozent bearbeiten
 

 

"; $db = dbconnect(); $query = "SELECT doz_nr, doz_titel, doz_name, doz_vorname from doz order by doz_name"; $result = $db->query ($query) or die ("Cannot execute query"); echo ""; echo "

 

"; break; case "dozbearb": setcookie("ck_dozbe",$_POST[dozbe]); $db = dbconnect(); $bearb_doz = $db->query ("Select doz_uid, doz_name, doz_vorname, doz_titel, doz_mail, doz_strasse, doz_plz, doz_ort, doz_tel, doz_pwd FROM doz WHERE doz_nr=\"". $_POST['dozbe']."\""); $doz = $bearb_doz->fetch_array(); echo " Dozent bearbeiten

Dozent bearbeiten
Titel:
Vorname:
Nachname:
Straße:
PLZ:
Ort:
Tel.:
Benutzerkennung:
E-Mail Adresse:
Kennwort neu setzen:


"; break; case "dozbearb1": $db = dbconnect(); $ck_dozbe = $_COOKIE["ck_dozbe"]; if ($_POST['doz_pwd'] != '') { $passwd = md5($_POST['doz_pwd']); }else{ $bearb_doz = $db->query ("SELECT doz_pwd FROM doz WHERE doz_nr=\"$ck_dozbe\""); $doz = $bearb_doz->fetch_array(); $passwd = $doz['doz_pwd']; } $sql = $db->query ("UPDATE doz SET doz_uid=\"". $_POST['doz_uid']."\" , doz_name=\"". $_POST['doz_name']."\" , doz_vorname=\"". $_POST['doz_vorname']."\" , doz_titel=\"". $_POST['doz_titel']."\" , doz_mail=\"". $_POST['doz_mail']."\" , doz_strasse=\"". $_POST['doz_strasse']."\" , doz_plz=\"". $_POST['doz_plz']."\" , doz_ort=\"". $_POST['doz_ort']."\" , doz_tel=\"". $_POST['doz_tel']."\" , doz_pwd=\"$passwd\" WHERE doz_nr=\"$ck_dozbe\""); echo " Bearbeiten erfolgreich

Bearbeiten erfolgreich

Die Änderungen wurden erfolgreich vorgenommen



"; //session_destroy(); } // Ende Action script ?>