aschwarz/Fragebogen
1
0
Fork 0
Code Issues Pull Requests Packages Projects Releases Wiki Activity
Fragebogen/fragebogen.php
aschwarz d4d5f9fcdc Fehlerkorrekturen
2024-02-29 14:16:21 +01:00

1483 lines
62 KiB
PHP
Executable File
Raw Permalink Blame History

<?PHP
include("aespa/datenbankanbindung.php"); // f&uuml;gt die Datenbankanbindung ein: Sys:\php\includes\kurs\datenbankanbindung.php
#require("check_zweig.php"); // Prüft, ob Innenverwaltung angemeldet ist: setzt datenbankanbindung.php voraus
if ($_COOKIE["uid1"] == ""){ include("kurs/anmeldefehler.php"); exit;} //Wenn man nicht angemeldet ist soll man nichts ausw&auml;hlen k&ouml;nnen
$uid1=$_COOKIE["uid1"];
if (isset($_GET['action']))
$action = $_GET['action'];
else
$action = "";
switch($action){
default:
$db = dbconnect();
$result3 = $db->query("SELECT kontinent
, land
, stadt
, stelle
, adresse
, ansprechpartner
, abteilung
FROM aesp_bewerbung
WHERE uid='$uid1'");
$row3 = $result3->fetch_array();
if(isset($row3['land'])){
setcookie("ck_lid",$row3['land']);
$row3_land = $row3['land'];
}else{
$row3_land = '';
}
if(isset($row3['kontinent'])){
$row3_kontinent = $row3['kontinent'];
}else{
$row3_kontinent = '';
}
if(isset($row3['stadt'])){
$row3_stadt = $row3['stadt'];
}else{
$row3_stadt = '';
}
if(isset($row3['stelle'])){
$row3_stelle = $row3['stelle'];
}else{
$row3_stelle = '';
}
if(isset($row3['adresse'])){
$row3_adresse = $row3['adresse'];
}else{
$row3_adresse = '';
}
if(isset($row3['ansprechpartner'])){
$row3_ansprechpartner = $row3['ansprechpartner'];
}else{
$row3_ansprechpartner = '';
}
if(isset($row3['abteilung'])){
$row3_abteilung = $row3['abteilung'];
}else{
$row3_abteilung = '';
}
echo "
<html>
<head>
<title>Fragebogen zum Auslandspraktikum</title>
<style>
<!--
h2
{margin-bottom:.0001pt;
text-align:center;
page-break-after:avoid;
font-size:20.0pt;
font-family:Arial;
margin-left:0cm; margin-right:0cm; margin-top:0cm}
h1
{margin-bottom:.0001pt;
page-break-after:avoid;
font-size:12.0pt;
font-family:Arial;
margin-left:0cm; margin-right:0cm; margin-top:0cm}
-->
</style>
<script src='jquery-3.4.1.min.js'></script>
<script type='text/javascript'>
function fetch_select(){
var kontinent = document.getElementById('kontinent').options[document.getElementById('kontinent').options.selectedIndex].value;
$.ajax({
type: 'POST',
url: 'get_land.php',
data: {
'function': 'fetch_select',
'kontinent': kontinent
},
success: function(result) { //we got the response
document.getElementById('land').innerHTML=result;
},
error: function(xhr, status, exception) {
console.log(xhr);
}
});
}
</script>
<link rel=\"stylesheet\" href=\"styles_pc.css\" type=\"text/css\">
</head>
<body onload='fetch_select();'>
<h2>Fragebogen zum Auslandspraktikum</h2>
<p align='center'>
<img border='0' src='images/aespa_logo.jpg' width='493' height='132' align='center'></p>
<p align='center'>&nbsp;</p>
<form action=";echo $_SERVER['PHP_SELF'] . "?action=auswertung";echo" method=\"POST\" name=\"auswert\">
<div align='center'>";
$db = dbconnect();
#echo "SELECT vorname, nachname, ag, jahrgang, postrasse, poplz, poort, mail2 FROM kurs.stud WHERE uid='$uid1'";
#exit;
$result = $db->query("SELECT vorname, nachname, ag, jahrgang, postrasse, poplz, poort, mail2 FROM kurs.stud WHERE uid='$uid1'");
$row = $result->fetch_array();
echo"
<table border='0' width='80%' id='table1' style='border-collapse: collapse' bgcolor='#EAEAEA'>
<tr>
<td colspan='4' style='border-left-style: solid; border-left-width: 2px; border-right-style: solid; border-right-width: 2px; border-top-style: solid; border-top-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<b>Pers&ouml;nliche Angaben<br>
</b> Deine pers&ouml;nlichen Daten
werden streng vertraulich behandelt und dienen in erster Linie nur
uns, um dir eventuelle R&uuml;ckfragen zu stellen!
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
Vorname
</td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
$row[vorname]
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Nachname
</td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
$row[nachname]
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
AG
</td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
$row[ag] / $row[jahrgang]
</p>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Strasse, Nr. </td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
$row[postrasse]
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
PLZ, Ort </td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
$row[poplz] $row[poort]
</td>
</tr>";
$result_einver = $db->query("SELECT einverst, studiengang FROM aesp_pers_ang WHERE uid='$uid1'");
$row_einver = $result_einver->fetch_array();
echo"
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Studiengang </td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='radio' value='PMGT' name='studiengang' "; if(isset($row_einver['studiengang']) AND $row_einver['studiengang'] == 'PMGT'){ echo " checked "; } echo">Public Management<br>
<input type='radio' value='AFV' name='studiengang' "; if(isset($row_einver['studiengang']) AND $row_einver['studiengang'] == 'AFV'){ echo " checked "; } echo">Allgemeine Finanzverwaltung<br>
<input type='radio' value='RV' name='studiengang' "; if(isset($row_einver['studiengang']) AND $row_einver['studiengang'] == 'RV'){ echo " checked "; } echo">Rentenversicherung<br>
<input type='radio' value='DVM' name='studiengang' "; if(isset($row_einver['studiengang']) AND $row_einver['studiengang'] == 'DVM'){ echo " checked "; } echo">DVM<br>
<input type='radio' value='MEPA' name='studiengang' "; if(isset($row_einver['studiengang']) AND $row_einver['studiengang'] == 'MEPA'){ echo " checked "; } echo">MEPA<br>
<input type='radio' value='S' name='studiengang' "; if(isset($row_einver['studiengang']) AND $row_einver['studiengang'] == "S"){ echo " checked "; } echo">Sonstiges
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Private Emailadresse </td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='mail' value=\"$row[mail2]\" size='80'>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
</td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='checkbox' name='eiver_rueckfr' value=\"Y\""; if(isset($row_einver['einverst']) AND $row_einver['einverst'] == 'Y'){ echo " checked "; } echo">
Ich bin damit einverstanden, dass meine <u>Emailadresse</u> f&uuml;r eventuelle Nachfragen ver&ouml;ffentlicht wird.
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px; border-bottom-style: solid; border-bottom-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</td>
<td width='82%' style='border-bottom-style: solid; border-bottom-width: 2px; border-right-style:solid; border-right-width:2px'>
<p style='margin-left: 3px; margin-right: 3px'>
&nbsp;</td>
</tr>
</table>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</div>
<div align='center'>";
echo "
<table border='0' width='80%' id='table2' style='border-collapse: collapse' bgcolor='#EAEAEA'>
<tr>
<td colspan='2' style='border-left-style: solid; border-left-width: 2px; border-right-style: solid; border-right-width: 2px; border-top-style: solid; border-top-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<b>Bewerbungsanschrift</b>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Kontinent </td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>";
$db = dbconnect();
$query2 = "SELECT kid, kontinent FROM aesp_kontinent ORDER BY kontinent ASC";
$result2 = $db->query ($query2)
or die ("Cannot execute query");
echo "<select id='kontinent' name='kontinent' onchange='fetch_select();'>
<option value=''>Select</option>";
#echo "<option value='%'";if($row3[kontinent] == '%'){echo " selected";} echo">Alle&nbsp;&nbsp;&nbsp;</option>\n";
while ($row2 = $result2->fetch_array()){
echo "<option value=\"$row2[kid]\"";if(isset($row2['kid']) AND isset($row3_kontinent) AND $row2['kid'] == $row3_kontinent){echo " selected";} echo">".$row2['kontinent']."&nbsp;&nbsp;&nbsp;</option>\n";
}
echo"
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Land </td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<select id='land' name='land'>
</select>
</p>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Stadt </td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='stadt' value=\"$row3_stadt\" size='90'></p>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Stelle </td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='stelle' value=\"$row3_stelle\" size='90'></p>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Postanschrift
</td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='kontaktadresse' value=\"$row3_adresse\" size='90'></p>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ansprechpartner </td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='ansprechpart' value=\"$row3_ansprechpartner\" size='90'></p>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Abteilung
</td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='abteilung' value=\"$row3_abteilung\" size='90'></p>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px; border-bottom-style: solid; border-bottom-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</td>
<td width='82%' style='border-bottom-style: solid; border-bottom-width: 2px; border-right-style:solid; border-right-width:2px'>
<p style='margin-left: 3px; margin-right: 3px'>
&nbsp;</td>
</tr>
</table>
</div>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</div>
<div align='center'>";
$db = dbconnect();
$result = $db->query("SELECT date_format(zeitraum_von, '%d') von_tag
, date_format(zeitraum_von, '%m') von_mon
, date_format(zeitraum_von, '%Y') von_jahr
, date_format(zeitraum_bis, '%d') bis_tag
, date_format(zeitraum_bis, '%m') bis_mon
, date_format(zeitraum_bis, '%Y') bis_jahr
, abteilung_genau
, platz_gefunden
, visum
, transport
, beginn_vorbereitung
, erasmus
, trennungsgeld
, modul
, aufgaben
FROM aesp_allgemein
WHERE uid='$uid1'");
$row = $result->fetch_array();
if(isset($row['von_tag'])){
$von_tag = $row['von_tag'];
}else{
$von_tag = '';
}
if(isset($row['von_mon'])){
$von_mon = $row['von_mon'];
}else{
$von_mon = '';
}
if(isset($row['von_jahr'])){
$von_jahr = $row['von_jahr'];
}else{
$von_jahr = '';
}
if(isset($row['bis_tag'])){
$bis_tag = $row['bis_tag'];
}else{
$bis_tag = '';
}
if(isset($row['bis_mon'])){
$bis_mon = $row['bis_mon'];
}else{
$bis_mon = '';
}
if(isset($row['bis_jahr'])){
$bis_jahr = $row['bis_jahr'];
}else{
$bis_jahr = '';
}
if(isset($row['abteilung_genau'])){
$abteilung_genau = $row['abteilung_genau'];
}else{
$abteilung_genau = '';
}
if(isset($row['platz_gefunden'])){
$platz_gefunden = $row['platz_gefunden'];
}else{
$platz_gefunden = '';
}
if(isset($row['visum'])){
$visum = $row['visum'];
}else{
$visum = '';
}
if(isset($row['transport'])){
$transport = $row['transport'];
}else{
$transport = '';
}
if(isset($row['beginn_vorbereitung'])){
$beginn_vorbereitung = $row['beginn_vorbereitung'];
}else{
$beginn_vorbereitung = '';
}
if(isset($row['erasmus'])){
$erasmus = $row['erasmus'];
}else{
$erasmus = '';
}
if(isset($row['trennungsgeld'])){
$trennungsgeld = $row['trennungsgeld'];
}else{
$trennungsgeld = '';
}
if(isset($row['modul'])){
$modul = $row['modul'];
}else{
$modul = '';
}
if(isset($row['aufgaben'])){
$aufgaben = $row['aufgaben'];
}else{
$aufgaben = '';
}
echo "
<table border='0' width='80%' id='table2' style='border-collapse: collapse' bgcolor='#EAEAEA'>
<tr>
<td colspan='2' style='border-left-style: solid; border-left-width: 2px; border-right-style: solid; border-right-width: 2px; border-top-style: solid; border-top-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<b>Allgemeines zum Praktikum</b>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
Zeitraum </td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
<input type='text' name='von_tag' value=\"$von_tag\" size='2'>.<input type='text' name='von_monat' value=\"$von_mon\" size='2'>.<input type='text' name='von_jahr' value=\"$von_jahr\" size='4'> bis <input type='text' name='bis_tag' value=\"$bis_tag\" size='2'>.<input type='text' name='bis_monat' value=\"$bis_mon\" size='2'>.<input type='text' name='bis_jahr' value=\"$bis_jahr\" size='4'>
</p>
</td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Genaue Bezeichnung der Abteilung </td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='abteilung_genau' value=\"$abteilung_genau\" size='90'></p>
</td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'><br>
Wie hast du Deinen Praktikumsplatz gefunden? </td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='platz_gefunden' value=\"$platz_gefunden\" size='118'></td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'><br>
Wie hast du
die Reise organisiert und wie teuer war diese etwa? </td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
- Visum
</td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='visum' value=\"$visum\" size='90'></td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
- Transport </td>
<td width='82%' style='border-right-style: solid; border-right-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='transport' value=\"$transport\" size='90'></td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'><br>
Wann hast du
mit den Vorbereitungen f&uuml;r das Praktikum begonnen? </td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='vorbereitungsbeginn' value=\"$beginn_vorbereitung\" size='118'></td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
Hast du Erasmusmittel beantragt und wie hoch waren diese?
</td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='erasmus' value=\"$erasmus\" size='118'></td>
</tr>
<tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
<!-- bis 21.01.2024 Hast du einen Auslandskostenzuschlag beantragt und wie hoch war dieser?-->
Wirst du einen Antrag auf Trennungsgeld stellen?
</td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='trennungsgeld' value=\"$trennungsgeld\" size='118'>
</td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
Nur Public Management: In welchem Modul hast Du Dein Praktikum gemacht?
</td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px' align='left'>
<!-- bis 22.01.2024 name='bereich' -->
<input type='radio' value='OPI' name='modul' "; if($modul == 'OPI'){ echo " checked "; } echo">Organisation, Personal, Informationsverarbeitung,<br>
<input type='radio' value='OV' name='modul' "; if($modul == 'OV'){ echo " checked "; } echo">Ordnungsverwaltung<br>
<input type='radio' value='LV' name='modul' "; if($modul == 'LV'){ echo " checked "; } echo">Leistungsverwaltung<br>
<input type='radio' value='WFB' name='modul' "; if($modul == 'WFB'){ echo " checked "; } echo">Wirtschaft und Finanzen, &ouml;ffentliche Betriebe<br>
<input type='radio' value='KFS' name='modul' "; if($modul == 'KFS'){ echo " checked "; } echo">Kommunalpolitik, F&uuml;hrung im &ouml;ffentlichen Sektor
</td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'><br>
Was waren Deine Aufgaben?
</td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<textarea rows='3' name='aufgaben' cols='88'>$aufgaben</textarea></td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px; border-bottom-style: solid; border-bottom-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</td>
<td width='82%' style='border-bottom-style: solid; border-bottom-width: 2px; border-right-style:solid; border-right-width:2px'>
<p style='margin-left: 3px; margin-right: 3px'>
&nbsp;</td>
</tr>
</table>
</div>
<div align='center'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</div>
<div align='center'>";
$db = dbconnect();
$result = $db->query("SELECT wo_gefunden
, ag_hilfe
, kosten
FROM aesp_unterkunft
WHERE uid='$uid1'");
$row = $result->fetch_array();
if(isset($row['wo_gefunden'])){
$wo_gefunden = $row['wo_gefunden'];
}else{
$wo_gefunden = '';
}
if(isset($row['ag_hilfe'])){
$ag_hilfe = $row['ag_hilfe'];
}else{
$ag_hilfe = '';
}
if(isset($row['kosten'])){
$kosten = $row['kosten'];
}else{
$kosten = '';
}
echo"
<table border='0' width='80%' id='table3' style='border-collapse: collapse' bgcolor='#EAEAEA'>
<tr>
<td colspan='2' style='border-left-style: solid; border-left-width: 2px; border-right-style: solid; border-right-width: 2px; border-top-style: solid; border-top-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<b> Zur Unterkunft </b></td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'><br>
Wo hast du
gewohnt und wie hast du die Wohnung gefunden? </td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<textarea rows='2' name='wo_gefunden' cols='88'>$wo_gefunden</textarea></td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
Wurde
dir von Arbeitgeberseite bei der Suche geholfen oder gar eine
Unterkunft zur Verf&uuml;gung gestellt? </td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='ag_hilfe' value=\"$ag_hilfe\" size='118'></td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' height='27' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'><br>
Was hat dich deine Wohnung gekostet? </td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<input type='text' name='kosten' value=\"$kosten\" size='118'></td>
</tr>
<tr>
<td width='17%' style='border-left-style: solid; border-left-width: 2px; border-bottom-style: solid; border-bottom-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</td>
<td width='82%' style='border-bottom-style: solid; border-bottom-width: 2px; border-right-style:solid; border-right-width:2px'>
<p style='margin-left: 3px; margin-right: 3px'>
&nbsp;</td>
</tr>
</table>
<div align='center'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</div>
<div align='center'>";
$db = dbconnect();
$result = $db->query("SELECT einbindung
, aufnahme
, interessant
, gefordert
, dazulernen
, sprachprobleme
, erfahrungen
, schwierigkeiten
FROM aesp_bewertung
WHERE uid='$uid1'");
$row = $result->fetch_array();
if(isset($row['schwierigkeiten'])){
$schwierigkeiten = $row['schwierigkeiten'];
}else{
$schwierigkeiten = '';
}
echo"
<table border='0' width='80%' id='table4' style='border-collapse: collapse' bgcolor='#EAEAEA'>
<tr>
<td colspan='2' style='border-left-style: solid; border-left-width: 2px; border-right-style: solid; border-right-width: 2px; border-top-style: solid; border-top-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<b> Bewertung deiner Stelle</b>
<br>
<span style='font-size: 8pt'>Gib
auf einer Skala von 1 bis 10 an wie sehr diese Aussage auf deine
Stelle zutrifft! 10 heißt dabei, dass es genau so war, eine 1
bedeutet, dass es das Gegenteil der Aussage war. Bleib objektiv
;)</span><br>
&nbsp; </h1>
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich wurde
sehr gut in die tägliche Arbeit mit eingebunden </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='radio' name='einbindung' value='1'"; if(isset($row['einbindung']) AND $row['einbindung'] == '1'){ echo " checked "; } echo">1&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='2'"; if(isset($row['einbindung']) AND $row['einbindung'] == '2'){ echo " checked "; } echo">2&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='3'"; if(isset($row['einbindung']) AND $row['einbindung'] == '3'){ echo " checked "; } echo">3&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='4'"; if(isset($row['einbindung']) AND $row['einbindung'] == '4'){ echo " checked "; } echo">4&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='5'"; if(isset($row['einbindung']) AND $row['einbindung'] == '5'){ echo " checked "; } echo">5&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='6'"; if(isset($row['einbindung']) AND $row['einbindung'] == '6'){ echo " checked "; } echo">6&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='7'"; if(isset($row['einbindung']) AND $row['einbindung'] == '7'){ echo " checked "; } echo">7&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='8'"; if(isset($row['einbindung']) AND $row['einbindung'] == '8'){ echo " checked "; } echo">8&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='9'"; if(isset($row['einbindung']) AND $row['einbindung'] == '9'){ echo " checked "; } echo">9&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='einbindung' value='10'"; if(isset($row['einbindung']) AND $row['einbindung'] == '10'){ echo " checked "; } echo">10
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich f&uuml;hlte
mich auch unter den Kollegen gut aufgenommen </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='radio' name='aufnahme' value='1'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '1'){ echo " checked "; } echo">1&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='2'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '2'){ echo " checked "; } echo">2&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='3'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '3'){ echo " checked "; } echo">3&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='4'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '4'){ echo " checked "; } echo">4&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='5'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '5'){ echo " checked "; } echo">5&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='6'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '6'){ echo " checked "; } echo">6&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='7'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '7'){ echo " checked "; } echo">7&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='8'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '8'){ echo " checked "; } echo">8&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='9'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '9'){ echo " checked "; } echo">9&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='aufnahme' value='10'"; if(isset($row['aufnahme']) AND $row['aufnahme'] == '10'){ echo " checked "; } echo">10
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Die mir
gestellten Ausgaben waren interessant </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='radio' name='interessant' value='1'"; if(isset($row['interessant']) AND $row['interessant'] == '1'){ echo " checked "; } echo">1&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='2'"; if(isset($row['interessant']) AND $row['interessant'] == '2'){ echo " checked "; } echo">2&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='3'"; if(isset($row['interessant']) AND $row['interessant'] == '3'){ echo " checked "; } echo">3&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='4'"; if(isset($row['interessant']) AND $row['interessant'] == '4'){ echo " checked "; } echo">4&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='5'"; if(isset($row['interessant']) AND $row['interessant'] == '5'){ echo " checked "; } echo">5&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='6'"; if(isset($row['interessant']) AND $row['interessant'] == '6'){ echo " checked "; } echo">6&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='7'"; if(isset($row['interessant']) AND $row['interessant'] == '7'){ echo " checked "; } echo">7&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='8'"; if(isset($row['interessant']) AND $row['interessant'] == '8'){ echo " checked "; } echo">8&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='9'"; if(isset($row['interessant']) AND $row['interessant'] == '9'){ echo " checked "; } echo">9&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='interessant' value='10'"; if(isset($row['interessant']) AND $row['interessant'] == '10'){ echo " checked "; } echo">10
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich f&uuml;hlte
mich gefordert </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='radio' name='gefordert' value='1'"; if(isset($row['gefordert']) AND $row['gefordert'] == '1'){ echo " checked "; } echo">1&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='2'"; if(isset($row['gefordert']) AND $row['gefordert'] == '2'){ echo " checked "; } echo">2&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='3'"; if(isset($row['gefordert']) AND $row['gefordert'] == '3'){ echo " checked "; } echo">3&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='4'"; if(isset($row['gefordert']) AND $row['gefordert'] == '4'){ echo " checked "; } echo">4&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='5'"; if(isset($row['gefordert']) AND $row['gefordert'] == '5'){ echo " checked "; } echo">5&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='6'"; if(isset($row['gefordert']) AND $row['gefordert'] == '6'){ echo " checked "; } echo">6&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='7'"; if(isset($row['gefordert']) AND $row['gefordert'] == '7'){ echo " checked "; } echo">7&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='8'"; if(isset($row['gefordert']) AND $row['gefordert'] == '8'){ echo " checked "; } echo">8&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='9'"; if(isset($row['gefordert']) AND $row['gefordert'] == '9'){ echo " checked "; } echo">9&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='gefordert' value='10'"; if(isset($row['gefordert']) AND $row['gefordert'] == '10'){ echo " checked "; } echo">10
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich habe
etwas dazulernen k&ouml;nnen </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='radio' name='dazulernen' value='1'"; if(isset($row['dazulernen']) AND $row['dazulernen'] == '1'){ echo " checked "; } echo">1&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='2'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '2'){ echo " checked "; } echo">2&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='3'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '3'){ echo " checked "; } echo">3&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='4'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '4'){ echo " checked "; } echo">4&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='5'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '5'){ echo " checked "; } echo">5&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='6'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '6'){ echo " checked "; } echo">6&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='7'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '7'){ echo " checked "; } echo">7&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='8'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '8'){ echo " checked "; } echo">8&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='9'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '9'){ echo " checked "; } echo">9&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='dazulernen' value='10'"; if(isset($row['dazulernen']) AND$row['dazulernen'] == '10'){ echo " checked "; } echo">10
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich hatte
keinerlei Probleme mit der Sprache </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='radio' name='sprachprobleme' value='1'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '1'){ echo " checked "; } echo">1&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='2'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '2'){ echo " checked "; } echo">2&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='3'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '3'){ echo " checked "; } echo">3&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='4'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '4'){ echo " checked "; } echo">4&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='5'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '5'){ echo " checked "; } echo">5&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='6'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '6'){ echo " checked "; } echo">6&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='7'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '7'){ echo " checked "; } echo">7&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='8'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '8'){ echo " checked "; } echo">8&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='9'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '9'){ echo " checked "; } echo">9&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='sprachprobleme' value='10'"; if(isset($row['sprachprobleme']) AND $row['sprachprobleme'] == '10'){ echo " checked "; } echo">10
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich konnte viele gute Erfahrungen sammeln </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='radio' name='erfahrungen' value='1'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '1'){ echo " checked "; } echo">1&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='2'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '2'){ echo " checked "; } echo">2&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='3'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '3'){ echo " checked "; } echo">3&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='4'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '4'){ echo " checked "; } echo">4&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='5'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '5'){ echo " checked "; } echo">5&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='6'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '6'){ echo " checked "; } echo">6&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='7'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '7'){ echo " checked "; } echo">7&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='8'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '8'){ echo " checked "; } echo">8&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='9'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '9'){ echo " checked "; } echo">9&nbsp;&nbsp;&nbsp;&nbsp;
<input type='radio' name='erfahrungen' value='10'"; if(isset($row['erfahrungen']) AND $row['erfahrungen'] == '10'){ echo " checked "; } echo">10
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px' height='25'>
<p style='margin-left: 3px; margin-right: 3px'>
<br>
Eventuelle
Schwierigkeiten </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px' height='25'>
<br>
<input type='text' name='schwierigkeiten' value=\"$schwierigkeiten\" size='65'></td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px; border-bottom-style: solid; border-bottom-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</td>
<td width='56%' style='border-bottom-style: solid; border-bottom-width: 2px; border-right-style:solid; border-right-width:2px'>
<p style='margin-left: 3px; margin-right: 3px'>
&nbsp;</td>
</tr>
</table>
</div>
<div align='center'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</div>
<div align='center'>";
$db = dbconnect();
$result = $db->query("SELECT lebenshaltungskosten
, unternehmen
, kontakte
, schwierigkeit_kontakte
FROM aesp_freizeit
WHERE uid='$uid1'");
$row = $result->fetch_array();
if(isset($row['lebenshaltungskosten'])){
$lebenshaltungskosten = $row['lebenshaltungskosten'];
}else{
$lebenshaltungskosten = '';
}
if(isset($row['unternehmen'])){
$unternehmen = $row['unternehmen'];
}else{
$unternehmen = '';
}
if(isset($row['kontakte'])){
$kontakte = $row['kontakte'];
}else{
$kontakte = '';
}
if(isset($row['schwierigkeit_kontakte'])){
$schwierigkeit_kontakte = $row['schwierigkeit_kontakte'];
}else{
$schwierigkeit_kontakte = '';
}
echo"
<table border='0' width='80%' id='table5' style='border-collapse: collapse' bgcolor='#EAEAEA'>
<tr>
<td colspan='2' style='border-left-style: solid; border-left-width: 2px; border-right-style: solid; border-right-width: 2px; border-top-style: solid; border-top-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<b>Freizeit<br>
&nbsp;</b>
</td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Lebensunterhaltskosten/Woche ca. </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='text' name='lebenshaltungskosten' value=\"$lebenshaltungskosten\" size='65'></td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Was konnte
man unternehmen?<br>
(Tags&uuml;ber und Nachts) </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<textarea rows='2' name='unternehmen' cols='48'>$unternehmen</textarea></td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Konntest du
Kontakte kn&uuml;pfen? </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='text' name='kontakte' value=\"$kontakte\" size='65'></td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
War dies
eher leicht/schwer? </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<input type='text' name='schwierigkeit_kontakte' value=\"$schwierigkeit_kontakte\" size='65'></td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px; border-bottom-style: solid; border-bottom-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</td>
<td width='56%' style='border-bottom-style: solid; border-bottom-width: 2px; border-right-style:solid; border-right-width:2px'>
<p style='margin-left: 3px; margin-right: 3px'>
&nbsp;</td>
</tr>
</table>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</div>
<div align='center'>
<div align='center'>";
$db = dbconnect();
$result = $db->query("SELECT letzte_worte
FROM aesp_schluss
WHERE uid='$uid1'");
$row = $result->fetch_array();
if(isset($row['letzte_worte'])){
$letzte_worte = $row['letzte_worte'];
}else{
$letzte_worte = '';
}
echo"
<table border='0' width='80%' id='table6' style='border-collapse: collapse' bgcolor='#EAEAEA'>
<tr>
<td colspan='2' style='border-left-style: solid; border-left-width: 2px; border-right-style: solid; border-right-width: 2px; border-top-style: solid; border-top-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
<b>Deine abschließenden Worte</b><br>
<span style='font-size: 8pt'>Was du einem
Studenten mit auf den langen Weg ins Ausland geben m&ouml;chtest! Ein
paar gute Tipps vielleicht? <br>
&nbsp;</h1>
</td>
</tr>
<tr>
<td width='99%' style='border-left-style: solid; border-left-width: 2px; border-right-style:solid; border-right-width:2px' colspan='2'>
<p style='margin-left: 3px; margin-right: 3px'>
<textarea rows='5' name='letzte_worte' cols='88'>$letzte_worte</textarea></td>
</tr>
<tr>
<td width='43%' style='border-left-style: solid; border-left-width: 2px; border-bottom-style: solid; border-bottom-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</td>
<td width='56%' style='border-bottom-style: solid; border-bottom-width: 2px; border-right-style:solid; border-right-width:2px'>
<p style='margin-left: 3px; margin-right: 3px'>
&nbsp;</td>
</tr>
</table>
</div>
<br>
<br>
<input type=\"submit\" value=\"Daten speichern\" name=\"B1\" size=\"20\"></form>
</div>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</div>
<p style='margin-left: 3px; margin-right: 3px'>&nbsp;</div>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
<p>&nbsp;</p>
</form>
</body>
</html>";
break;
case "auswertung":
$fehler = TRUE;
$db = dbconnect();
## Persönliche Angaben ##
if(isset($_POST['mail'])){
$mail=$_POST['mail'];
}else{
$mail='';
}
if(isset($_POST['eiver_rueckfr']) AND $_POST['eiver_rueckfr'] != ''){
$eiver_rueckfr=$_POST['eiver_rueckfr'];
}else{
$eiver_rueckfr = 'N';
}
if(isset($_POST['studiengang']) AND $_POST['studiengang'] != ''){
$studiengang=$_POST['studiengang'];
}else{
$studiengang = '';
}
$sql = $db->query ("DELETE FROM aesp_pers_ang WHERE uid = '$uid1'");
$sql = $db->query ("UPDATE kurs.stud SET mail2 = '$mail' WHERE uid = '$uid1'");
$sql = $db->query ("INSERT INTO aesp_pers_ang
(uid, einverst, studiengang)
VALUES
('$uid1', '$eiver_rueckfr', '$studiengang')");
if(!$sql){
$fehler = FALSE;
}
## Bewerbung ##
if(isset($_POST['kontinent'])){
$kontinent=addslashes($_POST['kontinent']);
}else{
$kontinent='';
}
if(isset($_POST['land'])){
$land=addslashes($_POST['land']);
}else{
$land='';
}
if(isset($_POST['stadt'])){
$stadt=addslashes($_POST['stadt']);
}else{
$stadt='';
}
if(isset($_POST['stelle'])){
$stelle=addslashes($_POST['stelle']);
}else{
$stelle='';
}
if(isset($_POST['kontaktadresse'])){
$adresse=addslashes($_POST['kontaktadresse']);
}else{
$adresse='';
}
if(isset($_POST['ansprechpart'])){
$ansprechpart=addslashes($_POST['ansprechpart']);
}else{
$ansprechpart='';
}
if(isset($_POST['abteilung'])){
$abteilung=addslashes($_POST['abteilung']);
}else{
$abteilung='';
}
$sql = $db->query ("DELETE FROM aesp_bewerbung WHERE uid = '$uid1'");
$sql = $db->query ("INSERT INTO aesp_bewerbung
(uid, kontinent, land, stadt, stelle, adresse, ansprechpartner, abteilung)
VALUES
('$uid1', '$kontinent', '$land', '$stadt', '$stelle', '$adresse', '$ansprechpart', '$abteilung')");
if(!$sql){
$fehler = FALSE;
}
## Allgemein ##
$sql = $db->query ("DELETE FROM aesp_allgemein WHERE uid = '$uid1'");
if(isset($_POST['von_jahr']) AND isset($_POST['von_monat']) AND isset($_POST['von_tag'])){
$zeitraum_von="$_POST[von_jahr]-$_POST[von_monat]-$_POST[von_tag]";
}else{
$zeitraum_von='';
}
if(isset($_POST['bis_jahr']) AND isset($_POST['bis_monat']) AND isset($_POST['bis_tag'])){
$zeitraum_bis="$_POST[bis_jahr]-$_POST[bis_monat]-$_POST[bis_tag]";
}else{
$zeitraum_bis='';
}
if(isset($_POST['abteilung_genau'])){
$abteilung_genau=addslashes($_POST['abteilung_genau']);
}else{
$abteilung_genau='';
}
if(isset($_POST['platz_gefunden'])){
$platz_gefunden=addslashes($_POST['platz_gefunden']);
}else{
$platz_gefunden='';
}
if(isset($_POST['visum'])){
$visum=$_POST['visum'];
}else{
$visum='';
}
if(isset($_POST['transport'])){
$transport=$_POST['transport'];
}else{
$transport='';
}
if(isset($_POST['vorbereitungsbeginn'])){
$beginn_vorbereitung=$_POST['vorbereitungsbeginn'];
}else{
$beginn_vorbereitung='';
}
if(isset($_POST['erasmus'])){
$erasmus=$_POST['erasmus'];
}else{
$erasmus='';
}
if(isset($_POST['trennungsgeld'])){
$trennungsgeld=$_POST['trennungsgeld'];
}else{
$trennungsgeld='';
}
if(isset($_POST['modul'])){
$modul=$_POST['modul'];
}else{
$modul='';
}
if(isset($_POST['aufgaben'])){
$aufgaben=$_POST['aufgaben'];
}else{
$aufgaben='';
}
$sql = $db->query ("INSERT INTO aesp_allgemein
(uid, zeitraum_von, zeitraum_bis, abteilung_genau, platz_gefunden, visum, transport, beginn_vorbereitung, erasmus, trennungsgeld, modul, aufgaben)
VALUES
('$uid1', '$zeitraum_von', '$zeitraum_bis', '$abteilung_genau', '$platz_gefunden', '$visum', '$transport', '$beginn_vorbereitung', '$erasmus', '$trennungsgeld', '$modul', '$aufgaben')");
if(!$sql){
$fehler = FALSE;
}
## Unterkunft ##
$sql = $db->query ("DELETE FROM aesp_unterkunft WHERE uid = '$uid1'");
if(isset($_POST['wo_gefunden'])){
$wo_gefunden=$_POST['wo_gefunden'];
}else{
$wo_gefunden='';
}
if(isset($_POST['ag_hilfe'])){
$ag_hilfe=$_POST['ag_hilfe'];
}else{
$ag_hilfe='';
}
if(isset($_POST['kosten'])){
$kosten=$_POST['kosten'];
}else{
$kosten='';
}
$sql = $db->query ("INSERT INTO aesp_unterkunft
(uid, wo_gefunden, ag_hilfe, kosten)
VALUES
('$uid1', '$wo_gefunden', '$ag_hilfe', '$kosten')");
if(!$sql){
$fehler = FALSE;
}
## Bewertung ##
$sql = $db->query ("DELETE FROM aesp_bewertung WHERE uid = '$uid1'");
if(isset($_POST['einbindung'])){
$einbindung=$_POST['einbindung'];
}else{
$einbindung='';
}
if(isset($_POST['aufnahme'])){
$aufnahme=$_POST['aufnahme'];
}else{
$aufnahme='';
}
if(isset($_POST['interessant'])){
$interessant=$_POST['interessant'];
}else{
$interessant='';
}
if(isset($_POST['gefordert'])){
$gefordert=$_POST['gefordert'];
}else{
$gefordert='';
}
if(isset($_POST['dazulernen'])){
$dazulernen=$_POST['dazulernen'];
}else{
$dazulernen='';
}
if(isset($_POST['sprachprobleme'])){
$sprachprobleme=$_POST['sprachprobleme'];
}else{
$sprachprobleme='';
}
if(isset($_POST['erfahrungen'])){
$erfahrungen=$_POST['erfahrungen'];
}else{
$erfahrungen='';
}
if(isset($_POST['schwierigkeiten'])){
$schwierigkeiten=$_POST['schwierigkeiten'];
}else{
$schwierigkeiten='';
}
$sql = $db->query ("INSERT INTO aesp_bewertung
(uid, einbindung, aufnahme, interessant, gefordert, dazulernen, sprachprobleme, erfahrungen, schwierigkeiten)
VALUES
('$uid1', '$einbindung', '$aufnahme', '$interessant', '$gefordert', '$dazulernen', '$sprachprobleme', '$erfahrungen', '$schwierigkeiten')");
if(!$sql){
$fehler = FALSE;
}
## Freizeit ##
$sql = $db->query ("DELETE FROM aesp_freizeit WHERE uid = '$uid1'");
if(isset($_POST['lebenshaltungskosten'])){
$lebenshaltungskosten=$_POST['lebenshaltungskosten'];
}else{
$lebenshaltungskosten='';
}
if(isset($_POST['unternehmen'])){
$unternehmen=$_POST['unternehmen'];
}else{
$unternehmen='';
}
if(isset($_POST['kontakte'])){
$kontakte=$_POST['kontakte'];
}else{
$kontakte='';
}
if(isset($_POST['schwierigkeit_kontakte'])){
$schwierigkeit_kontakte=$_POST['schwierigkeit_kontakte'];
}else{
$schwierigkeit_kontakte='';
}
$sql = $db->query ("INSERT INTO aesp_freizeit
(uid, lebenshaltungskosten, unternehmen, kontakte, schwierigkeit_kontakte)
VALUES
('$uid1', '$lebenshaltungskosten', '$unternehmen', '$kontakte', '$schwierigkeit_kontakte')");
if(!$sql){
$fehler = FALSE;
}
## Schlussbemerkung
$sql = $db->query ("DELETE FROM aesp_schluss WHERE uid = '$uid1'");
if(isset($_POST['letzte_worte'])){
$letzte_worte=$_POST['letzte_worte'];
}else{
$letzte_worte='';
}
$sql = $db->query ("INSERT INTO aesp_schluss
(uid, letzte_worte)
VALUES
('$uid1', '$letzte_worte')");
if(!$sql){
$fehler = FALSE;
}
if($fehler == TRUE){ // wenn alle Inserts erfolgreich durchgelaufen sind, dann erfolgsmeldung
echo"
<html>
<head>
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
<link rel=\"stylesheet\" href=\"styles_pc.css\" type=\"text/css\">
<title>Eingabefehler</title>
</head>
<body>
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
<tr>
<td>
<div align=\"center\">
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
<tr>
<td width=\"10\" background=\"images/box_e1.gif\">
<img height=\"40\" src=\"images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"images/box_top.gif\" valign=\"top\"></td>
<td width=\"95%\" background=\"images/box_top.gif\">
<img height=\"10\" src=\"images/blank.gif\" width=\"1\"><br>
<span class=\"sh\">Einbindung <br>
<img height=\"5\" src=\"images/blank.gif\" width=\"1\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"images/box_e2.gif\">
<img height=\"40\" src=\"images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td width=\"1%\" background=\"images/box_l.gif\">
<img height=\"1\" src=\"images/blank.gif\" width=\"22\"></td>
<td colspan=\"2\"><br>
<p align=\"center\"><b>Herzlichen Dank!</b>
<br>
Wir m&ouml;chten uns ganz herzlich bei Dir daf&uuml;r bedanken, dass Du die M&uuml;he auf
dich genommen hast, diesen Bogen auszuf&uuml;llen und somit allen
Studierenden nach dir einiges an Sorgen und Ängsten genommen
hast!<br>
Wenn Du Lust hast, schau einfach mal rein auf die Seite des
Akademischen Auslandsamtes. Dort wird demnächst neben allerlei
hilfreichen Dingen auch ein Forum und das Ergebnis dieses Bogens
zu finden sein! Wir w&uuml;nschen Dir noch viel Freude und auch viel
Erfolg auf Deinem weiteren Weg!&nbsp;&nbsp;&nbsp;
AESPA
</p>
<p align=\"center\">
<a href=\"fragebogen.php\">&uuml;berarbeiten</a>
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
<a href=\"hauptframe.php\">Startseite</a>
</p>
<p></p>
<p></p>
<p></p>
<p></p>
<p><br>
</p>
</td>
<td width=\"1%\" background=\"images/box_r.gif\">
<img height=\"1\" src=\"images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"images/box_e3.gif\">
<img height=\"16\" src=\"images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"images/box_bottom.gif\" colspan=\"2\">
<img height=\"16\" src=\"images/blank.gif\" width=\"8\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"images/box_e4.gif\">
<img height=\"16\" src=\"images/blank.gif\" width=\"22\"> </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</body>
</html>";
exit;
}else{
echo"
<html>
<head>
<meta http-equiv=\"content-type\" content=\"text/html; charset=utf-8\">
<link rel=\"stylesheet\" href=\"styles_pc.css\" type=\"text/css\">
<title>Eingabefehler</title>
</head>
<body>
<table border=\"0\" style=\"border-collapse: collapse\" width=\"100%\" cellpadding=\"0\" height=\"100%\" id=\"table1\">
<tr>
<td>
<div align=\"center\">
<table cellspacing=\"0\" cellpadding=\"0\" width=\"550\" border=\"0\">
<tr>
<td width=\"10\" background=\"images/box_e1.gif\">
<img height=\"40\" src=\"images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"3%\" background=\"images/box_top.gif\" valign=\"top\"></td>
<td width=\"95%\" background=\"images/box_top.gif\">
<img height=\"10\" src=\"images/blank.gif\" width=\"1\"><br>
<span class=\"sh\">Fehler <br>
<img height=\"5\" src=\"images/blank.gif\" width=\"1\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"images/box_e2.gif\">
<img height=\"40\" src=\"images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td width=\"1%\" background=\"images/box_l.gif\">
<img height=\"1\" src=\"images/blank.gif\" width=\"22\"></td>
<td colspan=\"2\"><br>
<p align=\"center\"><b>Die Daten konnten nicht eingebunden werden!
<br>
Setzen Sie sich bitte mit dem AESPA in Verbindung!
</b>
</p>
<p align=\"center\">
<a href=\"javascript:history.back()\">zur&uuml;ck</a>
&nbsp;
&nbsp;
&nbsp;
&nbsp;
&nbsp;
<a href=\"logout.php\">Logout</a>
</p>
<p></p>
<p></p>
<p></p>
<p></p>
<p><br>
</p>
</td>
<td width=\"1%\" background=\"images/box_r.gif\">
<img height=\"1\" src=\"images/blank.gif\" width=\"22\"></td>
</tr>
<tr>
<td nowrap=\"nowrap\" align=\"left\" width=\"1%\" background=\"images/box_e3.gif\">
<img height=\"16\" src=\"images/blank.gif\" width=\"22\"></td>
<td nowrap=\"nowrap\" align=\"left\" width=\"98%\" background=\"images/box_bottom.gif\" colspan=\"2\">
<img height=\"16\" src=\"images/blank.gif\" width=\"8\"></td>
<td nowrap=\"nowrap\" align=\"right\" width=\"1%\" background=\"images/box_e4.gif\">
<img height=\"16\" src=\"images/blank.gif\" width=\"22\"> </td>
</tr>
</table>
</div>
</td>
</tr>
</table>
</body>
</html>";
exit;
}
}
?>
Reference in New Issue View Git Blame Copy Permalink