How to parse xml with

Question

I have a xml feed that looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<books version="1.0">
<book>
<NR><![CDATA[1]]></NR>
<title><![CDATA[somebook]]></title>
<picture><![CDATA[http://www.website.com/images/somebook_pic.jpg]]></picture>
</book>
</books>

And a php loop that is not working:

<?php
$file = "books.php";
$html = "";
$url = "http://www.website.com/feed/feed.xml";
$xml = simplexml_load_file($url);
for($i = 0; $i < 10; $i++){
$number = $xml->book[$i]->NR;
$img = $xml->book[$i]->picture;
$title = $xml->book[$i]->title;
$html .= "<img src=\"$img\">$title - $number</a>";
}
file_put_contents($file, $html);
?>

It was working when that XML feed was without ![CDATA[, unfortunately they change it (I do not know why) and now it's not working.

XML feed update:

<?xml version="1.0" encoding="UTF-8"?>
<books version="1.4">
<category name="science-fiction">

<book>
<NR><![CDATA[1]]></NR>
<title><![CDATA[somebook]]></title>
<picture><![CDATA[http://www.website.com/images/somebook_pic.jpg]]></picture>
</book>

<book>
<NR><![CDATA[2]]></NR>
<title><![CDATA[somebook2]]></title>
<picture><![CDATA[http://www.website.com/images/somebook2_pic.jpg]]></picture>
</book>

</category>
</books>

I've tried your code and it works okay for the first item; why don't you just iterate `$xml->book` instead of doing an arbitrary loop of 10? — Ja͢ck, Dec 03 '14 at 04:50
I do not have experiences in php and unfortunately its not working for me, but thanks for answer anyway :( — Belhor, Dec 03 '14 at 05:03
I have update the xml file. First version was created wrong. — Belhor, Dec 03 '14 at 05:22

score 0 · Accepted Answer · answered Dec 03 '14 at 05:28

You're not iterating over the <category> element; this should work:

$books = simplexml_load_string($xml);

$html = '';

foreach ($books->category->book as $book) {
    $html .= sprintf('<img src="%s">%s - %s</a>',
      htmlspecialchars($book->picture, ENT_QUOTES, 'UTF-8'),
      htmlspecialchars($book->title, ENT_QUOTES, 'UTF-8'),
      htmlspecialchars($book->NR, ENT_QUOTES, 'UTF-8')
    );
}

echo $html, PHP_EOL;

Demo

How to parse xml with

1 Answers1