Parsing XML by PHP

[ladinek111]

Hello
Here is my problem:
I am reading data from MySQL DB like this:

<polygons>
  <polygon name="Polygon11" address="London" latlng="49.837 17.992,49.828 18.055,49.840 18.063,49.837 18.024" /> 
  <polygon name="Polygon21" address="Berlin" latlng="49.828 18.023,49.830 18.058,49.842 18.047,49.839 18.027,49.828 18.023" /> 

I need data like this:

<polygons>
-  <polygon name="Polygon11" address="London" >
     <point lat="49.837" lng="17.992" /> 
     <point lat="49.828 " lng="18.055" /> 
     <point lat="49.840 " lng="18.063" /> 
     <point lat="49.837" lng="17.992" />
  </polygon>
  <polygon name="Polygon21" address="Berlin" >
     <point lat="49.837" lng="17.992" /> 
     <point lat="49.828 " lng="18.055" /> 
     <point lat="49.840 " lng="18.063" /> 
     <point lat="49.837" lng="17.992" />
  </polygon>
</polygons>

I try something with explode function, but it isn't work. Please Help. thank's

[dagon]

you should use the Document Object Model functions

[Weedpacket]

There is also [man]XSL[/man] which is designed for this sort of thing; but it probably would be overkill (you'd spend all your time with writing an XSL function to mimic PHP's explode).

As dagon suggests, the [man]DOM[/man] would be the appropriate course to take. For each <polygon> element in the document you'd read its latlng= attribute into a PHP string (then remove it from the <polygon> element). Use explode, follow it with [man]array_chunk[/man], and you'd have an array of lat/lng pairs. If you have any work to do adjusting that list of pairs (sorting, filtering, etc.) then now would be the time to do it. It would then be a trivial matter to iterate over that array and append <point> elements to the current <polygon>.