testseite - TCS Camping Club Schaffhausen

"; $aussehen = "

"; $titel = "

"; $erg = $db->query('SELECT * FROM event_parameter ORDER BY etp006') or die( $db->error); while ($zeile = $erg->fetch_object()) { if ( $f1event == $zeile->etp006) { $upd_id = $zeile->id; $evdat_event = $zeile->etp001; //Eventdatum von (ab wann ein Event brginnt) $verpf_event = $zeile->etp002; $telor_event = $zeile->etp003; $email_organisator = $zeile->etp004; $ansch_parameter = $zeile->etp005; // Anmeldeschluss (bis wann kann eine Reservation getätigt werden) $event_organisator = $zeile->etp006; $evend_parameter = $zeile->etp007; // Eventdatum bis (Datum bis wann ein Event dauert) $bilde_parameter = $zeile->etp008; $obulu_parameter = $zeile->etp009; $start_parameter = $zeile->etp010; // Startdatum (ab wann kann eine Reservation gemacht werden) $statu_parameter = $zeile->etp011; $vorna_organisator = $zeile->etp012; $email_verwalter = $zeile->etp013; $evtt = substr($zeile->etp001,0,2); $evmm = substr($zeile->etp001,2,2); $evjj = substr($zeile->etp001,4,4); $eventvon = $evtt.'.'.$evmm.'.'.$evjj; $ebtt = substr($zeile->etp007,0,2); $ebmm = substr($zeile->etp007,2,2); $ebjj = substr($zeile->etp007,4,4); $eventbis = $ebtt.'.'.$ebmm.'.'.$ebjj; $kopfvon = $eventvon; $kopfbis = $eventbis; break; } } // ----------------------------------------------------------------------------------------------------------------------- // Daten aus DB-Anmeldungen in Array einlesen // ----------------------------------------------------------------------------------------------------------------------- $daten = array(); $_GET['suchen'] = $f1event; if ( $_GET['suchen'] != '' ) { $suchen = $_GET['suchen']; $suche_nach = "%{$suchen}%"; $suche = $db->prepare("SELECT id, ttf001, ttf003, ttf004, ttf005, ttf006, ttf007, ttf008, ttf009, ttf010, ttf011, ttf111, ttf211, ttf311, ttf411, ttf012, ttf112, ttf212, ttf312, ttf412, ttf013, ttf014, ttf028, ttf015, ttf016, ttf017, ttf018, ttf019, ttf020, ttf024, ttf025 FROM treff2_anmeldungen WHERE ttf001 LIKE ? ORDER BY ttf003"); $suche->bind_param('s', $suche_nach); $suche->execute(); $suche->bind_result($id, $ttf001, $ttf003, $ttf004, $ttf005, $ttf006, $ttf007, $ttf008, $ttf009, $ttf010, $ttf011, $ttf111, $ttf211, $ttf311, $ttf411, $ttf012, $ttf112, $ttf212, $ttf312, $ttf412, $ttf013, $ttf014, $ttf028, $ttf015, $ttf016, $ttf017, $ttf018, $ttf019, $ttf020, $ttf024, $ttf025); while ($suche->fetch()) { $daten[] = (object) array('id' => $id, 'ttf001' => $ttf001, 'ttf003' => $ttf003, 'ttf004' => $ttf004, 'ttf005' => $ttf005, 'ttf006' => $ttf006, 'ttf007' => $ttf007, 'ttf008' => $ttf008, 'ttf009' => $ttf009, 'ttf010' => $ttf010, 'ttf011' => $ttf011, 'ttf111' => $ttf111, 'ttf211' => $ttf211, 'ttf311' => $ttf311, 'ttf411' => $ttf411, 'ttf012' => $ttf012, 'ttf112' => $ttf112, 'ttf212' => $ttf212, 'ttf312' => $ttf312, 'ttf412' => $ttf412, 'ttf013' => $ttf013, 'ttf014' => $ttf014, 'ttf028' => $ttf028, 'ttf015' => $ttf015, 'ttf016' => $ttf016, 'ttf017' => $ttf017, 'ttf018' => $ttf018, 'ttf019' => $ttf019, 'ttf020' => $ttf020, 'ttf024' => $ttf024, 'ttf025' => $ttf025); } $suche->close(); $id = ''; $ttf001 = ''; $ttf003 = ''; $ttf004 = ''; $ttf005 = ''; $ttf006 = ''; $ttf007 = ''; $ttf008 = ''; $ttf009 = ''; $ttf010 = ''; $ttf011 = ''; $ttf111 = ''; $ttf211 = ''; $ttf311 = ''; $ttf411 = ''; $ttf012 = ''; $ttf112 = ''; $ttf212 = ''; $ttf312 = ''; $ttf412 = ''; $ttf013 = ''; $ttf014 = ''; $ttf028 = ''; $ttf015 = ''; $ttf016 = ''; $ttf017 = ''; $ttf018 = ''; $ttf019 = ''; $ttf020 = ''; $ttf024 = ''; $ttf025 = ''; } // ----------------------------------------------------------------------------------------------------------------------- // HTML // ----------------------------------------------------------------------------------------------------------------------- ?>
"; //$msg .= "PE= Erwachsene Personenid != 1) { $textfeld = $inhalt->ttf211; $texte = explode(' ', $textfeld); // Beispiel: Trennzeichen ist ein Space $text1 = $texte[0]; $text2 = $texte[1]; $text3 = $texte[2]; $tel1 = substr($inhalt->ttf009,1,2); $tel2 = substr($inhalt->ttf009,3,3); $tel3 = substr($inhalt->ttf009,6,2); $tel4 = substr($inhalt->ttf009,8,2); $teldat = "+41".$tel1.$tel2.$tel3.$tel4; $vzname = $inhalt->ttf004.' '.$inhalt->ttf003; $strasse = $inhalt->ttf005.' '.$inhalt->ttf006; $plzort = $inhalt->ttf007.' '.$inhalt->ttf008; $nvname1 = $text1; $nvname2 = $text2; $msg .= ""; $msg .= "$aussehen $inhalt->ttf003
$nvname1"; $msg .= "$aussehen $inhalt->ttf004
$nvname2"; $msg .= "$aussehen $strasse
$teldat"; $msg .= "$aussehen $plzort
$inhalt->ttf010"; $msg .= "$aussehen $inhalt->ttf011
$inhalt->ttf012"; $msg .= "$aussehen $inhalt->ttf013"; $msg .= "$aussehen $inhalt->ttf018
$inhalt->ttf019"; $msg .= "$aussehen $inhalt->ttf014"; $msg .= "$aussehen $inhalt->ttf016"; $msg .= "$aussehen $inhalt->ttf017"; $msg .= "$aussehen $inhalt->ttf028"; $msg .= "$aussehen $inhalt->ttf015"; $msg .= ""; if ( $inhalt->ttf024 != "" ) { $toteh = $toteh + 1; } $totnm = $totnm + $inhalt->ttf018; $totve = $totve + $inhalt->ttf019; $tothu = $tothu + $inhalt->ttf013; $totew = $totew + $inhalt->ttf011; $totki = $totki + $inhalt->ttf012; } } $texhu = "Hund"; if ( $tothu >= 2 ) { $texhu = "Hunde"; } if ( $totve <= 10 ) { $totve = "0".$totve; } if ( $totki <= 10 ) { $totki = "0".$totki; } $msg .= ""; $msg .= "$aussehenTotale :
$sp2"; $msg .= "$aussehen$toteh Einheiten
$sp2"; $msg .= "$aussehen "; $msg .= "$aussehen "; $msg .= "$aussehen$totew Pers
$totki Kind"; $msg .= "$aussehen$tothu $texhu
$sp2"; $msg .= "$aussehen$totnm Menu
$totve Vegi"; $msg .= "$aussehen"; $msg .= "$aussehen"; $msg .= "$aussehen"; $msg .= "$aussehen"; $msg .= "$aussehen"; $msg .= ""; } //Email als UTF-8 senden //-------------------------------------------------------------------------------------------------------------------- // E-Mail aufbereiten an den jeweiligen Organisator aus der Parameterdatei und den Absender aus Parameterdatei //-------------------------------------------------------------------------------------------------------------------- $empfaenger = $email_organisator; $absender = $email_verwalter; //ist zur Zeit immer Fridolin Veyhl, bis zu seiner Abgabe des Verwalters der Software $betreff = "Reservierungen für das Treffen ".$f1event; $antwortan = $absender; if ( $emailcc != "" ) { $cc = $emailcc; } else { $emailcc = ""; } if ( $emailbcc != "" ) { $bcc = $emailbcc; } else { $emailbcc = ""; } $header = "From: $absender\r\n"; $header .= "Reply-To: $antwortan\r\n"; $header .= "Cc: $cc\r\n"; $header .= "Bcc: $bcc\r\n"; $header .= "Content-type: text/html; charset=utf-8\r\n"; $mail_senden = mail($empfaenger,$betreff,$msg,$header); //$emailText = "

$msg