Seite 15 - RJG-IT Internet & Webdesign

Direkt zum Seiteninhalt
"; echo 'Änderung am : ' . date_format($date, "d.m.Y - H:i") . ' Uhr
'; ?>

Datenpflegeanwendung Veteins-Software Dieses Mitglied wird gelöscht! Bist Du sicher?

"; echo '

JA '; echo $sp7; echo 'abbrechen

'; $_GET['aktion'] = 'anzeigen'; } } //----Sicherheitsabfrage-------------------------------------------------------------------------------------------------- if (isset($_GET['aktion']) and $_GET['aktion']=='loeschen') { if (isset($_GET['id'])) { $id = (INT) $_GET['id']; if ($id > 0) { $loeschen = $db->prepare("DELETE FROM $management WHERE id=(?) LIMIT 1"); $loeschen->bind_param('i', $id); if ($loeschen->execute()) { echo "

Datensatz wurde gelöscht

"; } } } } //----Ende löschen Sicherheitsabfrage--------------------------------------------------------------------------- //----Anzeigen-------------------------------------------------------------------------------------------------- if (isset($_GET['aktion']) and $_GET['aktion'] == 'anzeigen') { if ( isset($_GET['id'])) { $id_einlesen = (INT) $_GET['id']; if ($id_einlesen > 0) { echo "
Daten anzeigen
"; $dseinlesen = $db->prepare("SELECT id, mgs004, mgs003 FROM $management WHERE id = ? "); $dseinlesen->bind_param('i', $id_einlesen); $dseinlesen->execute(); $dseinlesen->bind_result($id, $mgs004, $mgs003); $dseinlesen->fetch(); ?>

Satz-Nummer:"; ?>
".$id; ?>
Vorname:"; ?>
".$mgs004; ?>
Nachname:"; ?>
".$mgs003; ?>

