PHP和MySql生成KML

Question

I'm trying to make a dynamic KML from a PHP using this Article, but I already have the values of my Polygons and some of them are Multiple Polygons. I decided to put this values on a Database so I just have to query them and put it on the kml, but when a try to use it it returns this:

<Polygon><extrude>1</extrude>     <tessellate>1</tessellate><outerBoundaryIs><LinearRing>
<coordinates>

Instead of:

<Polygon>
<extrude>1<extrude>
<tessallete>.... etc

Here's how I'm trying to put this info:

$multiGeometryNode = $dom->createElement('MultiGeometry', htmlspecialchars($row['kml']));

Any ideas? By the way, if I use a echo to show htmlspecialchars($row['kml']) it works, but when I try to use it in the createElement it doesn't.

Answer 1

It appears that I misread what you were doing.

Try

$multiGeometryNode = $dom->createElement('MultiGeometry', $row['kml']);

instead of

$multiGeometryNode = $dom->createElement('MultiGeometry', htmlspecialchars($row['kml']));

The htmlspecialchars() function escapes all of the html characters. So your < signs were becoming < however they were being rendered as < in the browser.