DaniWeb Forum Index > Web Development > PHP

Update XML Node via PHP...

Please support our PHP advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Apr 2008

Posts: 31

Reputation: Mapper99 is an unknown quantity at this point

Solved Threads: 0

Mapper99

Offline

Light Poster

Update XML Node via PHP...

Aug 11th, 2009

Hi there,

I am trying to update a node in an XML file using PHP.

Here is the XML:

 Help with Code Tags 
 xml Syntax (Toggle Plain Text) 
<users>
   <user>
     <id>1</id>
     <firstname>Bob</firstname>
     <lastname>Marley</lastname>
   </user>
   <user>
     <id>2</id>
     <firstname>Bruce</firstname>
     <lastname>Springsteen</lastname>
   </user>
</users>
<users>
   <user>
     <id>1</id>
     <firstname>Bob</firstname>
     <lastname>Marley</lastname>
   </user>
   <user>
     <id>2</id>
     <firstname>Bruce</firstname>
     <lastname>Springsteen</lastname>
   </user>
</users>

How can I go about searching the XML file for all tags where "id=2" and setting the firstname and lastname nodes to new values?

Any replies would be greatly appreciated!

Mapper

Last edited by peter_budo; Aug 11th, 2009 at 2:50 pm. Reason: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks) and [icode] (inline code) tags.

•

Join Date: Apr 2005

Posts: 1,435

Reputation: ShawnCplus is a glorious beacon of light

Solved Threads: 232

ShawnCplus ShawnCplus is offline

Offline

Code Monkey

Re: Update XML Node via PHP...

Aug 11th, 2009

http://php.net/SimpleXML, You might want to take a look at the xpath stuff.

GCS d- s+ a-->? C++(++++) UL+++ P+>+++ L+++ E--- W+++
N+ o K w++(---) O? !M- V PS+>++ PE+ Y+ PGP !t- 5? X- R tv+
b+>++ DI+ D G++>+++ e+ h+>++ r y+
PMs asking for help will not be answered, post on the forums. That's what they're there for.

•

Join Date: Apr 2008

Posts: 31

Reputation: Mapper99 is an unknown quantity at this point

Solved Threads: 0

Mapper99

Offline

Light Poster

Re: Update XML Node via PHP...

Aug 11th, 2009

•

Originally Posted by ShawnCplus

http://php.net/SimpleXML, You might want to take a look at the xpath stuff.

I have taken a brief look into SimpleXML and have created the following. I just can't get the XML to update:

 Help with Code Tags 
 PHP Syntax (Toggle Plain Text) 
$file = 'officedata.xml';
$xml = simplexml_load_file($file);
$lastname = $xml->xpath('//user[id="2"]/lastname');
$xml_string='';
 
        while(list( , $node) = each($lastname))
        {
 
            $xml_string .= $node->asXML(); 
            $xml_string='newlastname';
        }
 
echo $xml_string;
$file = 'officedata.xml';
$xml = simplexml_load_file($file);
$lastname = $xml->xpath('//user[id="2"]/lastname');
$xml_string='';

        while(list( , $node) = each($lastname))
        {

            $xml_string .= $node->asXML(); 
            $xml_string='newlastname';
        }

echo $xml_string;