close(); exit; } } } //----Speichern-------------------------------------------------------------------------------------------------- if (isset($_POST['aktion']) and $_POST['aktion'] == 'speichern') { $mgs000 = ""; if (isset($_POST['mgs000'])) { $mgs000 = $_POST['mgs000']; $mgs000s = $_POST['mgs000']; } $mgs001 = ""; if (isset($_POST['mgs001'])) { $mgs001 = $_POST['mgs001']; $mgs001s = $_POST['mgs001']; } $mgs002 = ""; if (isset($_POST['mgs002'])) { $mgs002 = $_POST['mgs002']; $mgs002s = $_POST['mgs002']; } $mgs0021 = ""; if (isset($_POST['mgs0021'])) { $mgs0021 = $_POST['mgs0021']; $mgs0021s = $_POST['mgs0021']; } $mgs003 = ""; if (isset($_POST['mgs003'])) { $mgs003 = $_POST['mgs003']; $mgs003s = $_POST['mgs003']; } $mgs004 = ""; if (isset($_POST['mgs004'])) { $mgs004 = $_POST['mgs004']; $mgs004s = $_POST['mgs004']; } $mgs005 = ""; if (isset($_POST['mgs005'])) { $mgs005 = $_POST['mgs005']; $mgs005s = $_POST['mgs005']; } $mgs006 = ""; if (isset($_POST['mgs006'])) { $mgs006 = $_POST['mgs006']; $mgs006s = $_POST['mgs006']; } $mgs007 = ""; if (isset($_POST['mgs007'])) { $mgs007 = $_POST['mgs007']; $mgs007s = $_POST['mgs007']; } $mgs008 = ""; if (isset($_POST['mgs008'])) { $mgs008 = $_POST['mgs008']; $mgs008s = $_POST['mgs008']; } $mgs009 = ""; if (isset($_POST['mgs009'])) { $mgs009 = $_POST['mgs009']; $mgs009s = $_POST['mgs009']; } $mgs010 = ""; if (isset($_POST['mgs010'])) { $mgs010 = $_POST['mgs010']; $mgs010s = $_POST['mgs010']; } $mgs011 = ""; if (isset($_POST['mgs011'])) { $mgs011 = $_POST['mgs011']; $mgs011s = $_POST['mgs011']; } $mgs012 = ""; if (isset($_POST['mgs012'])) { $mgs012 = $_POST['mgs012']; $mgs012s = $_POST['mgs012']; } $mgs0131 = ""; if (isset($_POST['mgs0131'])) { $mgs0131 = $_POST['mgs0131']; $mgs0131s = $_POST['mgs0131']; } $mgs0141 = ""; if (isset($_POST['mgs0141'])) { $mgs0141 = $_POST['mgs0141']; $mgs0141s = $_POST['mgs0141']; } $mgs013 = ""; if (isset($_POST['mgs013'])) { $mgs013 = $_POST['mgs013']; $mgs013s = $_POST['mgs013']; } $mgs014 = ""; if (isset($_POST['mgs014'])) { $mgs014 = $_POST['mgs014']; $mgs014s = $_POST['mgs014']; } $mgs015 = ""; if (isset($_POST['mgs015'])) { $mgs015 = $_POST['mgs015']; $mgs015s = $_POST['mgs015']; } $mgs016 = ""; if (isset($_POST['mgs016'])) { $mgs016 = $_POST['mgs016']; $mgs016s = $_POST['mgs016']; } $mgs017 = ""; if (isset($_POST['mgs017'])) { $mgs017 = $_POST['mgs017']; $mgs017s = $_POST['mgs017']; } $mgs018 = ""; if (isset($_POST['mgs018'])) { $mgs018 = $_POST['mgs018']; $mgs018s = $_POST['mgs018']; } $mgs019 = ""; if (isset($_POST['mgs019'])) { $mgs019 = $_POST['mgs019']; $mgs019s = $_POST['mgs019']; } $mgs020 = ""; if (isset($_POST['mgs020'])) { $mgs020 = $_POST['mgs020']; $mgs020s = $_POST['mgs020']; } $mgs021 = ""; if (isset($_POST['mgs021'])) { $mgs021 = $_POST['mgs021']; $mgs021s = $_POST['mgs021']; } $mgs022 = ""; if (isset($_POST['mgs022'])) { $mgs022 = $_POST['mgs022']; $mgs022s = $_POST['mgs022']; } $mgs023 = ""; if (isset($_POST['mgs023'])) { $mgs023 = $_POST['mgs023']; $mgs023s = $_POST['mgs023']; } $mgs024 = ""; if (isset($_POST['mgs024'])) { $mgs024 = $_POST['mgs024']; $mgs024s = $_POST['mgs024']; } $mgs025 = ""; if (isset($_POST['mgs025'])) { $mgs025 = $_POST['mgs025']; $mgs025s = $_POST['mgs025']; } $mgs026 = ""; if (isset($_POST['mgs026'])) { $mgs026 = $_POST['mgs026']; $mgs026s = $_POST['mgs026']; } $mgs027 = ""; if (isset($_POST['mgs027'])) { $mgs027 = $_POST['mgs027']; $mgs027s = $_POST['mgs027']; } $mgs028 = ""; if (isset($_POST['mgs028'])) { $mgs028 = $_POST['mgs028']; $mgs028s = $_POST['mgs028']; } $mgs029 = ""; if (isset($_POST['mgs029'])) { $mgs029 = $_POST['mgs029']; $mgs029s = $_POST['mgs029']; } $mgs030 = ""; if (isset($_POST['mgs030'])) { $mgs030 = $_POST['mgs030']; $mgs030s = $_POST['mgs030']; } $mgs031 = ""; if (isset($_POST['mgs031'])) { $mgs031 = $_POST['mgs031']; $mgs031s = $_POST['mgs031']; } $mgs032 = ""; if (isset($_POST['mgs032'])) { $mgs032 = $_POST['mgs032']; $mgs032s = $_POST['mgs032']; } $mgs100 = ""; if (isset($_POST['mgs100'])) { $mgs100 = $_POST['mgs100']; $mgs100s = $_POST['mgs100']; } $mgs110 = ""; if (isset($_POST['mgs110'])) { $mgs110 = $_POST['mgs110']; $mgs110s = $_POST['mgs110']; } //----Fehler korrektur------------------------------------------------------------------------------------------------- $err01 = ""; $err02 = ""; $err03 = ""; $err04 = ""; $err05 = ""; $err06 = ""; $err07 = ""; $err08 = ""; $err09 = ""; $err10 = ""; $err11 = ""; if ( $upd_mgs004 == "") {$err01 = "Eingabe Vorname fehlt";}else{$err01 = "";} if ( $upd_mgs003 == "") {$err02 = "Eingabe Nachname fehlt";}else{$err02 = "";} if ( $upd_mgs0131 == "") {$err05 = "Eingabe Email Adresse fehlt";}else{$err05 = "";} $switch = "1"; if ( $mgs004 != "" AND $mgs003 != "" AND $mgs0131 != "") { if ($err01 == '' AND $err02 == '' AND $err05 == '') { $einfuegen = $db->prepare(" INSERT INTO $management (mgs000, mgs001, mgs002, mgs0021, mgs003, mgs004, mgs005, mgs006, mgs007, mgs008, mgs009, mgs010, mgs011, mgs012, mgs0131, mgs0141, mgs013,mgs014, mgs015, mgs016, mgs017, mgs018, mgs019, mgs020, mgs021, mgs022, mgs023, mgs024, mgs025, mgs026, mgs027, mgs028, mgs029, mgs030, mgs031, mgs032, mgs100, mgs110) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, NOW())"); $einfuegen->bind_param('ssssssssssssssssssssssssssssssssssssss', $mgs000, $mgs001, $mgs002, $mgs0021, $mgs003, $mgs004, $mgs005, $mgs006, $mgs007, $mgs008, $mgs009, $mgs010, $mgs011, $mgs012 ,$mgs0131, $mgs0141, $mgs013, $mgs014, $mgs015, $mgs016, $mgs017, $mgs018, $mgs019, $mgs020, $mgs021, $mgs022, $mgs023, $mgs024, $mgs025, $mgs026, $mgs027, $mgs028, $mgs029, $mgs030, $mgs031, $mgs032, $mgs100, $mgs110); if ($einfuegen->execute()) { $switch = "0"; $mgs000 = ""; $mgs001 = ""; $mgs002 = ""; $mgs0021 = ""; $mgs003 = ""; $mgs004 = ""; $mgs005 = ""; $mgs006 = ""; $mgs007 = ""; $mgs008 = ""; $mgs009 = ""; $mgs010 = ""; $mgs011 = ""; $mgs012 = ""; $mgs0131 = ""; $mgs0141 = ""; $mgs013 = ""; $mgs014 = ""; $mgs015 = ""; $mgs016 = ""; $mgs017 = ""; $mgs018 = ""; $mgs019 = ""; $mgs020 = ""; $mgs021 = ""; $mgs022 = ""; $mgs023 = ""; $mgs024 = ""; $mgs025 = ""; $mgs026 = ""; $mgs027 = ""; $mgs028 = ""; $mgs029 = ""; $mgs030 = ""; $mgs031 = ""; $mgs032 = ""; $mgs100 = ""; $mgs110 = ""; } } } } if ($switch == "3" ) { $mgs000 = ""; $mgs001 = ""; $mgs002 = ""; $mgs0021 = ""; $mgs003 = ""; $mgs004 = ""; $mgs005 = ""; $mgs006 = ""; $mgs007 = ""; $mgs008 = ""; $mgs009 = ""; $mgs010 = ""; $mgs011 = ""; $mgs012 = ""; $mgs0131 = ""; $mgs0141 = ""; $mgs013 = ""; $mgs014 = ""; $mgs015 = ""; $mgs016 = ""; $mgs017 = ""; $mgs018 = ""; $mgs019 = ""; $mgs020 = ""; $mgs021 = ""; $mgs022 = ""; $mgs023 = ""; $mgs024 = ""; $mgs025 = ""; $mgs026 = ""; $mgs027 = ""; $mgs028 = ""; $mgs029 = ""; $mgs030 = ""; $mgs031 = ""; $mgs032 = ""; $mgs100 = ""; $mgs110 = ""; } if ($switch == "2") { $mgs000 = $mgs000s; $mgs001 = $mgs001s; $mgs002 = $mgs002s; $mgs0021 = $mgs0021s; $mgs003 = $mgs003s; $mgs004 = $mgs004s; $mgs005 = $mgs005s; $mgs006 = $mgs006s; $mgs007 = $mgs007s; $mgs008 = $mgs008s; $mgs009 = $mgs009s; $mgs010 = $mgs010s; $mgs011 = $mgs011s; $mgs012 = $mgs012s; $mgs0131 = $mgs0131s; $mgs0141 = $mgs0141s; $mgs013 = $mgs013s; $mgs014 = $mgs014s; $mgs015 = $mgs015s; $mgs016 = $mgs016s; $mgs017 = $mgs017s; $mgs018 = $mgs018s; $mgs019 = $mgs019s; $mgs020 = $mgs020s; $mgs021 = $mgs021s; $mgs022 = $mgs022s; $mgs023 = $mgs023s; $mgs024 = $mgs024s; $mgs025 = $mgs025s; $mgs026 = $mgs026s; $mgs027 = $mgs027s; $mgs028 = $mgs028s; $mgs029 = $mgs029s; $mgs030 = $mgs030s; $mgs031 = $mgs031s; $mgs032 = $mgs032s; $mgs100 = $mgs100s; $mgs110 = $mgs110s; } //----Feedback-------------------------------------------------------------------------------------------------- if (isset($_GET['aktion']) and $_GET['aktion'] == 'feedbackgespeichert') { echo '

