XML parsing assistance...

[fikse]

I have the following XML data:

<Item>
<AttributeSetArray>

<AttributeSet attributeSetID="1137">

<Attribute attributeID="39">
<Value>
<ValueLiteral>Dodge</ValueLiteral>
<ValueID>1943</ValueID>
</Value>
</Attribute>

<Attribute attributeID="41">
<Value>
<ValueLiteral>Viper</ValueLiteral>
<ValueID>10491</ValueID>
</Value>
</Attribute>

<Attribute attributeID="214">
<Value>
<ValueLiteral>Not Offered</ValueLiteral>
<ValueID>31488</ValueID>
</Value>
</Attribute>


it keeps going...

I'm using php5 to parse the XML with SimpleXML, I need to grab the data inside attribute id 41, which in this case is the word "viper".

Here is what I have so far:

foreach ($xml->SearchResultItemArray->SearchResultItem as $searchitem) {

$model = $searchitem->Item->AttributeSet->Attribute attributeID="39">ValueLiteral;

}

I'm not sure how to enclose the "Attribute attributeID="39" part in there....

thanks for any assistance....

[DJ_Polymorph]

$searchitem->xpath("//Attribute[@attributeID = '39']/ValueLiteral/text()");

[fikse]

that didn't work, I think the for each statement is incorrect,

should it be something like this?

foreach ($xml->Item->AttributeSetArray as $searchitem) {

[fikse]

now that I look at it, if I can just get the word Viper out, I would be able to work out the rest, I tried this xpath:

$title = $xml->xpath("//Item/AttributeSetArray/AttributeSet[@attributeSetID = '1137']/Attribute[@attributeID = '39']/Value/ValueLiteral/text()");

but it didn't return anything....

[DJ_Polymorph]

If you only want the value of one node you don't need to loop anything. Just use the Xpath I posted.

[fikse]

thanks DJ_Polymorph, I did try that and it doesn't return anything....

I tried using xpath to start from the beginning based on your code:

$title = $xml->xpath("//GetItemResponse/Item/AttributeSetArray/AttributeSet[@attributeSetID = '1137']/Attribute[@attributeID = '39']/Value/ValueLiteral/text()");

echo "$title";

but title isn't holding anything....

[DJ_Polymorph]

Try:

//Attribute[@attributeID = '39']//ValueLiteral/text()

I think the SimpleXML xpath method also returns an array, so if that doesn't work try $title[0];.

[fikse]

thanks nothing in $title[0] either....

I have it working this way with other parts of the xml:

$test = $xml->Item->Seller->VATStatus;

is there a way to use this contruct instead of the xpath method to get the word "Viper" out of the above XML?

thanks...