DaniWeb Forum Index > Web Development > PHP

Delete XML nodes failing...

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

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...

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 
 PHP Syntax (Toggle Plain Text) 
<users>
     <user>
     <fullname>PC1</fullname>
     <flooor>4</floor
     </user>
     <user>
     <fullname>PC2</fullname>
     <flooor>3</floor
     </user>
</users>
<users>
     <user>
     <fullname>PC1</fullname>
     <flooor>4</floor
     </user>
     <user>
     <fullname>PC2</fullname>
     <flooor>3</floor
     </user>
</users>

Here is my code so far:

 Help with Code Tags 
 PHP 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.

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 
 PHP 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 == "PC1") {
    $users->documentElement->removeChild($users->documentElement->childNodes->item($count));
   }
}
 
$users->save("officedata.xml");
?>
$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 == "PC1") {
    $users->documentElement->removeChild($users->documentElement->childNodes->item($count));
   }
}

$users->save("officedata.xml");
?>

Works like a charm and is a very useful code snippet for deleting XML records using PHP!

Mapper
<FAKE SIGNATURE>

Last edited by peter_budo; Oct 2nd, 2009 at 10:34 am. Reason: Keep In The Site - No Fake signatures. Create a sitewide signature within the user control panel.