<?php
header('Content-Type: application/vnd.google-earth.kml+xml');
echo '<?xml version="1.0" encoding="UTF-8"?>
<kml xmlns="http://www.opengis.net/kml/2.2"><Document>';
echo '<Style id="target">
  <IconStyle>
    <Icon>
      <href>http://maps.google.com/mapfiles/kml/pushpin/ylw-pushpin.png</href>
    </Icon>
  </IconStyle>
        </Style>';
echo '<Style id="player">
  <IconStyle>
    <Icon>
      <href>http://maps.google.com/mapfiles/kml/pushpin/grn-pushpin.png</href>
    </Icon>
  </IconStyle>
        </Style>';
$conn = pg_connect("dbname=openstreetmap user=postgres password=snmc");
if (!$conn) {
  echo "An error occured.\n";
  exit;
}
/*SELECT * from current_node_tags, (Select id FROM current_node_tags WHERE  "v" LIKE '%bus%') as a
where a.id = current_node_tags.id; */
$result_stops = pg_query($conn, "Select * FROM current_node_tags INNER JOIN current_nodes ON 
current_node_tags.id=current_nodes.id WHERE v LIKE '%bus%' ");
if (!$result_stops) {
  echo "An stops retirieve error occured.\n";
  exit;
}
 
while ($stop = pg_fetch_assoc($result_stops)) {
 echo "\n<Placemark>\n";
 echo "<description>";
$result_stopkeys = pg_query($conn, "SELECT * from current_node_tags where id = {$stop['id']};");
if (!$result_stopkeys) {
  echo "An stops keys retirieve error occured.\n";
  exit;
}
$name = "";
while ($stopkeys = pg_fetch_assoc($result_stopkeys)) {
echo htmlspecialchars(print_r($stopkeys,true));
$name .= htmlspecialchars($stopkeys['v']);
}
echo "</description>";
 echo "<name>$name</name>";
 
echo "<styleUrl>#target</styleUrl>";
echo "\n   <Point><coordinates> ";
                echo ($stop['longitude']/10000000).",".($stop['latitude']/10000000)."\n";
echo "        </coordinates> </Point>";
echo '</Placemark>';
}
 
echo "\n</Document></kml>\n";
?>