Adding XML Values Together?

[AffiliatePro]

I got something that's really got me stumped that I was hoping somebody could help me figure out here...

How can you add XML node values together from two or more different XML elements if a separate node in the same element matched the value of that node in the last element?

So in the example below, if <promo> equals 1122 in more than one element, it will add both <amount> from both of those nodes together?

$result = curl_exec($ch);
curl_close($ch);

$xml = simplexml_load_string($result);

foreach ($xml->orderData as $record)
{
	if ($record->promo == next($record->promo)) {
		$amount = $record->accountAmount + $amount;
	} else {
		$amount = $record->accountAmount;
	}
 }

example of the xml data:

<orderData>
<promo>1121</promo>
<amount>25.00</amount>
</orderData>

<orderData>
<promo>1122</promo>
<amount>25.00</amount>
</orderData>

<orderData>
<promo>1122</promo>
<amount>45.00</amount>
</orderData>

<orderData>
<promo>1123</promo>
<amount>25.00</amount>
</orderData>

It's got me stumped pretty good! I don't think next() will work in this case though 🙁

[dagon]

foreach is iterating through $xml->orderData there is no next($record) as its just a temporary variable created by the function. you have to either create a new array and use your approach or store that values temporarily for comparison with in your foreach loop.

[AffiliatePro]

dagon;10961029 wrote:

foreach is iterating through $xml->orderData there is no next($record) as its just a temporary variable created by the function. you have to either create a new array and use your approach or store that values temporarily for comparison with in your foreach loop.

Thanks! I think that's where I'm stuck. What would be the best method for storing the values temporarily and comparing them within the foreach loop?

[dagon]

this should work, and the result is a nice friendly array

$sum=array();
foreach ($xml->orderData as $record)
{
   $sum[$record->promo]+=$record->accountAmount;
} 

assumes promo value is unique

[AffiliatePro]

dagon;10961041 wrote:

this should work, and the result is a nice friendly array

$sum=array();
foreach ($xml->orderData as $record)
{
   $sum[$record->promo]+=$record->accountAmount;
} 

assumes promo value is unique

That throws the following error: Warning: Illegal offset type in /home/hhhx/public_html/cbxmlapi.php on line 22 -------- line 22: $sum[$record->promo]+=$record->accountAmount;

but promo value isn't always unique that's the problem...

each xml element contains the nodes "promo" and "accountAmount"

in some elements, the value of "promo" is the same. so when the value of promo is the same it needs to add the values of "accountAmount" from those same elements together.

its tricky, I know 🙁 that's why I came here lol