initial commit

1 files changed, 32 insertions, 0 deletions

diff --git a/tableKML.php b/tableKML.php
new file mode 100644
index 0000000..d0daaae
--- /dev/null
+++ b/tableKML.php
@@ -0,0 +1,32 @@
+<?php
+include 'config.php';
+
+mysql_connect($host, $login, $pword) or die(mysql_error());
+mysql_select_db($db) or die(mysql_error());
+
+$table= $_GET['table'];
+
+$query='SELECT * FROM '.$table;
+$result = mysql_query($query);
+
+#http://stackoverflow.com/questions/1567758/best-way-to-use-jquerys-ajax-function-retrieve-variables-from-a-php-script
+
+echo "<?xml version='1.0' encoding='UTF-8'?>\n";
+echo "<kml xmlns=\'http://www.opengis.net/kml/2.2\'>\n";
+
+$n=mysql_numrows($result);
+$i=0;
+while ($i < $n) {
+	$T=mysql_fetch_array($result, MYSQL_ASSOC);
+	echo "<Placemark>\n";
+	echo "<name>".$T[name]."</name>\n";
+	echo "<Point>\n";
+        echo "<coordinates>".$T[lat].",".$T[lng].",0</coordinates>\n";
+	echo "</Point>\n";
+	echo "</Placemark>\n";
+	$i+=1;
+}
+mysql_close();
+
+echo "</kml>\n";
+?>