Add attribute to child node XML using PHP

Question

I'm struggling to append an child node within an XML file with a static unique ID.

The XML feed I'm working with is hosted on a server elsewhere and can only be accessed via its URL.

Said feed follows this sort of pattern:

<?xml version="1.0" encoding="UTF-8"?>
<properties>
    <property>
        <title>Some Sunny Place</title>
        <address>Some Building, Somewhere, Really Nice</address>
    </property>
    <property>
        <title>Some Rainy PLace Place</title>
        <address>Some Gutter, Somewhere, Not So Nice</address>
    </property>
</properties>

What I'm trying to achieve is using the URL from the feed is add a unique id to the 'property' node and output the XML feed at an alternate URL.

e.g. example.com/proeprty-feed contains feed without ID. Add the ID using PHP and output the feed to something.com/property-feed

<?xml version="1.0" encoding="UTF-8"?>
<properties>
    <property upid=123456>
        <title>Some Sunny Place</title>
        <address>Some Building, Somewhere, Really Nice</address>
    </property>
    <property upid=abcdef>
        <title>Some Rainy PLace Place</title>
        <address>Some Gutter, Somewhere, Not So Nice</address>
    </property>
</properties>

What I have tried is input.php

<?php
$xmlstr = <<<XML
<?xml version="1.0" encoding="UTF-8"?>
<properties>
    <property>
        <title>Some Sunny Place</title>
        <address>Some Building, Somewhere, Really Nice</address>
    </property>
    <property>
        <title>Some Rainy PLace Place</title>
        <address>Some Gutter, Somewhere, Not So Nice</address>
    </property>
</properties>
XML;
?>

And output.php

<?php

include 'input.php';

$sxe = new SimpleXMLElement($xmlstr);
$sxe->addAttribute('upid', uniqid('prop-'));

echo $sxe->asXML();

?>

But this outputs:

<properties upid="prop-5ac7c06a39ddd">
    <property>
        <title>Some Sunny Place</title>
        <address>Some Building, Somewhere, Really Nice</address>
    </property>
    <property>
        <title>Some Rainy PLace Place</title>
        <address>Some Gutter, Somewhere, Not So Nice</address>
    </property>
</properties>

Please post the code you have so far and describe what isn't working. — Alex Howansky
– Alex Howansky, Commented Apr 6, 2018 at 17:00

user9189147 · Accepted Answer · 2018-04-06 17:56:12Z

3

Something along the lines of this:

<?php

$string = '<?xml version="1.0" encoding="UTF-8"?>
<properties>
    <property>
        <title>Some Sunny Place</title>
        <address>Some Building, Somewhere, Really Nice</address>
    </property>
    <property>
        <title>Some Rainy PLace Place</title>
        <address>Some Gutter, Somewhere, Not So Nice</address>
    </property>
</properties>';
$xml = new SimpleXMLElement($string);

for($i = 0; $i < count($xml -> property); $i++) {
    $xml -> property[$i] -> addAttribute('upid', uniqid());
}
header('Content-Type: text/xml');
print $xml -> asXml();

edited Apr 6, 2018 at 17:56

answered Apr 6, 2018 at 17:50

user9189147

2961 silver badge7 bronze badges

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

6 Comments

Dave Pearce Over a year ago

Sweet! Thanks for the help. How do I apply this to an XML feed that is available via a third party URL g.g. example.com/property-feed I had looked at adding more_entropy, but couldn't get past adding the ID to the child node.

user9189147 Over a year ago

I am not sure of your particular use case. What are you trying to do with the XML from the external server? Is this some that is loaded frequently, one time, etc... Give some more details and I'd be happy to respond.

Dave Pearce Over a year ago

Basically, I'm given an XML feed from a third party server, which I have permission for using. It contains approximately 4,000 properties. But none of the properties have any ID. I'm wanting to use my server, to add the ID and then I can export the XML feed from my server with the ID. This use is permitted. I have revised my question if it lends any further insight.

user9189147 Over a year ago

You could grab the file, update the xml using the code below, and then save the string to a file on your local server. See CURL, or file_get_contents, to grab the external file. See file_put_contents, or fopen -> fwrite -> fclose. See: stackoverflow.com/questions/26876446/…

Dave Pearce Over a year ago

No need to use cURL. opted for simplexml_load_file and combined it with your snippet.

<?php  $xml=simplexml_load_file("https://example.com/properties");  for($i = 0; $i < count($xml -> property); $i++) {     $xml -> property[$i] -> addAttribute('upid', uniqid('upid-')); }  header('Content-Type: text/xml'); print $xml -> asXml();

|

Jubei · Accepted Answer · 2018-04-06 18:36:40Z

0

<?php
$xml = '<?xml version="1.0" encoding="UTF-8"?>
<properties>
    <property>
        <title>Some Sunny Place</title>
        <address>Some Building, Somewhere, Really Nice</address>
    </property>
    <property>
        <title>Some Rainy PLace Place</title>
        <address>Some Gutter, Somewhere, Not So Nice</address>
    </property>
</properties>';

$length = strlen('<property>');

while ($pos = strpos($xml, '<property>')) {
    $xml = substr_replace($xml, '<property upid=' . uniqid() . '>', $pos, $length);
    usleep(10); // Necessary so uniqid() is unique every iteration, it's kind of a hack not sure if it's the best solution
}

var_dump($xml);

answered Apr 6, 2018 at 18:36

Jubei

1,2401 gold badge10 silver badges14 bronze badges

3 Comments

Parfait Over a year ago

Are we treating XMLs as text string? Reconsider using DOM methods.

Parfait Over a year ago

XML is a structured, markup file that adheres to W3C standards. It can contain entity references, unicode, and binary data that may be hard to consume or needs to be escaped with string functions. While this example looks simple, OP omitted actual content.

Dave Pearce Over a year ago

The XML feed that I've got to work with contains more than 4,000 properties, each with their own children. I'm afraid I don't follow DOM. I did have a look, but I'm brand new to using PHP with XML. In short, The answers above add the ID to the static XML content, but I want to be able to do this on the fly using a URL. Someone suggested cURL, but I don't know how I can get the XML URL into a string like the posts above.

Collectives™ on Stack Overflow

Add attribute to child node XML using PHP

2 Answers 2

6 Comments

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

6 Comments

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related