<?php 
require_once './auth.php';
require_once ('connect.php');

//dafür da, dass die Daten des ersten Formulars nach der Überprüfung durch den User weitergeleitet werden und auch nobei in schreiben.php zur Verfügung stehen
include("./function.inc.php"); 
?> 
<!DOCTYPE HTML>

<html>
	<head>
		<title>Homepage der Sporkoordinatoren des Main-Kinzig-Kreises</title>
		<meta http-equiv="content-type" content="text/html; charset=utf-8" />
		<meta name="description" content="" />
		<meta name="keywords" content="" />
		<!--[if lte IE 8]><script src="js/html5shiv.js"></script><![endif]-->
		<script src="js/jquery.min.js"></script>
		<script src="js/skel.min.js"></script>
		<script src="js/skel-layers.min.js"></script>
		<script src="js/init.js"></script>
		<noscript>
			<link rel="stylesheet" href="css/skel.css" />
			<link rel="stylesheet" href="css/style.css" />
			<link rel="stylesheet" href="css/style-xlarge.css" />
		</noscript>
	</head>
	<body>


 


		<!-- Header -->
		<header id="header">
			<nav id="nav">
				<ul>
				<span class="image right"><img src="images/logo_hessen.png" /></span>
				<li><a href='bjs_ko.php'>BJS</a></li>
				<li><a href='wettkaempfeA.php'>JtfO</a></li>
				<li><a href='wanschauenso.php'>Schüler-Olympiade</a></li>
				<li><a href="vorstellung.php">Kontakt</a></li>
				<li><a href='logout.php' class='button fit small'>Abmelden</a></li>				
				</ul>
			</nav>
		</header>

		<!-- Main -->
			<section id="main" class="wrapper">
				<div class="container">

					<header class="major special">
						<h2>Anmeldedetails anschauen</h2>
						<p>Schüler-Olympiade</p>
					</header>	
					<form action="#" method="post">
<?php
					$anr=$_GET['anr'];
					//die Datenbankabfrage, die die Details der Anmeldung abfragt
					$sql_adetails="SELECT ANr, SName, SAnschrift, SPLZ, SOrt, STelefon, SEmail, BName, BTelefon, BEmail FROM anmeldungso WHERE ANr=$anr";
					$result_adetails =mysqli_query($db_link, $sql_adetails);					
					$row_details = mysqli_fetch_assoc($result_adetails);
					

?>
					<h4>Schule</h4>
					<div class="row uniform 50%">
						<div class="6u 12u$(xsmall)">
							<input type="text" name="sname" id="sname" value="<?php echo "$row_details[SName]" ?>" required="required" placeholder="Name der Schule" />
						</div>
						<div class="6u$ 12u$(xsmall)">
							<input type="text" name="sanschrift" id="sanschrift" value="<?php echo "$row_details[SAnschrift]" ?>" required="required" placeholder="Straße und Hausnummer der Schule" />
						</div>
						<div class="6u 12u$(xsmall)">
							<input type="text" name="plz" id="plz" value="<?php echo "$row_details[SPLZ]" ?>" required="required" pattern="[0-9]{5}" placeholder="PLZ der Schule" />
						</div>
						<div class="6u$ 12u$(xsmall)">
							<input type="text" name="ort" id="ort" value="<?php echo "$row_details[SOrt]" ?>" required="required" placeholder="Ort der Schule" />
						</div>	
						<div class="6u 12u$(xsmall)">
							<input type="email" name="semail" id="semail" value="<?php echo "$row_details[SEmail]" ?>" required="required" placeholder="E-Mail Adresse der Schule" />
						</div>
						<div class="6u$ 12u$(xsmall)">
							<input type="text" name="stelefon" id="stelefon" value="<?php echo "$row_details[STelefon]" ?>" required="required" placeholder="Telefonnummer der Schule" />
						</div>						
					</div>	
					<br/>
					<h4>Betreuer der Mannschaft</h4>
					<div class="row uniform 50%">
						<div class="6u 12u$(xsmall)">
							<input type="text" name="bname" id="bname" value="<?php echo "$row_details[BName]" ?>" required="required" placeholder="Name des Betreuers" />
						</div>	
						<div class="6u 12u$(xsmall)">
							<input type="email" name="bemail" id="bemail" value="<?php echo "$row_details[BEmail]" ?>" required="required" placeholder="E-Mail Adresse des Betreuers" />
						</div>
						<div class="6u$ 12u$(xsmall)">
							<input type="text" name="btelefon" id="btelefon" value="<?php echo "$row_details[BTelefon]" ?>" required="required" placeholder="Telefonnummer des Betreuers" />
						</div>						
					</div>
					<br/>
					<h4>Angemeldete Sportarten</h4>	
					
					<table>
						
<?php
				

					
					//Abfrage welche Teams von dieser Schule gemeldet worden sind...
					$sql_teams= "SELECT Fussball, Turnen, Schwimmen, Lak, Lag FROM anmeldungso WHERE ANr=$_GET[anr]";
					$result_teams =mysqli_query($db_link, $sql_teams);					
					
					
					echo "<ul>";
					
					while ($row_teams = mysqli_fetch_row($result_teams)){						
						echo "<li>Fußball: $row_teams[0]</li>";
						echo "<li>Turnen: $row_teams[1]</li>";
						echo "<li>Schwimmen: $row_teams[2]</li>";
						echo "<li>LA kl. Schulen: $row_teams[3]</li>";
						echo "<li>LA gr. Schulen: $row_teams[3]</li>";
					}
					
					echo "</ul>";
					
										
					mysqli_close($db_link);
					
							
?>
						
					
		
									 
						<ul class="actions">
							<li><a href="wanschauenso.php" class="button alt small">Zurück</a></li>
						</ul>
					</div>
					</form>


						
				</div>
			</section>

	<!-- Footer -->
	<footer id="footer">
		<div class="container">
			<ul class="copyright">
				<li>&copy; U. Schumacher</li>
				<li>Design: <a href="http://templated.co">TEMPLATED</a></li>
				<li><a href="disclaimer.php">Disclaimer</a></li>
			</ul>
		</div>
	</footer>



	</body>
</html>