Delete XML nodes failing...

Expand Post »

Hi there,

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

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:

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

Similar Threads

swap xml nodes in RSS, Web Services and SOAP
Need Help TXT to XML Converter in VB.NET
Adding new node in XML, XSLT and XPATH
C# XMLDataSource - filtering XML in ASP.NET
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

Oct 2nd, 2009

Re: Delete XML nodes failing...

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

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.

Mapper99

Reputation Points: 10

Solved Threads: 0

Light Poster

Offline

42 posts
since Apr 2008

This thread is solved

Either the thread starter or a moderator has marked this thread as solved. You can most likely trust the responses and answers given. There is most likely no reason for any further responses to be posted here. If you have a related question, please start a new thread in this forum instead.

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: Multiple Files Upload to Server

Next Thread in PHP Forum Timeline: Time Format AM PM

DaniWeb Message

Cancel Changes

User Name
Password