Datensatz wurde gespeichert

'; } $modus_aendern = false; if (isset($_GET['aktion']) and $_GET['aktion'] == 'bearbeiten') { $modus_aendern = true; } //----Korrigieren-------------------------------------------------------------------------------------------------- if (isset($_POST['aktion']) and $_POST['aktion'] == 'korrigieren' ) { $upd = "0"; $upd_id = ""; if (isset($_POST['id'])) { $upd_id = (INT) $_POST['id']; } $upd_mgs000 = ""; if (isset($_POST['mgs000'])) { $upd_mgs000 = $_POST['mgs000']; $upd_mgs000s = $_POST['mgs000']; } $upd_mgs001 = ""; if (isset($_POST['mgs001'])) { $upd_mgs001 = $_POST['mgs001']; $upd_mgs001s = $_POST['mgs001']; } $upd_mgs002 = ""; if (isset($_POST['mgs002'])) { $upd_mgs002 = $_POST['mgs002']; $upd_mgs002s = $_POST['mgs002']; } $upd_mgs0021 = ""; if (isset($_POST['mgs0021'])) { $upd_mgs0021 = $_POST['mgs0021']; $upd_mgs0021s = $_POST['mgs0021']; } $upd_mgs003 = ""; if (isset($_POST['mgs003'])) { $upd_mgs003 = $_POST['mgs003']; $upd_mgs003s = $_POST['mgs003']; } $upd_mgs004 = ""; if (isset($_POST['mgs004'])) { $upd_mgs004 = $_POST['mgs004']; $upd_mgs004s = $_POST['mgs004']; } $upd_mgs005 = ""; if (isset($_POST['mgs005'])) { $upd_mgs005 = $_POST['mgs005']; $upd_mgs005s = $_POST['mgs005']; } $upd_mgs006 = ""; if (isset($_POST['mgs006'])) { $upd_mgs006 = $_POST['mgs006']; $upd_mgs006s = $_POST['mgs006']; } $upd_mgs007 = ""; if (isset($_POST['mgs007'])) { $upd_mgs007 = $_POST['mgs007']; $upd_mgs007s = $_POST['mgs007']; } $upd_mgs008 = ""; if (isset($_POST['mgs008'])) { $upd_mgs008 = $_POST['mgs008']; $upd_mgs008s = $_POST['mgs008']; } $upd_mgs009 = ""; if (isset($_POST['mgs009'])) { $upd_mgs009 = $_POST['mgs009']; $upd_mgs009s = $_POST['mgs009']; } $upd_mgs010 = ""; if (isset($_POST['mgs010'])) { $upd_mgs010 = $_POST['mgs010']; $upd_mgs010s = $_POST['mgs010']; } $upd_mgs011 = ""; if (isset($_POST['mgs011'])) { $upd_mgs011 = $_POST['mgs011']; $upd_mgs011s = $_POST['mgs011']; } $upd_mgs012 = ""; if (isset($_POST['mgs012'])) { $upd_mgs012 = $_POST['mgs012']; $upd_mgs012s = $_POST['mgs012']; } $upd_mgs0131 = ""; if (isset($_POST['mgs0131'])) { $upd_mgs013 = $_POST['mgs0131']; $upd_mgs013s = $_POST['mgs0131']; } $upd_mgs0141 = ""; if (isset($_POST['mgs0141'])) { $upd_mgs0141 = $_POST['mgs0141']; $upd_mgs0141s = $_POST['mgs0141']; } $upd_mgs013 = ""; if (isset($_POST['mgs013'])) { $upd_mgs013 = $_POST['mgs013']; $upd_mgs013s = $_POST['mgs013']; } $upd_mgs014 = ""; if (isset($_POST['mgs014'])) { $upd_mgs014 = $_POST['mgs014']; $upd_mgs014s = $_POST['mgs014']; } $upd_mgs015 = ""; if (isset($_POST['mgs015'])) { $upd_mgs015 = $_POST['mgs015']; $upd_mgs015s = $_POST['mgs015']; } $upd_mgs016 = ""; if (isset($_POST['mgs016'])) { $upd_mgs016 = $_POST['mgs016']; $upd_mgs016s = $_POST['mgs016']; } $upd_mgs017 = ""; if (isset($_POST['mgs017'])) { $upd_mgs017 = $_POST['mgs017']; $upd_mgs017s = $_POST['mgs017']; } $upd_mgs018 = ""; if (isset($_POST['mgs018'])) { $upd_mgs018 = $_POST['mgs018']; $upd_mgs018s = $_POST['mgs018']; } $upd_mgs019 = ""; if (isset($_POST['mgs019'])) { $upd_mgs019 = $_POST['mgs019']; $upd_mgs019s = $_POST['mgs019']; } $upd_mgs020 = ""; if (isset($_POST['mgs020'])) { $upd_mgs020 = $_POST['mgs020']; $upd_mgs020s = $_POST['mgs020']; } $upd_mgs021 = ""; if (isset($_POST['mgs021'])) { $upd_mgs021 = $_POST['mgs021']; $upd_mgs021s = $_POST['mgs021']; } $upd_mgs022 = ""; if (isset($_POST['mgs022'])) { $upd_mgs022 = $_POST['mgs022']; $upd_mgs022s = $_POST['mgs022']; } $upd_mgs023 = ""; if (isset($_POST['mgs023'])) { $upd_mgs023 = $_POST['mgs023']; $upd_mgs023s = $_POST['mgs023']; } $upd_mgs024 = ""; if (isset($_POST['mgs024'])) { $upd_mgs024 = $_POST['mgs024']; $upd_mgs024s = $_POST['mgs024']; } $upd_mgs025 = ""; if (isset($_POST['mgs025'])) { $upd_mgs025 = $_POST['mgs025']; $upd_mgs025s = $_POST['mgs025']; } $upd_mgs026 = ""; if (isset($_POST['mgs026'])) { $upd_mgs026 = $_POST['mgs026']; $upd_mgs026s = $_POST['mgs026']; } $upd_mgs027 = ""; if (isset($_POST['mgs027'])) { $upd_mgs027 = $_POST['mgs027']; $upd_mgs027s = $_POST['mgs027']; } $upd_mgs028 = ""; if (isset($_POST['mgs028'])) { $upd_mgs028 = $_POST['mgs028']; $upd_mgs028s = $_POST['mgs028']; } $upd_mgs029 = ""; if (isset($_POST['mgs029'])) { $upd_mgs029 = $_POST['mgs029']; $upd_mgs029s = $_POST['mgs029']; } $upd_mgs030 = ""; if (isset($_POST['mgs030'])) { $upd_mgs030 = $_POST['mgs030']; $upd_mgs030s = $_POST['mgs030']; } $upd_mgs031 = ""; if (isset($_POST['mgs031'])) { $upd_mgs031 = $_POST['mgs031']; $upd_mgs031s = $_POST['mgs031']; } $upd_mgs032 = ""; if (isset($_POST['mgs032'])) { $upd_mgs032 = $_POST['mgs032']; $upd_mgs032s = $_POST['mgs032']; } $upd_mgs100 = ""; if (isset($_POST['mgs100'])) { $upd_mgs100 = $_POST['mgs100']; $upd_mgs100s = $_POST['mgs100']; } $upd_mgs110 = ""; if (isset($_POST['mgs110'])) { $upd_mgs110 = $_POST['mgs110']; $upd_mgs110s = $_POST['mgs110']; } //----Fehler korrektur-------------------------------------------------------------------------------------------------- $err01 = ""; $err02 = ""; $err03 = ""; $err04 = ""; $err05 = ""; $err06 = ""; $err07 = ""; $err08 = ""; $err09 = ""; $err10 = ""; $err11 = ""; if ( $upd_mgs004 == "") {$err01 = "Eingabe Vorname fehlt";}else{$err01 = "";} if ( $upd_mgs003 == "") {$err02 = "Eingabe Nachname fehlt";}else{$err02 = "";} if ( $upd_mgs0131 == "") {$err05 = "Eingabe Email Adresse fehlt";}else{$err05 = "";} $switch = "1"; //--------------------------------------------------------------------------------------------------------------------- if ( $upd_id != '' AND ( $upd_mgs004 != "" OR $upd_mgs003 != "" OR $upd_mgs0131 != "" )) { if ( $err01 == "" AND $err02 == "" AND $err05 == "" ) { $update = $db->prepare("UPDATE $management SET mgs000 =?, mgs001 =?, mgs002 =?, mgs0021=?, mgs003 =?, mgs004 =?, mgs005 =?, mgs006 =?, mgs007 =?, mgs008 =?, mgs009 =?, mgs010 =?, mgs011 =?, mgs012 =?, mgs0131=?, mgs0141=?, mgs013 =?, mgs014 =?, mgs015 =?, mgs016 =?, mgs017 =?, mgs018 =?, mgs019 =?, mgs020 =?, mgs021 =?, mgs022 =?, mgs023 =?, mgs024 =?, mgs025 =?, mgs026 =?, mgs027 =?, mgs028 =?, mgs029 =?, mgs030 =?, mgs031=?, mgs032 =?, mgs100 =?, mgs110 =? WHERE id=? LIMIT 1"); $update->bind_param('ssssssssssssssssssssssssssssssssssssssi', $upd_mgs000, $upd_mgs001, $upd_mgs002, $upd_mgs0021, $upd_mgs003, $upd_mgs004, $upd_mgs005, $upd_mgs006, $upd_mgs007, $upd_mgs008, $upd_mgs009, $upd_mgs010, $upd_mgs011, $upd_mgs012, $upd_mgs0131, $upd_mgs0141, $upd_mgs013, $upd_mgs014, $upd_mgs015, $upd_mgs016, $upd_mgs017, $upd_mgs018, $upd_mgs019, $upd_mgs020, $upd_mgs021, $upd_mgs022, $upd_mgs023, $upd_mgs024, $upd_mgs025, $upd_mgs026, $upd_mgs027, $upd_mgs028, $upd_mgs029, $upd_mgs030, $upd_mgs031, $upd_mgs032, $upd_mgs100, $upd_mgs110, $upd_id); if ( $update->execute() ) { echo '

