<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN"
"http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

	<head>
	
		<title>Los Angeles Stadt der Engel</title>
		<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
		<link rel='stylesheet' media='all' type="text/css" href="stylesheet.css" />
		<style type="text/css"></style>

	</head>
	
	<body>

		<?php
			require_once("db_connection.php");
			require_once("poi.txt");
		?>

		<div class="data">
		<B><p class="menue">Information</p></B><br/>

		<?php 
			if (array_key_exists('name',$_GET)) {
				$name = $_GET['name'];
					
			switch (($_GET['name'])) {
				case "USH":
					$query = "SELECT name, info FROM pois WHERE name = 'Universal Studios Hollywood'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "GO":
					$query = "SELECT name, info FROM pois WHERE name = 'Griffith Observatorium'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "GC":
					$query = "SELECT name, info FROM pois WHERE name = 'Getty Center'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "GV":
					$query = "SELECT name, info FROM pois WHERE name = 'Getty Villa'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "GCT":
					$query = "SELECT name, info FROM pois WHERE name = 'Graumans Chinese Theatre'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "HWF":
					$query = "SELECT name, info FROM pois WHERE name = 'Hollywood Walk of Fame'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;	
				case "HS":
					$query = "SELECT name, info FROM pois WHERE name = 'Hollywood Sign'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "EPLA":
					$query = "SELECT name, info FROM pois WHERE name = 'El Pueblo de Los Angeles'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "MCA":
					$query = "SELECT name, info FROM pois WHERE name = 'Museum of Contemporary Art'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "MT":
					$query = "SELECT name, info FROM pois WHERE name = 'Museum of Tolerance'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "HM":
					$query = "SELECT name, info FROM pois WHERE name = 'Hollywood Museum'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "PAM":
					$query = "SELECT name, info FROM pois WHERE name = 'Petersen Automotive Museum'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;	
				case "HRH":
					$query = "SELECT name, info FROM pois WHERE name = 'Hollywood Roosevelt Hotel'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "KT":
					$query = "SELECT name, info FROM pois WHERE name = 'Kodak Theatre'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "RD":
					$query = "SELECT name, info FROM pois WHERE name = 'Rodeo Drive'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "SS":
					$query = "SELECT name, info FROM pois WHERE name = 'Sunset Strip'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "TSP":
					$query = "SELECT name, info FROM pois WHERE name = 'Third Street Promenade'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "WDCH":
					$query = "SELECT name, info FROM pois WHERE name = 'Walt Disney Concert Hall'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "CLA":
					$query = "SELECT name, info FROM pois WHERE name = 'Cathedral of our Lady of the Angels'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "CRT":
					$query = "SELECT name, info FROM pois WHERE name = 'Capitol Records Tower'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "VB":
					$query = "SELECT name, info FROM pois WHERE name = 'Venice Beach'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "MB":
					$query = "SELECT name, info FROM pois WHERE name = 'Malibu Beach'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "GP":
					$query = "SELECT name, info FROM pois WHERE name = 'Griffith Park'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "PS":
					$query = "SELECT name, info FROM pois WHERE name = 'Pershing Square'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "US":
					$query = "SELECT name, info FROM pois WHERE name = 'Union Station'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "SC":
					$query = "SELECT name, info FROM pois WHERE name = 'Staples Center'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
			}
			
			if (($_GET['name'])!= NULL) {
				echo "<table>\n";
				echo "<tr><th>Name</th><th>Beschreibung</th></tr>\n";
				while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) {
					echo "<tr>\n";
					foreach ($line as $col_value) {
						echo "\t<td>$col_value</td>\n";
					}
					echo "</tr>\n";
				}
				echo "</table>\n";
				mysql_free_result($result);
			}
			}
			mysql_close($db);
		?>
		
		<form method="get" action="">
			<div>
				<B><p class='submenue'>Bitte wählen Sie: </p></B>
				<input type="radio" name="name" value="USH" />Universal Studios Hollywood<br />
				<input type="radio" name="name" value="GO" />Griffith Observatorium<br />
				<input type="radio" name="name" value="GC" />Getty Center<br />
				<input type="radio" name="name" value="GV" />Getty Villa<br />
				<input type="radio" name="name" value="GCT" />Graumans Chinese Theatre<br />
				<input type="radio" name="name" value="HWF" />Hollywood Walk of Fame<br />
				<input type="radio" name="name" value="HS" />Hollywood Sign<br />
				<input type="radio" name="name" value="EPLA" />El Pueblo de Los Angeles<br />
				<input type="radio" name="name" value="MCA" />Museum of Contemporary Art<br />
				<input type="radio" name="name" value="MT" />Museum of Tolerance<br />
				<input type="radio" name="name" value="HM" />Hollywood Museum<br />
				<input type="radio" name="name" value="PAM" />Petersen Automotive Museum<br />
				<input type="radio" name="name" value="HRH" />Hollywood Roosevelt Hotel<br />
				<input type="radio" name="name" value="KT" />Kodak Theatre<br />
				<input type="radio" name="name" value="RD" />Rodeo Drive<br />
				<input type="radio" name="name" value="SS" />Sunset Strip<br />
				<input type="radio" name="name" value="TSP" />Third Street Promenade<br />
				<input type="radio" name="name" value="WDCH" />Walt Disney Concert Hall<br />
				<input type="radio" name="name" value="CLA" />Cathedral of our Lady of the Angels<br />
				<input type="radio" name="name" value="CRT" />Capitol Records Tower<br />
				<input type="radio" name="name" value="VB" />Venice Beach<br />
				<input type="radio" name="name" value="MB" />Malibu Beach<br />
				<input type="radio" name="name" value="GP" />Griffith Park<br />
				<input type="radio" name="name" value="PS" />Pershing Square<br />
				<input type="radio" name="name" value="US" />Union Station<br />
				<input type="radio" name="name" value="SC" />Staples Center<br /><br />
				<input type="submit" name="SUBMIT" value="Anzeigen" />
			</div>
		</form>
		</div>
	</body>
</html>