Fragebogen/ansicht.php
2023-02-23 10:53:04 +01:00

735 lines
28 KiB
PHP
Executable File

<?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"];
$uid_user=$_GET['uid_user'];
$db = dbconnect();
$result3 = $db->query("SELECT kontinent
, land
, stadt
, adresse
, ansprechpartner
, abteilung
FROM aesp_bewerbung
WHERE uid='$uid_user'");
$row3 = $result3->fetch_array();
setcookie("ck_lid",$row3['land']);
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 type='text/javascript' src='ajax.js'></script>
<script type='text/javascript'>
/************************************************************************************************************
Ajax chained select
Copyright (C) 2006 DTHMLGoodies.com, Alf Magne Kalleland
This library is free software; you can redistribute it and/or
modify it under the terms of the GNU Lesser General Public
License as published by the Free Software Foundation; either
version 2.1 of the License, or (at your option) any later version.
This library is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
Lesser General Public License for more details.
You should have received a copy of the GNU Lesser General Public
License along with this library; if not, write to the Free Software
Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
Dhtmlgoodies.com., hereby disclaims all copyright interest in this script
written by Alf Magne Kalleland.
Alf Magne Kalleland, 2006
Owner of DHTMLgoodies.com
************************************************************************************************************/
var ajax = new sack();
function getCityList(sel)
{
var countryCode = sel.options[sel.selectedIndex].value;
document.getElementById('dhtmlgoodies_city').options.length = 0; // Empty city select box
if(countryCode.length>0){
ajax.requestFile = 'getSubCat.php?countryCode='+countryCode; // Specifying which file to get
ajax.onCompletion = createCities; // Specify function that will be executed after file has been found
ajax.runAJAX(); // Execute AJAX function
}
}
function createCities()
{
var obj = document.getElementById('dhtmlgoodies_city');
eval(ajax.response); // Executing the response from Ajax as Javascript code
}
</script>
<link rel=\"stylesheet\" href=\"styles_pc.css\" type=\"text/css\">
</head>
<body onload=\"if(document.auswert)document.auswert.dhtmlgoodies_country.focus();if(document.auswert)document.auswert.uberschrift.focus();return false;\">
<h2>Fragebogen zum Auslandspraktikum</h2>
<p align='center'>
<img border='0' src='images/aespa_logo.jpg' width='493' height='132' align='center'></p>";
$result_edit = $db->query("SELECT DISTINCT 1
FROM aesp_admin_rechte_zuord
WHERE uid = '$uid1'
AND aesp_admin_rolle = 'a_neuanlag'");
$row_edit = $result_edit->fetch_array();
if($row_edit[0] == '1'){
echo "<div align='center'><a href=\"neuanlage.php?action=studbearb&stud_uid=$uid_user\"><img src=\"images/edit.png\" border=\"0\"></a></div>";
}
echo"
<p align=\"center\"><a href=\"javascript:history.back()\">
<img border=\"0\" src=\"images/zurueck.gif\" width=\"77\" height=\"22\"></a>
<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='$uid_user'";
#exit;
$result_einver = $db->query("SELECT einverst FROM aesp_pers_ang WHERE uid = '$uid_user'");
$row_einver = $result_einver->fetch_array();
if($row_einver['einverst'] == 'Y'){
$result = $db->query("SELECT mail2 FROM kurs.stud WHERE uid='$uid_user'");
$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önliche Angaben<br>
</b> Deine persönlichen Daten
werden streng vertraulich behandelt und dienen in erster Linie nur
uns, um dir eventuelle Rü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'>
&nbsp;
</td>
<td width='82%' colspan='3' style='border-right-style: solid; border-right-width: 2px'>
&nbsp;
</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'>
<a href='mailto:$row[mail2]?subject=Frage zum Auslandspraktikum'>$row[mail2]</a>
</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>";
}
echo "
<div align='center'>
<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();
$result2 = $db->query ("SELECT kid, kontinent FROM aesp_kontinent WHERE kid=$row3[kontinent]");
$row2 = $result2->fetch_array();
echo"
<b>$row2[kontinent]</b>
</td>
</tr>";
$result4 = $db->query ("SELECT lid, land FROM aesp_land WHERE lid LIKE '$row3[land]'");
$row4 = $result4->fetch_array();
echo "
<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'>
<b>$row4[land]</b>
</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'>
<b>$row3[stadt]</b></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'>
<b>$row3[adresse]</b>
</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'>
<b>$row3[ansprechpartner]</b>
</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'>
<b>$row3[abteilung]</b>
</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.%m.%Y') von
, date_format(zeitraum_bis, '%d.%m.%Y') bis
, abteilung_genau
, platz_gefunden
, visum
, transport
, beginn_vorbereitung
, erasmus
, auslandskostenzuschlag
, bereich
, beschreibung
, aufgaben
FROM aesp_allgemein
WHERE uid='$uid_user'");
$row = $result->fetch_array();
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>
<b>$row[von]</b> bis <b>$row[bis]</b>
</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'>
<b>$row[abteilung_genau]</b></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'>
<b>$row[platz_gefunden]</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>
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'>
<b>$row[visum]</b>
</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'>
<b>$row[transport]</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>
Wann hast du
mit den Vorbereitungen fü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'>
<b>$row[beginn_vorbereitung]</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>
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'>
<b>$row[erasmus]</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>
Hast du einen Auslandskostenzuschlag beantragt und wie hoch war dieser?
</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'>
<b>$row[auslandskostenzuschlag]</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>
In
welchen Bereich kann man deinen Praktikumsplatz einordnen? </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'>";
switch($row['bereich'])
{
case 'S':
$bereich = 'Sonstige';
break;
case 'OV':
$bereich = 'Öffentliche Verwaltung';
break;
case 'FW':
$bereich = 'Freie Wirtschaft';
break;
}
echo"
<b>$bereich</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>
Bitte
beschreibe die Stelle kurz: </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'>
<b>$row[beschreibung]</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>
Deine
Aufgaben bei dieser Stelle waren: </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'>
<b>$row[aufgaben]</b>
</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='$uid_user'");
$row = $result->fetch_array();
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'>
<b>$row[wo_gefunden]</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>
Wurde
dir von Arbeitgeberseite bei der Suche geholfen oder gar eine
Unterkunft zur Verfü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'>
<b>$row[ag_hilfe]</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>
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'>
<b>$row[kosten]</b>
</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='$uid_user'");
$row = $result->fetch_array();
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='60%' 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='40%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[einbindung]</b>
</td>
</tr>
<tr>
<td width='60%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich fühlte mich auch unter den Kollegen gut aufgenommen </td>
<td width='40%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[aufnahme]</b>
</td>
</tr>
<tr>
<td width='60%' 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='40%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[interessant]</b>
</td>
</tr>
<tr>
<td width='60%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich fühlte
mich gefordert </td>
<td width='40%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[gefordert]</b>
</td>
</tr>
<tr>
<td width='60%' style='border-left-style: solid; border-left-width: 2px'>
<p style='margin-left: 3px; margin-right: 3px'>
Ich habe
etwas dazulernen können </td>
<td width='40%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[dazulernen]</b>
</td>
</tr>
<tr>
<td width='60%' 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='40%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[sprachprobleme]</b> </td>
</tr>
<tr>
<td width='60%' 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='40%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[erfahrungen]</b> </td>
</tr>
<tr>
<td width='60%' 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='40%' style='border-right-style: solid; border-right-width: 2px' height='25'>
<br>
<b>$row[schwierigkeiten]</b>
</td>
</tr>
<tr>
<td width='60%' 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='40%' 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='$uid_user'");
$row = $result->fetch_array();
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'>
<b>$row[lebenshaltungskosten]</b>
</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über und Nachts) </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[unternehmen]</b>
</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üpfen? </td>
<td width='56%' style='border-right-style: solid; border-right-width: 2px'>
<b>$row[kontakte]</b>
</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'>
<b>$row[schwierigkeit_kontakte]</b>
</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='$uid_user'");
$row = $result->fetch_array();
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ö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'>
<b>$row[letzte_worte]</b>
</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>
<p align=\"center\"><a href=\"javascript:history.back()\">
<img border=\"0\" src=\"images/zurueck.gif\" width=\"77\" height=\"22\"></a>
</body>
</html>";
?>