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--------------------------------------------------------------------------------------------------
?>
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)
{
?>
';
}
else
{
}
echo '
';
echo '
';
echo '
';
echo '';
}
?>
ⓒ 2008- RJG-IT Internet & Webdesign