Replacing data in an XML file

[cshaun]

Hi,

I've got an XML file that I've stored some encrypted credit card data in. I need to read through this file finding the <creditcard>encrypted data</creditcard> and decrypt this information, after which sending it to the client.

I'm wondering what the easiest and fastest way to do this would be? It's basically so that the administrator can process the numbers and then delete them.

Should I use an XML parser? Open the file and try search replace using regexp?

Your help is much appreciated, thanks.

[parawizard]

show me exactly how and what u are replacing

[cshaun]

Just reading the ccnumber and decrypting that value... and sending the exact same data to the client...

the XML file looks like this:

<?xml version="1.0"?>
<?xml-stylesheet type="text/xsl" href="ccpayment_single.xsl"?>
<payment>
<transaction id="1a" date="12/02/04 07:57:19">
<personaldetails>
<firstname>Shaun</firstname>
<lastname>Smith</lastname>
<telephone>[phone]</telephone>
<telephone_evening>[phone]</telephone_evening>
<email_address>[e-mail]</email_address>
</personaldetails>
<addressdetails>
<street_address>2/44 Laken Rd</street_address>
<suburb>Takapuna</suburb>
<city>Auckland</city>
<state>Auckland</state>
<country id="153">New Zealand</country>
</addressdetails>
<orderdetails>
<item>
<name>dog</name>
<quantity>1</quantity>
<price>$5.00</price>
</item>
<item>
<name>cat</name>
<quantity>2</quantity>
<price>$12.05</price>
</item>
</orderdetails>
<paymentdetails>
<amount>20.15</amount>
<ccowner>Shaun Smith</ccowner>
<ccnumber>123456789</ccnumber>
<cctype>Visa</cctype>
<ccexpiry>01/2004</ccexpiry>
</paymentdetails>
<comments>These are my comments.</comments>
</transaction>
</payment>

[bubblenut]

function getTagContents($tag,$data) 
{
  $buffer=explode('<'.$tag.'>',$data);
  if($count($buffer)==2) {
    $buffer=$explode('</'.$tag.'>',$buffer[1]);
  return array($buffer[0]);
  } elseif(count($buffer)<2) {
    return false;
  } else {
    for($i=1;$i<count($buffer);$i++) {
      $buffer2=explode('</'.$tag.'>',$buffer[$i]);
      $returner[]=$buffer2[0];
    }
    return $returner;
  }
}
if($ccnum=getTagContents('ccnumber',$data)) {
  echo($ccnum[0]."<br />\n");
} else {
  echo("Ooops!! No cc num!<br />\n");
}
?>

If the xml's always going to be of a simple form I'd use that. I've never looked into the parsers but I imagine they are designed for far more complex XML documents and may be overkill.

HTH
Bubble