Parsing an XML file

Admin · Dec 15, 2013

If anyone is good with parsing XML files I need some help, the source file contains;

<![CDATA[
good data<br/>
good data too<br/>
not needed data
]]>

How do I read the first 2 lines into MySql but not the 3rd?

Many thanks

Admin

Jamie101 · Dec 15, 2013

admin said:
If anyone is good with parsing XML files I need some help, the source file contains;

<![CDATA[
good data<br/>
good data too<br/>
not needed data
]]>

How do I read the first 2 lines into MySql but not the 3rd?

Many thanks

Admin

Do you know any java? That's what I'd probably use if I were to do that.

Would offer to give you a hand with it but I've been coding all day and need a break!

Sent from my GT-I9300 using Tapatalk 2

Admin · Dec 15, 2013

Not a clue with Java but thanks anyway... and I know the feeling!

Coffee time ..

noonoo1 · Dec 15, 2013

I might be able to help Admin, pm me.

Just finished a load of xml parsing on my latest project.

noonoo1 · Dec 16, 2013

Hi Admin,

PM sent with working code.

Cheers

DaveP · Dec 16, 2013

If using PHP it would be something like this.

PHP:

<?php

$xml_string = <<<XML
<?xml version="1.0"?>
<root>
   <item>
       <![CDATA[good data<br/>good data too<br/>not needed data]]>
   </item>
</root>
XML;

$xml = simplexml_load_string($xml_string);

foreach($xml->item as $item) {
   // The last parameter is the lines you want + 1 (so for 2 lines it's 3)
   $chunks = explode('<br/>', $item, 3);
   $good_data = array($chunks[0], $chunks[1]);
   print_r($good_data);
}

?>

Just put your $good_data into your database.

You can test the above here: http://writecodeonline.com/php/

noonoo1 · Dec 16, 2013

The code I pmed over was php.
Cheers

DaveP said:

If using PHP it would be something like this.

PHP:

<?php

$xml_string = <<<XML
<?xml version="1.0"?>
<root>
   <item>
       <![CDATA[good data<br/>good data too<br/>not needed data]]>
   </item>
</root>
XML;

$xml = simplexml_load_string($xml_string);

foreach($xml->item as $item) {
   // The last parameter is the lines you want + 1 (so for 2 lines it's 3)
   $chunks = explode('<br/>', $item, 3);
   $good_data = array($chunks[0], $chunks[1]);
   print_r($good_data);
}

?>

Just put your $good_data into your database.

You can test the above here: http://writecodeonline.com/php/