From ce58f84fda93e6089caa5b724110dc7e01feddd1 Mon Sep 17 00:00:00 2001
From: Comment <tim@gray.(none)>
Date: Mon, 20 May 2013 21:43:30 +0100
Subject: tidying up

---
 tableKML.php | 31 +++++++++++++++++++++----------
 1 file changed, 21 insertions(+), 10 deletions(-)
 mode change 100644 => 100755 tableKML.php

(limited to 'tableKML.php')

diff --git a/tableKML.php b/tableKML.php
old mode 100644
new mode 100755
index d0daaae..1007f42
--- a/tableKML.php
+++ b/tableKML.php
@@ -1,4 +1,9 @@
+<?php //ini_set('display_errors','1');ini_set('display_startup_errors','1');error_reporting(E_ALL|E_STRICT); ?>
 <?php
+
+header("Content-Type: application/vnd.google-earth.kml+xml; charset=utf-8");
+//header("Content-Type: text/html; charset=utf-8");
+
 include 'config.php';
 
 mysql_connect($host, $login, $pword) or die(mysql_error());
@@ -11,22 +16,28 @@ $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";
+$output = '';
+$output .= "<?xml version='1.0' encoding='UTF-8'?>\n";
+$output .= "<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;
+	$output .= "<Placemark>\n";
+	$output .= "<name>".str_replace('&', '&amp;', $T['name'])."</name>\n";
+	$output .= "<Point>\n";
+        $output .= "<coordinates>".$T['lat'].",".$T['lng'].",0</coordinates>\n";
+	$output .= "</Point>\n";
+	$output .= "</Placemark>\n";
+	$i +=1;
+
 }
 mysql_close();
 
-echo "</kml>\n";
+$output .= "</kml>\n";
+
+echo $output;
+
 ?>
-- 
cgit v1.2.3