How to load xml file with php when CDATA isn't valid

Question

I'm developing a website and I need to load an xml file- let's say test.xml

XML nodes are well-formated, but values inside of them aren't. Value of every node is CDATA nested string (but CDATA isn't always well-formated). Example:

<root>
 <data>
   <value1><![CDATA[Some value]]></value1>
   <value2><![CDATA[ ]]></value2>
   <value3>![CDATA[  ]]></value3>
 </data>
</root>

Original XML structure is more complex, but this is the example of CDATA usage. In node value3, CDATA isn't valid (missing '<' character before '![CDATA').

I've tried to load the file with following code

<?php
  $xml = simplexml_load_file("test.xml"); 
?>

but I was getting warnings.

Then I've tried to use LIBXML_NOCDATA, but it wasn't improved. The second code I've tried was:

<?php
  $xml = simplexml_load_file("test.xml", null, LIBXML_NOCDATA); 
  //$xml = simplexml_load_file("test.xml", 'SimpleXMLElement', LIBXML_NOCDATA); 
?>

but still with warnings (with both lines).

Is it possible to load file and then parse it (e.g $xml->data->value3) or not?

LIBXML_NOCDATA is not a magic bullet, and contrary to persistent myths, it is actually pretty useless with SimpleXML, because SimpleXML handles CDATA rather nicely by itself. I explained a bit about what it does here: stackoverflow.com/a/13981917/157957 Your problem is much more mundane: you have broken XML; the fact that the broken bits should be CDATA sections doesn't help, because they're broken, so they're not. — IMSoP
– IMSoP, Commented May 5, 2014 at 1:29

Pavel Dubenko · Accepted Answer · 2014-05-04 21:08:13Z

0

This is not valid XML file

So you should repair it before usage The simplest way - is to use Tidy lib included in PHP

<?php
error_reporting(E_ALL);
$file = '1.xml';

$tidy = new tidy();
$repaired = $tidy->repairfile($file, array(
    'input-xml' => true,
    'escape-cdata' => false
));
var_dump(simplexml_load_string($repaired));

answered May 4, 2014 at 21:08

Pavel Dubenko

914 bronze badges

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

Comments

Michael Kay · Accepted Answer · 2014-05-04 23:08:55Z

0

If you're getting bad XML the right approach is always to find out why, and eliminate the root cause. If it's a data feed over which you genuinely have no control, seriously consider not using it: if the quality is so poor, is the data really worth having?

answered May 4, 2014 at 23:08

Michael Kay

165k11 gold badges97 silver badges173 bronze badges

Collectives™ on Stack Overflow

How to load xml file with php when CDATA isn't valid

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related