XML, XSLT and XPATH

XML, XSLT and XPATH RSS

Delete XML nodes failing...

Please support our XML, XSLT and XPATH advertiser: Intel Parallel Studio Home

Thread Solved

•

Join Date: Apr 2008

Posts: 30

Reputation: Mapper99 is an unknown quantity at this point

Solved Threads: 0

Mapper99

Offline

Light Poster

Delete XML nodes failing...

-1

Oct 1st, 2009

Hi there,

I am trying to delete XML nodes using PHP. Here is a sample of my xml file.

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<users>
     <user>
     <fullname>PC1</fullname>
     <floor>4</floor>
     </user>
     <user>
     <fullname>PC2</fullname>
     <floor>3</floor>
     </user>
</users>
<users>
     <user>
     <fullname>PC1</fullname>
     <floor>4</floor>
     </user>
     <user>
     <fullname>PC2</fullname>
     <floor>3</floor>
     </user>
</users>

Here is my code so far:

 Help with Code Tags 
 XML, XSLT and XPATH Syntax (Toggle Plain Text) 
<?php
 
$users = new DOMDocument();
$users->load("officedata.xml");
$suser = simplexml_load_file("officedata.xml");
$count = 0;
 
foreach($suser->user as $user) {
 
     if ($user['fullname'] == "PC1") {
    $users->documentElement->removeChild($users-       documentElement->childNodes->item($count));
    $count--;
    }
    $count++
}
$users->save("officedata.xml");
 
?>
<?php

$users = new DOMDocument();
$users->load("officedata.xml");
$suser = simplexml_load_file("officedata.xml");
$count = 0;

foreach($suser->user as $user) {

     if ($user['fullname'] == "PC1") {
    $users->documentElement->removeChild($users-       documentElement->childNodes->item($count));
    $count--;
    }
    $count++
}
$users->save("officedata.xml");

?>

Any idea why this won't work? If I remove the IF statement, all of the XML data gets removed. I am just trying to remove "PC1"

Thanks in advance,

Mapper

•

Join Date: Apr 2008

Posts: 30

Reputation: Mapper99 is an unknown quantity at this point

Solved Threads: 0

Mapper99

Offline

Light Poster

Re: Delete XML nodes failing...

Oct 2nd, 2009

For those of you could not figure this one out, after a few tries I got it:

Help with Code Tags

XML, XSLT and XPATH Syntax (Toggle Plain Text)

$users = new DOMDocument();
$users->load("officedata.xml");
 
$suser = simplexml_load_file("officedata.xml");
$count = 0;
 
$user = $users->getElementsByTagName("user");
 
foreach($user as $value)
{
   $count++;
   $tasks = $value->getElementsByTagName("fullname");
   $task  = $tasks->item(0)->nodeValue;
 
   if ($task == "PCID4") {
    $users->documentElement->removeChild($users->documentElement->childNodes->item($count));
   }
}
 
$users->save("officedata.xml");
?>