<!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 "AR":
					$query = "SELECT name, info FROM food WHERE name = 'Ago Restaurant'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "CR":
					$query = "SELECT name, info FROM food WHERE name = 'Campanile Restaurant'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "L":
					$query = "SELECT name, info FROM food WHERE name = 'Lucques'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "PM":
					$query = "SELECT name, info FROM food WHERE name = 'Pizzeria Mozza'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "DMR":
					$query = "SELECT name, info FROM food WHERE name = 'Dukes Malibu Restaurant'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "BBB":
					$query = "SELECT name, info FROM food WHERE name = 'Bar Barneys Beanery'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;	
				case "CBG":
					$query = "SELECT name, info FROM food WHERE name = 'Catalina Bar & Grill'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "EL":
					$query = "SELECT name, info FROM food WHERE name = 'Elevate Lounge'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "A":
					$query = "SELECT name, info FROM food WHERE name = 'Avalon'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "M":
					$query = "SELECT name, info FROM food WHERE name = 'Mood'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "VR":
					$query = "SELECT name, info FROM food WHERE name = 'Viper Room'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;
				case "WGG":
					$query = "SELECT name, info FROM food WHERE name = 'Whisky a Go Go'";
					$result = mysql_query($query) OR die("Fehler: ". mysql_error());
					break;	
				
			}
			
			if (isset($_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="AR" />Ago Restaurant<br />
				<input type="radio" name="name" value="CR" />Campanile Restaurant<br />
				<input type="radio" name="name" value="L" />Lucques<br />
				<input type="radio" name="name" value="PM" />Pizzeria Mozza<br />
				<input type="radio" name="name" value="DMR" />Dukes Malibu Restaurant<br />
				<input type="radio" name="name" value="BBB" />Bar Barneys Beanery<br />
				<input type="radio" name="name" value="CBG" />Catalina Bar & Grill<br />
				<input type="radio" name="name" value="EL" />Elevate Lounge<br />
				<input type="radio" name="name" value="A" />Avalon<br />
				<input type="radio" name="name" value="M" />Mood<br />
				<input type="radio" name="name" value="VR" />Viper Room<br />
				<input type="radio" name="name" value="WGG" />Whisky a Go Go<br />
				<br />
				<input type="submit" name="SUBMIT" value="Anzeigen" />
			</div>
		</form>
		</div>
	</body>
</html>