<!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">
		<p class="menue">Webadressen ausgesuchter Bars und Restaurants</p><br />
	
		<?php
			if (array_key_exists('array',$_GET)) {
				$array=$_GET['array'];
			
				$query = 'SELECT name, website FROM food WHERE ';
				$flag = false; 

				foreach($array as $value) {
					if($flag) $query .= 'OR ';
					$query .= "name='$value' ";
					$flag = true;
				}
				$query .= "ORDER BY name; ";
				$result = mysql_query($query) OR die("Fehler: ". mysql_error());
				echo "<table>\n";
				echo "\t<tr><th>Bar / Restaurant</th><th>Webadresse</th></tr>\n";
				while ($object = mysql_fetch_object($result)) {
					echo "\t<tr><td>$object->name</td><td>$object->website</td></tr>\n";
				}
				mysql_free_result($result);
				echo "</table>\n";
			}

			echo "<form action='' method='get'><div>";
			echo "<p class='submenue'>Bitte wählen Sie mindestens eine Option! </p>\n";
			$query = "SELECT DISTINCT name FROM food ORDER BY name";
			$ergebnis = mysql_query($query) or die ("Fehler! ".mysql_error());
			while ($row = mysql_fetch_object($ergebnis)) {
				$name=$row->name;
				echo "\t<input type='hidden' name='sent_form1' value='true' />\n";
				echo "\t<input type='checkbox' name='array[]' value='$name' /> $name <br />\n";
			}
			echo "<br />\n";
			echo "\t<input type='submit' value='Anzeigen'/>\n";
			mysql_free_result($ergebnis);
			echo "</div></form>\n";
			mysql_close($db);
		?>
		</div>
	</body>
</html>
