Extract some CDATA from a xml file with PHP

Question

I've to extract some data from a xml file. In this file there are some tags that contains CDATA content and I don't try to extract this contents.

The file is like this:

<treeplat>
<ad>
<id>965192-VR</id>
<region>VT</region>
<description>
<![CDATA[
Orte scalo. Vicinissimo alla stazione, in zona tranquilla e panoramica, proponiamo appartamento di recente costruzione così composto: ingresso, salone con ampio angolo cottura e balcone, disimpegno, camera matrimoniale con balcone, cantina e posto auto.
]]>
</description>
<pictures>
<picture>
<picture_url>
<![CDATA[
http://www.immobile.net/media/foto/1440/9f352078-885d-4281-a36d-1d22b3cbdcd9-x.jpg
]]>
</picture_url>
</picture>
<picture>
<picture_url>
<![CDATA[
http://www.immobile.net/media/foto/1440/992a5c0f-62dd-48f2-8c41-9b8ee9e06ca9-x.jpg
]]>
</picture_url>
</picture>
<picture>
<picture_url>
<![CDATA[
http://www.immobile.net/media/foto/1440/a61b4705-ed0a-494b-86fc-e92bb4c916e7-x.jpg
]]>
</picture_url>
</picture>
<picture>
<picture_url>
<![CDATA[
http://www.immobile.net/media/foto/1440/d1817d53-51fa-43dc-baf9-d3457963e694-x.jpg
]]>
</picture_url>
</picture>
<picture>
<picture_url>
<![CDATA[
http://www.immobile.net/media/foto/1440/8299cd3e-f253-4c83-9629-fb77131a2efb-x.jpg
]]>
</picture_url>
</picture>
</pictures>
</ad>
</treeplat>

I parse the xml file in this way:

$xml = simplexml_load_file(storage_path('app'.DIRECTORY_SEPARATOR.'public'.DIRECTORY_SEPARATOR.$percorso_file.'test.xml')); 
foreach ($xml->ad as $immobile) {
...
}

My problem is tag. I try to extract the first only using this code:

$picture_url_1 = (string)$immobile->pictures->picture->picture_url

but I don't try to extract every picture_url.

How can I parse all the pictures tag?

Many thank's!

gilad905 · Accepted Answer · 2019-05-06 14:31:37Z

1

you are looping over the wrong variable. what you need is:

$pictures = $xml->ad->pictures->picture;
foreach ($pictures as $picture) {
    echo $picture->picture_url;
}

(you can replace echo with whatever command you need)

edited May 6, 2019 at 14:31

answered May 6, 2019 at 14:06

gilad905

3,2373 gold badges20 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Chris White · Accepted Answer · 2019-05-06 14:29:00Z

0

Gilad almost had it!

$pictures = $xmlData->ad->pictures;
foreach($pictures as $picture)
{
   foreach($picture as $pic)
   {
      echo (string) $pic->picture_url;
   }
}

https://3v4l.org/990NR

answered May 6, 2019 at 14:29

Chris White

1,0736 silver badges11 bronze badges

1 Comment

gilad905 Over a year ago

this will work although the first foreach is actually not needed.. see my edited answer

Collectives™ on Stack Overflow

Extract some CDATA from a xml file with PHP

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related