How could I find the changed section/value from 2 xmls

[toxic_brain]

hi,

How could I find the changed section/value from 2 xmls? The xml format are same but the value might vary.
example

XML 2

<countries>
<country>United States</country>
<currencies>
<currency>USD</currency>
<currency>Euro</currency>
</currencies>
. . . 
. . .more countries
<countries>

XML 1

<countries>
<country>United States</country>
<currencies>
<currency>USD</currency>
<currency>Euro</currency>
<currency>Pound</currency>
</currencies>

<country>india</country>
<currencies>
<currency>INR</currency>
</currencies>
<countries>
. . . 
. . .more countries

And I have to add/update/delete my database tables with this values. I don't want to truncate and rebuild each time.

Any ideas?
I plan to parse the XMLs to 2 arrays and use array diff. Does it sound good?

[scrupul0us]

Seems like a lot more BS to compare the differences than to just empty the table and push a new set of data in

[big_nerd]

I agree with with scrupul0us,

However, there is a function in the php manual for array_diff here to compare objects.

<?php
function array_obj_diff ($array1, $array2) {

foreach ($array1 as $key => $value) {
    $array1[$key] = serialize ($value);
}

foreach ($array2 as $key => $value) {
    $array2[$key] = serialize ($value);
}

$array_diff = array_diff ($array1, $array2);

foreach ($array_diff as $key => $value) {
    $array_diff[$key] = unserialize ($value);
}

return $array_diff;
}

?>

Granted I havn't tried this, you could bring them both in as SimpleXML objects and make the comparison.