<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
       "http://www.w3.org/TR/html4/loose.dtd">
<?php
require_once('mysql.inc.php');
echo "<head>";
echo "<title>Auswahl einer Linie und Anzeige in GM</title>";
echo "<meta http-equiv='Content-Type' content='text/html; charset=utf-8'>";
echo '
<script src="http://maps.google.com/maps?file=api&amp;v=2&amp;key=ABQIAAAAzosMcEBJXrsEQFGBQAWclRQgU1QyBe_kcGDWdfFXsq08_1MSqxREpHLDVDDm5p9ub3kwCQeYethC1w"
type="text/javascript">
</script>
';
echo "</head>";
echo '<body onload="load()" onunload="GUnload()">';
echo "<h2>Auswahl einer Linie und Anzeige in GM</h2>";
echo "<form action='' method ='post'>";
echo "<select name='umfrage'>";
mysqli_select_db($dz, 'goettingen');
$sql = mysqli_query($dz, "SELECT DISTINCT idline FROM statline");
while ($ds = mysqli_fetch_object($sql)){
  $number = $ds -> idline;
/*  $id	  = $ds -> id;*/
  $idline[]=$number;
  }
$anzahl = count($idline);
for ($i = 0; $i < $anzahl; $i++){
  echo "<option value=\"$i\">$idline[$i]</option>";
  }
echo "</select>";
echo "	<input type='submit' value='Ausw&auml;hlen'>";
echo "</form>";
if (array_key_exists('umfrage',$_POST)) {
$line= $idline[$_POST['umfrage']];
} else {
	$line ='';
}
$query="
SELECT name AS 'Haltestelle', ridesequence AS 'Reihenfolge',r,h
FROM stations, statline
WHERE statline.idline = '". mysqli_real_escape_string($dz, $line) ."'
AND stations.id = statline.idstations 
ORDER BY statline.ridesequence ASC;";
$result=mysqli_query($dz, $query);
if ($line != ""){
  echo "Sie haben folgende Linie gew&auml;hlt : $line<br>";
  $rows = mysqli_num_rows($result);
  $cols = mysqli_num_fields($result);
  for($r=0; $r< $rows; $r++){
	 list($nobj[$r], $noop, $xobj[$r], $yobj[$r]) = mysqli_fetch_row($result);
    }
include './gaussk.php';
for($r=0; $r< $rows; $r++){
  $xin=$xobj[$r];
  $yin=$yobj[$r];
  $wgs84array = CalcStart($xin, $yin);
  $xobj[$r] = $wgs84array[0];
  $yobj[$r] = $wgs84array[1];
  }
$zoom = "15";
mysqli_free_result($result);
echo '<script type="text/javascript">';
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 GLargeMapControl());
  map.addControl(new GMapTypeControl());
  map.addControl(new GScaleControl());
  map.addControl(new GOverviewMapControl());
  ';
  echo '
  map.setCenter(new GLatLng('.$xobj[0].', '.$yobj[0].'), '.$zoom.', G_SATELLITE_MAP);
  var point = new Array();
  var text = new Array();
  var marker = new Array();
  var lineData = [];
  ';
  for ($r=0; $r<$rows; $r++){
    echo '
    point['.$r.'] = new GLatLng('.$xobj[$r].','.$yobj[$r].');
    text['.$r.'] = "'.$nobj[$r].'";
	lineData.push(new GLatLng('.$xobj[$r].','.$yobj[$r].'));
    ';
    }
  echo '
  var marker = new Array();
  for (i=0; i< point.length; i++){
    marker[i] = new GMarker(point[i]);
    map.addOverlay(marker[i]);
    createListener (marker[i], text[i]);
    map.addOverlay(new GPolyline(lineData, "#ffffff", 10, .75));
    }
  ';
  echo '
  }
}
</script>
';
  }  
echo '
<div id="map" style="width:780px;height:320px"></div>
';
echo "</body>";
?>
