Export array to XML file - problem with utf-8 encoding

Question

I want to export an array to XML file in PHP:

$fxml = fopen('file.xml', 'w');
$xml = new SimpleXMLElement('<postal_codes/>');

$rows = $db->query('SELECT * FROM postal_codes ORDER BY ID');

foreach ($rows as $row) {
  if ($provinces[$row['region']] == 'test') {
    $place = $xml->addChild('place');
    foreach($fields as $key => $val) {
      $place->addChild($val, $row[$val]);
    }
  }
}

fwrite($fxml, $xml->asXML());
fclose($fxml);

The data is exported, but the values don't contain Polish characters such as: ń, ś, ł, ó etc. How to fix this? Instead of correct characters, I have: ś ń ę

ThW · Accepted Answer · 2021-02-20 23:42:08Z

1

That is because you load an ASCII XML document. If you provide the UTF-8 encoding it will not encode the unicode characters.

$data = "Witaj świecie";

$xml = new SimpleXMLElement("<postal_codes/>");
$xml->addChild("place", $data);

echo $xml->asXML();

$xml = new SimpleXMLElement(
    "<?xml version='1.0' encoding='utf-8'?>\n<postal_codes/>"
);
$xml->addChild("place", $data);

echo $xml->asXML();

Output:

<?xml version="1.0"?>
<postal_codes><place>Witaj &#x15B;wiecie</place></postal_codes>
<?xml version="1.0" encoding="utf-8"?>
<postal_codes><place>Witaj świecie</place></postal_codes>

answered Feb 20, 2021 at 23:42

ThW

19.5k3 gold badges25 silver badges47 bronze badges

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

Collectives™ on Stack Overflow

Export array to XML file - problem with utf-8 encoding

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related