<!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 class='data' onload="load()" onunload="GUnload()" >
		
        <script
			src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=ABQIAAAAzosMcEBJXrsEQFGBQAWclRQgU1QyBe_kcGDWdfFXsq08_1MSqxREpHLDVDDm5p9ub3kwCQeYethC1w"
			type="text/javascript">
		</script>
		
	
		<?php 
		
			require_once("db_connection.php");

			$lat = "34.070862";
			$long = "-118.244476";
			$zoom = "11";
			
			if (array_key_exists('name',$_GET)) {
				$name = $_GET['name'];
				switch ( ($_GET['name'])) {
					case "Bars und Restaurants":
						$lat = "34.024908";
						$long = "-118.392846";
						$zoom = "11";
						$query1 ="SELECT lat, lon, name, address, website FROM food;";
						$result1 = mysql_query($query1) OR die("Fehler: ". mysql_error());
						break;
					case "Points of Interests":
						$lat = "34.024908";
						$long = "-118.362846";
						$zoom = "11";
						$query1 = "SELECT lat, lon, name, address, website FROM pois;";
						$result1 = mysql_query($query1) OR die("Fehler: ". mysql_error());
						break;
				}
				$rows = 'Ist';
				$cols = 'immer';
				$xobj[0] = 'noch';
				$xobj[1] = 'leer';
				if ( ($_GET['name'])!= NULL) {
					
					if ($result1) {
						$rows = mysql_num_rows($result1);
						$cols = mysql_num_fields($result1);
						for($r=0; $r< $rows; $r++) {
							$xobj[$r] = mysql_result($result1, $r, 0);
							$yobj[$r] = mysql_result($result1, $r, 1);
							$nobj[$r] = mysql_result($result1, $r, 2);
							$obj1[$r] = mysql_result($result1, $r, 3);
							$obj2[$r] = mysql_result($result1, $r, 4);
						}
					}
				}

				//create map
				echo '<script type="text/javascript">//<![CDATA['; 
				echo '/*'.$rows.' '.$cols.' '.$xobj[0].' '.$xobj[1].'*/';
				echo  '
					function load() {
						function createListener (marker, text) {
							GEvent.addListener(marker, "click", function() {
								marker.openInfoWindowHtml(text);
							});
						}
						if (GBrowserIsCompatible()) {
							var map = new GMap2(document.getElementById("map"));
							map.addControl(new GSmallMapControl());
							map.addControl(new GMapTypeControl());
							map.addControl(new GScaleControl());
							map.addControl(new GOverviewMapControl());
				'; 
				
				echo '
							map.setCenter(new GLatLng('.$lat.', '.$long.'), '.$zoom.');	  
							var point = new Array();
						'; 
				
				if ( ($_GET['name'])=="Bars und Restaurants") {
					$address="Adresse: ";
					$website="Website: ";
					
					//create marker for clubs
					echo '
						map.setCenter(new GLatLng('.$lat.', '.$long.'), '.$zoom.');
						var icon = new GIcon();
						icon.image = "./images/food.png";
						icon.iconSize = new GSize(20, 20);
						icon.iconAnchor = new GPoint(10, 10);
						icon.infoWindowAnchor = new GPoint(10, 10);
						var point = new Array();
						var text = new Array();
						var marker = new Array();
					'; 

					for ($r=0; $r<$rows; $r++) {
						echo '
							point['.$r.'] = new GLatLng('.$xobj[$r].','.$yobj[$r].');
							text['.$r.'] = "<b>'.$nobj[$r].'</b><br />'.$address,$obj1[$r].' €<br />'.$website,$obj2[$r].' €";
						';
					}
				}
				
				if ( ($_GET['name'])=="Points of Interests") {
					$address="Adresse: ";
					$website="Website: ";
						
					//create marker for pois
					echo '
						map.setCenter(new GLatLng('.$lat.', '.$long.'), '.$zoom.');
						var icon = new GIcon();
						icon.image = "./images/poi.png";
						icon.iconSize = new GSize(20, 20);
						icon.iconAnchor = new GPoint(10, 10);
						icon.infoWindowAnchor = new GPoint(10, 10);
						var point = new Array();
						var text = new Array();
						var marker = new Array();
					';
						
					for ($r=0; $r<$rows; $r++) {
						echo '
							point['.$r.'] = new GLatLng('.$xobj[$r].','.$yobj[$r].');
							text['.$r.'] = "<b>'.$nobj[$r].'</b><br />'.$address,$obj1[$r].'<br />'.$website,$obj2[$r].'";
						';
					}
				}
				
				//add marker to map
				echo '
					var marker = new Array();
					for (i=0; i< point.length; i++) {
						marker[i] = new GMarker(point[i],icon);
						map.addOverlay(marker[i]);
						createListener (marker[i], text[i]);
					}
				';
				
				echo '
						}
					}
					//]]></script>
				';
				mysql_free_result($result1);
				mysql_close($db);
			} else {
				echo '<script type="text/javascript">';
					echo '//<![CDATA[   
				function load() {
					if (GBrowserIsCompatible()) {
						var map = new GMap2(document.getElementById("map"));
						map.setCenter(new GLatLng(34.024908,-118.392846),10);
					}
				}
				';
				echo '
				//]]></script>
				';
			}
		?>
		
		<?php require_once("map.txt"); ?>
		<div class="data"><p class="menue">Wo befinden sich beliebte Bars/Restaurants bzw. Points of Interests?</p>
		<div id="map" style="width: 850px; height: 600px;"></div>
        
			<form method="get" action="">
				<div>
					<p class='submenue'>Bitte wählen Sie: </p>
					<input type="radio" name="name" value="Bars und Restaurants" />Bars und Restaurants<br />
					<input type="radio" name="name" value="Points of Interests" />Points of Interests<br /><br />
					<input type="submit" name="SUBMIT" value="Anzeigen" />
				</div>
			</form>
		</div>
	</body>
</html>