Datensatz wurde geändert

'; $modus_aendern = false; $switch = "0"; $mgs000 = ""; $mgs001 = ""; $mgs002 = ""; $mgs0021 = ""; $mgs003 = ""; $mgs004 = ""; $mgs005 = ""; $mgs006 = ""; $mgs007 = ""; $mgs008 = ""; $mgs009 = ""; $mgs010 = ""; $mgs011 = ""; $mgs012 = ""; $mgs0131 = ""; $mgs0141 = ""; $mgs013 = ""; $mgs014 = ""; $mgs015 = ""; $mgs016 = ""; $mgs017 = ""; $mgs018 = ""; $mgs019 = ""; $mgs020 = ""; $mgs021 = ""; $mgs022 = ""; $mgs023 = ""; $mgs024 = ""; $mgs025 = ""; $mgs026 = ""; $mgs027 = ""; $mgs028 = ""; $mgs029 = ""; $mgs030 = ""; $mgs031 = ""; $mgs032 = ""; $mgs100 = ""; $mgs110 = ""; } } } } //----Suchbegriff-------------------------------------------------------------------------------------------------- ?>

Suchen nach:

Gesucht wird nach: $suchbegriff

"; $suche_nach = "%{$suchbegriff}%"; $suche = $db->prepare("SELECT id, mgs004, mgs003 FROM $management WHERE mgs003 LIKE ? OR mgs004 LIKE ?"); $suche->bind_param('ss', $suche_nach, $suche_nach); $suche->execute(); $suche->bind_result($id, $mgs004, $mgs003); while ($suche->fetch()) { $daten[] = (object) array('id' => $id, 'mgs004' => $mgs004, 'mgs003' => $mgs003); } $suche->close(); $id = ""; $mgs003 = ""; $mgs004 = ""; } else { if ($erg = $db->query("SELECT * FROM $management")) { if ($erg->num_rows) { while ($datensatz = $erg->fetch_object()) { $daten[] = $datensatz; } $erg->free(); } } } if (!count($daten)) { echo "

