Ad:

PHP Discussion Thread
Unsolved
Views: 3733

Aug 12th, 2009

Updating XML nodes using SimpleXML adds extra node

Expand Post »

I have a very simple script that basically searches an xml file for a node based on the id of another node. I then update the node I found with a new value. For some reason my code is not performing the update. It is actually creating another node within the existing node. Any idea why?

XML:

PHP Syntax (Toggle Plain Text)
 
  <?xml version="1.0" encoding="UTF-8" ?> 
- <users>
- <user>
  <id>1</id> 
  <firstname>Bob</firstname> 
  <lastname>Marley</lastname> 
  </user>
- <user>
  <id>2</id> 
  <firstname>Bruce</firstname> 
  <lastname>Springsteen</lastname> 
  </user>
  </users>
  <?xml version="1.0" encoding="UTF-8" ?> 
- <users>
- <user>
  <id>1</id> 
  <firstname>Bob</firstname> 
  <lastname>Marley</lastname> 
  </user>
- <user>
  <id>2</id> 
  <firstname>Bruce</firstname> 
  <lastname>Springsteen</lastname> 
  </user>
  </users>

PHP Code:

PHP Syntax (Toggle Plain Text)
 
<?php
 
$file = "officedata.xml";
 
$xml=simplexml_load_file($file);
 
foreach ($xml->xpath('//user[id="2"]/lastname') as $desc) {
echo "$desc\n";
$desc->lastname = "Penner"; 
}
 
file_put_contents($file, $xml->asXML()); 
 
?>
<?php

$file = "officedata.xml";

$xml=simplexml_load_file($file);

foreach ($xml->xpath('//user[id="2"]/lastname') as $desc) {
echo "$desc\n";
$desc->lastname = "Penner"; 
}

file_put_contents($file, $xml->asXML()); 

?>

The updated XML looks like this:

PHP Syntax (Toggle Plain Text)
 
  <?xml version="1.0" encoding="UTF-8" ?> 
- <users>
- <user>
  <id>1</id> 
  <firstname>Bob</firstname> 
  <lastname>Marley</lastname> 
  </user>
- <user>
  <id>2</id> 
  <firstname>Bruce</firstname> 
- <lastname>
  Springsteen 
  <lastname>Penner</lastname> 
  </lastname>
  </user>
  </users>
  <?xml version="1.0" encoding="UTF-8" ?> 
- <users>
- <user>
  <id>1</id> 
  <firstname>Bob</firstname> 
  <lastname>Marley</lastname> 
  </user>
- <user>
  <id>2</id> 
  <firstname>Bruce</firstname> 
- <lastname>
  Springsteen 
  <lastname>Penner</lastname> 
  </lastname>
  </user>
  </users>

Similar Threads

Word 2007 adds extra spaces in mail merge in Windows Software
function to return parent node in C++
Database values in fopen path? in PHP
Passing XML (node) parameters to XSLT in Saxon in XML, XSLT and XPATH
Read/Edit specific .xml nodes in vb6 in Visual Basic 4 / 5 / 6

Mapper99

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Apr 2008

Permalink

Aug 12th, 2009

Re: Updating XML nodes using SimpleXML adds extra node

php Syntax (Toggle Plain Text)
$desc->lastname = "Penner";
$desc->lastname = "Penner";

I believe your problem lies with this line of code. If you echo $desc to screen I think you will find that it relates to the lastname tag, not the user tag, so it is inserting a child of the lastname tag which is not what you want. If you change that line to this:

php Syntax (Toggle Plain Text)

$desc = "Penner";

I think that will be closer to what you are after.

darkagn

Reputation Points: 395

Solved Threads: 192

Veteran Poster

Offline

1,136 posts
since Aug 2007

Permalink

Aug 12th, 2009

Re: Updating XML nodes using SimpleXML adds extra node

Thanks for your reply. When I change that line, the XML data is not updated at all. I believe that the simpleXML syntax for updating a node needs to have a certain format. Perhaps I am just setting a regular PHP variable using this syntax?

Mapper99

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Apr 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in PHP Forum Timeline: Strange array problem

Next Thread in PHP Forum Timeline: accessing individual elements

DaniWeb Message

Cancel Changes

User Name
Password