Trouble parsing xml

duckduckgoose

I've been trying to parse an xml file and inserting the contents into my database, but I can't figure out how to insert the name & location for the store into one record.

My table looks something like this:

And my xml file looks like this:

<item>
        <title>Boots</title>
        <attributes>
                <color>red</color>
                <size>13</size>
                <width>M</width>
        </attributes>
        <store>
                <name>JCPenney</name>
                <location>San Bruno</location>
                <name>KMart</name>
                <location>San Mateo</location>
       </store>
</item>

I'm trying to insert the name and location in the same record, but when I do this:

foreach($item->store as $store) {
echo $store->name;
echo $store->location;
}

I only get one set. I get that it's because there's only one 'store' tag, but how do I pick up both the fields for each item, for each store?

Installer

The XML should really be more like this:

<item>
        <title>Boots</title>
        <attributes>
                <color>red</color>
                <size>13</size>
                <width>M</width>
        </attributes>
        <store>
                <name>JCPenney</name>
                <location>San Bruno</location>
        </store>
        <store>
                <name>KMart</name>
                <location>San Mateo</location>
        </store>
</item>

which you could read with:

foreach ($xml->item->store as $each) {
    echo $each->name . '<br />';
    echo $each->location . '<br />';
}

As it is you'll need to do something like this, I guess:

foreach ($xml->item->store->name as $each) {
    $names[] = $each;
}
foreach ($xml->item->store->location as $each) {
    $locations[] = $each;
}
foreach ($names as $key => $name) {
    echo $name . '<br />';
    echo $locations[$key] . '<br />';
}

and if every name doesn't have a matching location, or vice versa, then things will get even more complicated.