keine Daten gefunden

"; } else { ?>

Aktionen

ID

Vorname

Nachname

DSP MUT DEL ".$inhalt->id; ?> ".$inhalt->mgs004; ?> ".$inhalt->mgs003; ?>
Daten ändern"; if ( isset($_GET['id'])) { $id_einlesen = (INT) $_GET['id']; if ($id_einlesen > 0) { $dseinlesen = $db->prepare("SELECT id, mgs000, mgs001, mgs002, mgs0021, mgs003, mgs004, mgs005, mgs006, mgs007, mgs008, mgs009, mgs010, mgs011, mgs012, mgs0131, mgs0141, mgs013, mgs014, mgs015, mgs016, mgs017, mgs018, mgs019, mgs020, mgs021, mgs022, mgs023, mgs024, mgs025, mgs026, mgs027, mgs028, mgs029, mgs030, mgs031, mgs032, mgs100, mgs110 FROM $management WHERE id = ? "); $dseinlesen->bind_param('i', $id_einlesen); $dseinlesen->execute(); $dseinlesen->bind_result($id, $mgs000, $mgs001, $mgs002, $mgs0021, $mgs003, $mgs004, $mgs005, $mgs006, $mgs007, $mgs008, $mgs009, $mgs010, $mgs011, $mgs012, $mgs0131, $mgs0141, $mgs013, $mgs014, $mgs015, $mgs016, $mgs017, $mgs018, $mgs019, $mgs020, $mgs021, $mgs022, $mgs023, $mgs024, $mgs025, $mgs026, $mgs027, $mgs028, $mgs029, $mgs030, $mgs031, $mgs032, $mgs100, $mgs110); while ($dseinlesen->fetch()) { echo $mgs004." ".$mgs003; } } } } if ($switch == "1") { $mgs000 = $upd_mgs000s; $mgs001 = $upd_mgs001s; $mgs002 = $upd_mgs002s; $mgs0021 = $upd_mgs0021s; $mgs003 = $upd_mgs003s; $mgs004 = $upd_mgs004s; $mgs005 = $upd_mgs005s; $mgs006 = $upd_mgs006s; $mgs007 = $upd_mgs007s; $mgs008 = $upd_mgs008s; $mgs009 = $upd_mgs009s; $mgs010 = $upd_mgs010s; $mgs011 = $upd_mgs011s; $mgs012 = $upd_mgs012s; $mgs0131 = $upd_mgs0131s; $mgs0141 = $upd_mgs0141s; $mgs013 = $upd_mgs013s; $mgs014 = $upd_mgs014s; $mgs015 = $upd_mgs015s; $mgs016 = $upd_mgs016s; $mgs017 = $upd_mgs017s; $mgs018 = $upd_mgs018s; $mgs019 = $upd_mgs019s; $mgs020 = $upd_mgs020s; $mgs021 = $upd_mgs021s; $mgs022 = $upd_mgs022s; $mgs023 = $upd_mgs023s; $mgs024 = $upd_mgs024s; $mgs025 = $upd_mgs025s; $mgs026 = $upd_mgs026s; $mgs027 = $upd_mgs027s; $mgs028 = $upd_mgs028s; $mgs029 = $upd_mgs029s; $mgs030 = $upd_mgs030s; $mgs031 = $upd_mgs031s; $mgs032 = $upd_mgs032s; $mgs100 = $upd_mgs100s; $mgs110 = $upd_mgs110s; } if ( ! isset($mgs000) ) { $mgs000 = ''; } if ( ! isset($mgs001) ) { $mgs001 = ''; } if ( ! isset($mgs002) ) { $mgs002 = ''; } if ( ! isset($mgs0021)) { $mgs0021= ''; } if ( ! isset($mgs003) ) { $mgs003 = ''; } if ( ! isset($mgs004) ) { $mgs004 = ''; } if ( ! isset($mgs005) ) { $mgs005 = ''; } if ( ! isset($mgs006) ) { $mgs006 = ''; } if ( ! isset($mgs007) ) { $mgs007 = ''; } if ( ! isset($mgs008) ) { $mgs008 = ''; } if ( ! isset($mgs009) ) { $mgs009 = ''; } if ( ! isset($mgs010) ) { $mgs010 = ''; } if ( ! isset($mgs011) ) { $mgs011 = ''; } if ( ! isset($mgs012) ) { $mgs012 = ''; } if ( ! isset($mgs0131)) { $mgs0131= ''; } if ( ! isset($mgs0141)) { $mgs0141= ''; } if ( ! isset($mgs013) ) { $mgs013 = ''; } if ( ! isset($mgs014) ) { $mgs014 = ''; } if ( ! isset($mgs015) ) { $mgs015 = ''; } if ( ! isset($mgs016) ) { $mgs016 = ''; } if ( ! isset($mgs017) ) { $mgs017 = ''; } if ( ! isset($mgs018) ) { $mgs018 = ''; } if ( ! isset($mgs019) ) { $mgs019 = ''; } if ( ! isset($mgs020) ) { $mgs020 = ''; } if ( ! isset($mgs021) ) { $mgs021 = ''; } if ( ! isset($mgs022) ) { $mgs022 = ''; } if ( ! isset($mgs023) ) { $mgs023 = ''; } if ( ! isset($mgs024) ) { $mgs024 = ''; } if ( ! isset($mgs025) ) { $mgs025 = ''; } if ( ! isset($mgs026) ) { $mgs026 = ''; } if ( ! isset($mgs027) ) { $mgs027 = ''; } if ( ! isset($mgs028) ) { $mgs028 = ''; } if ( ! isset($mgs029) ) { $mgs029 = ''; } if ( ! isset($mgs030) ) { $mgs030 = ''; } if ( ! isset($mgs031) ) { $mgs031 = ''; } if ( ! isset($mgs032) ) { $mgs032 = ''; } if ( ! isset($mgs100) ) { $mgs100 = ''; } if ( ! isset($mgs110) ) { $mgs110 = ''; } if ($nonput != true) { ?>



".$t1_res; ?> "; ?>
".$t2_res; ?>
".$t3_res; ?> ";?>
".$t3_res; ?> ";?>
".$t4_res; ?> ";?>
".$t5_res; ?> ";?>
".$t6_res; ?> ";?>

'; echo ''; echo '

'; } else { } echo ''; echo ''; echo ''; echo ''; } ?>

ⓒ 2008- RJG-IT Internet & Webdesign

© 2008 - René Gubler - alle Rechte vorbehalten

Post-Adresse
R. Gubler
Ohringerstrasse 152
8472 Seuzach

Post-Adresse
R. Gubler
Ohringerstrasse 152
8472 Seuzach

Zurück zum Seiteninhalt