blob: d0daaae1363430f0594ce32dbcbd0a8179e2a340 (
plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
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";
?>
|
