Need help in update xml data using php dom

[cyberfly]

Hi i am having difficulties to update the cmark data.in other words, i dont have any idea on how to do it.

studentsubject.xml

<?xml version="1.0"?>
<students>
<student sid="amuk">
<id>20088</id>
<subject>PHP</subject>
<code>CSC572</code>
<cmark>10</cmark>
<lectid>mus</lectid>
</student>
<students>
<student sid="lan">
<id>200828</id>
<subject>XHTML</subject>
<code>CSC576</code>
<cmark>30</cmark>
<lectid>mus</lectid>
</student>
<students>
<student sid="musa">
<id>2008288868</id>
<subject>XML</subject>
<code>CSC570</code>
<cmark>30</cmark>
<lectid>mus</lectid>
</student>

php code

<?php

if(isset($_POST['Submit']))
{

//help i dont have any idea

?>

[evilunix]

Parse the current XML with the simplexml_load_file() function. Build up the new XML file using basic string concatenation, then save the file!

Not used the PHP DOM before, it can't take much longer to do it like this, it's easy to build an XML file manually

[cyberfly]

hi care to elaborate more?my level in using xml in php is this is 2nd day i use it

[evilunix]

Check out this tut http://devzone.zend.com/node/view/id/651

I can't find the one that helped me learn, but this one is pretty similar. I will post some code tomorrow if you are still stuck!

[cyberfly]

Thanks man!

Hi i think i need your help in xpath.And plz correct me

The logic is when the lecturer enter the cmark and submit, the cmark of the specified student identify using sid and code will be updated.


<?php

$cmark = $_POST['cmark'];
$sid = "musa";
$code = "CSC570";

$file = "users/studentsubject.xml";

// load file
$xml = simplexml_load_file($file) or die ("Unable to load XML file!");

// how to select data with student sid = musa and code = CSC570 using xpath?

foreach ($xml->xpath('//item[quantity > 1]/desc') as $desc) {
echo "$desc\n";

$desc->cmark = $cmark;

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

}

?>

[Mapper99]

This code works great, except, it appears to add a full node inside of existing tags instead of just updating the node. Any idea why?

Mapper