Failed loading XML:xmlParseCharRef: invalid xmlChar value

Question

When I try to Import xml file, it returns an error:

xmlParseCharRef: invalid xmlChar value 4" because of $amp; in xml <STOCKGROUP >NAME="ABC & Glass" RESERVEDNAME="">

Here is code I'm using to read xml file data

function add_product_type()
{
    print_r($_FILES);
    if (isset($_FILES['product_type_file']) && ($_FILES['product_type_file']['error'] == UPLOAD_ERR_OK)) {
        $use_errors = libxml_use_internal_errors(true);
        $response = simplexml_load_file($_FILES['product_type_file']['tmp_name']);
        print_r($response);
        foreach($response->BODY->IMPORTDATA as $key => $value) {
            foreach($value->REQUESTDATA->TALLYMESSAGE as $key => $values) {
                if (strstr("&amp;", $values->STOCKGROUP->attributes())) {
                    $name = str_replace("&amp;", "&", $values->STOCKGROUP->attributes());
                }
                else {
                    $name = $values->STOCKGROUP->attributes();
                }

                echo $name . ",";
            }
        }

        if ($response == false) {
            echo "Failed loading XML\n";
            foreach(libxml_get_errors() as $error) {
                echo "\t", $error->message;
            }
        }
    }
}

IT sounds like the XML you're trying to read has a syntax error. Can you post an example document? — sba
– sba, Commented Feb 28, 2018 at 9:09
No, post a complete example of the XML data you're trying to parse. The XML in the error message looks very broken, but since it's a fragment it's not possible to tell. — sba
– sba, Commented Feb 28, 2018 at 9:18
drive.google.com/file/d/16aI_-TE3TGb6N4K58mA2w9I3DLiuyeFQ/… — Mitesh Golwala
– Mitesh Golwala, Commented Feb 28, 2018 at 9:30

sba · Accepted Answer · 2018-02-28 09:42:42Z

1

XML has no notion of HTML entities. As a hack, you can decode the entities first with

$html = html_entity_decode($file_contents, ENT_QUOTES, "utf-8");

and then try parse $html with the XML parser. Just hope it's tolerant enough, because HTML is still not valid XML.

The good news is that you can then remove the if (strstr("&", hack because that is taken care of by html_entity_decode().

answered Feb 28, 2018 at 9:42

sba

2,18721 silver badges31 bronze badges

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

Comments

Nigel Ren · Accepted Answer · 2018-02-28 10:05:54Z

0

Your XML sample isn't the same data as your getting the error with and processes OK, but this doesn't mean that your code is correct. In your main loop, you use $values->STOCKGROUP->attributes() as the name, but if you did a print_r() of this value, you will see it comes out with a list of all of the attribute values and your code will combine them all into one string.

SimpleXMLElement Object
(
    [@attributes] => Array
        (
            [NAME] => Alluminium Section & Glass
            [RESERVEDNAME] => 
        )

)

If you just want the NAME attribute of <STOCKGROUP NAME="Alluminium Section & Glass" RESERVEDNAME="">, then use STOCKGROUP['NAME']. Also rather than just substitute &, use html_entity_decode() to convert any characters in the name.

foreach($response->BODY->IMPORTDATA as $key => $value) {
    foreach($value->REQUESTDATA->TALLYMESSAGE as $key => $values) {
        $name = html_entity_decode((string)$values->STOCKGROUP['NAME']);    
        echo $name . ",";
    }
}

This code with the sample you provide outputs...

Alluminium Section & Glass,

Update: Check the file being loaded...

$data = file_get_contents($_FILES['product_type_file']['tmp_name']);
echo $data;
$use_errors = libxml_use_internal_errors(true);
$response = simplexml_load_string($data);
echo $response->asXML();

edited Feb 28, 2018 at 10:05

answered Feb 28, 2018 at 9:43

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

14 Comments

Mitesh Golwala Over a year ago

print_r($response) How to print SimpleXMLElement Object ( [@attributes] => Array ( [NAME] => Alluminium Section & Glass [RESERVEDNAME] => ) )

Nigel Ren Over a year ago

If you want to print a SimpleXMLElement - use echo $response->asXML();

Mitesh Golwala Over a year ago

when i use echo $response->asXML(); => give me this error ->Call to a member function asXML() on boolean in

Nigel Ren Over a year ago

This means the XML isn't correct - BUT the sample data you gave works, so this either isn't the same data or isn't the complete data.

Mitesh Golwala Over a year ago

This is my xml file link you can use => drive.google.com/file/d/16aI_-TE3TGb6N4K58mA2w9I3DLiuyeFQ/…

|

Collectives™ on Stack Overflow

Failed loading XML:xmlParseCharRef: invalid xmlChar value

2 Answers 2

Comments

14 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

14 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related