XML parsing using PHP

Question

I have a .out file which has xml content like this.

<header stub>
    <article type="audio">
        <addedDate>2010-03-11 05:11:57</addedDate>
        <thumbnail>http://fgsdfff/4588/thumbnail_9.jpg</thumbnail>
        <asset="blarga.mp3" addedDate="2009-01-07 01:48:37">
            <size>3289048</size>
            <duration>206000</duration>
            <mime_type>audio/mpeg</mime_type>
        </asset>
    </article>
</footer stub>

I have to add <?xml version="1.0"?> and </xml> at the start of the xml and at the end respectively.
I have to replace <header stub> and </footer stub> with <channel> and </channel> tags respectively.
You might have noticed the XML is not well formed in the <asset> tag. It has to be like <asset url="blarga.mp3" addedDate="2009-01-07 01:48:37">. How do I add the url attribute?
In the thumbnail tag, i have to remove _9 from the jpg's name.

And finally, i have to convert the .out to .xml file.

Please help me with these

That isn't XML content... at least, the sample you've given isn't — Endophage
– Endophage, Commented Jun 21, 2011 at 6:45
I strongly suggest to fix the .out file generator instead of hacking around the invalid XML in the results. — Gordon
– Gordon, Commented Jun 21, 2011 at 7:02
Not sure you'd want to have the closing </xml> tag at the end. There is no opening <xml> tag. — Tash Pemhiwa
– Tash Pemhiwa, Commented Jun 21, 2011 at 7:16

Francois Deschenes · Accepted Answer · 2011-06-21 07:00:55Z

1

$content = file_get_content OR mysql_query;//"YOUR XML CONTENT FROM FILE OR MYSQL";
$content = "<?xml version="1.0"?>" . $content . "</xml>";
$content = str_replace("<header stub>", "<channel>", $content);
$content = str_replace("</footer stub>", "</channel>", $content);
$content = str_replace("<asset=", "<asset url=", $content);
$content = str_replace("thumbnail_9.jpg", "thumbnail.jpg", $content);

edited Jun 21, 2011 at 7:00

Francois Deschenes

25.1k4 gold badges67 silver badges61 bronze badges

answered Jun 21, 2011 at 6:57

Pheonix

6,0627 gold badges32 silver badges48 bronze badges

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

Comments

Ozair Kafray · Accepted Answer · 2011-06-21 06:53:10Z

1

You can use DOMDocument class.

An example of its usage can be found here

edited Jun 21, 2011 at 6:53

answered Jun 21, 2011 at 6:47

Ozair Kafray

13.6k8 gold badges61 silver badges85 bronze badges

2 Comments

Tash Pemhiwa Over a year ago

I doubt that SimpleXML will be useful here because the content is not well-formed XML.

Ozair Kafray Over a year ago

Yes, I figured that out as the question changed. Have modified my answer too.

Collectives™ on Stack Overflow

XML parsing using PHP

2 Answers 2

Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related