<!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("ml.txt");
		?>	
        	
     		<div class='data' style='overflow: scroll;'>
            <div class=" ">
    		<B><p class='menue'>Wo gibt es Parkplätze?</p></B><br />
			</div>
		
      
		<?php	
			
			if (array_key_exists('parking',$_GET)) {
				$parking =$_GET['parking'];	
				

				 if ($parking[0]=="F") { //Free Parking is chosen
					echo "An folgenden Haltestellen gibt es gebührenfreie Pakrplätze:<br /><br />\n";
					$query2 = "SELECT name, parking FROM stops WHERE parking='F' OR parking ='FC'";
					$result2 = mysql_query($query2) OR die("Fehler: ". mysql_error());
					echo "<table>\n";
					echo "\t<tr><th>Haltestelle</th></tr>\n";
					while ($object2 = mysql_fetch_object($result2)) {
						echo "\t<tr><td>$object2->name</td></tr>\n";
					}	
					echo "</table><br />\n";
					mysql_free_result($result2);
				} else if ($parking[0]=="C") { //Cost Parking is chosen
					echo "An folgenden Haltestellen gibt es gebührenpflichtige Parkplätze:<br /><br />\n";
					$query3 = "SELECT name, parking FROM stops WHERE parking='C' OR parking='FC'";
					$result3 = mysql_query($query3) OR die("Fehler: ". mysql_error());
					echo "<table>\n";
					echo "\t<tr><th>Haltestelle</th></tr>\n";
					while ($object3 = mysql_fetch_object($result3)) {
						echo "\t<tr><td>$object3->name</td></tr>\n";
					}	
					echo "</table><br />\n";
					mysql_free_result($result3);
				}
			}
			mysql_close($db);
		?>
		
	 	
		
		
		<form method="get" action="">
			<div>
				<B><p class="submenue">Bitte wählen Sie eine Optionen aus!</p></B>
				<input type="radio" name="parking[]" value="F" />gebührenfreies Parken<br />
				<input type="radio" name="parking[]" value="C" />gebührenpflichtiges Parken<br /><br />
				<input type="submit" name="SUBMIT" value="Anzeigen" />
			</div>
		</form>
		</div>
		
	</body>
</html>