| <?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"; | |
| ?> | |