Anejereffitte
New Member
I am trying and trying to parse an XML document. I can get all of the information when I look at a var_dump, but what I need to do is pull out the Id and image url from the document. I have tried using a for each loop, and it will go through the loop the correct number of times, but the Id number that I need never changes.The XML document is:\[code\]<?xml version="1.0"?><GetMatchingProductForIdResponse xmlns="http://mws.amazonservices.com/schema/Products/2011-10-01"><GetMatchingProductForIdResult Id="9781124028491" IdType="ISBN" status="ClientError"> <Error><Type>Sender</Type><Code>InvalidParameterValue</Code><Message>Invalid ISBN identifier 9781124028491 for marketplace ATVPDKIKX0DER</Message></Error></GetMatchingProductForIdResult><GetMatchingProductForIdResult Id="9780030114687" IdType="ISBN" status="Success"><Products xmlns="http://mws.amazonservices.com/schema/Products/2011-10-01" xmlns:ns2="http://mws.amazonservices.com/schema/Products/2011-10-01/default.xsd"><Product> <Identifiers> <MarketplaceASIN> <MarketplaceId>ATVPDKIKX0DER</MarketplaceId> <ASIN>0030114683</ASIN> </MarketplaceASIN> </Identifiers> <AttributeSets> <ns2:ItemAttributes xml:lang="en-US"> <ns2:Author>Turk, Jonathan.</ns2:Author> <ns2:Binding>Unknown Binding</ns2:Binding> <ns2:Label>Saunders College Publishers, USA</ns2:Label> <ns2:Manufacturer>Saunders College Publishers, USA</ns2:Manufacturer> <ns2
roductGroup>Book</ns2roductGroup> <ns2roductTypeName>BOOKS_1973_AND_LATER</ns2roductTypeName> <ns2ublicationDate>2004-12-07</ns2ublicationDate> <ns2ublisher>Saunders College Publishers, USA</ns2ublisher> <ns2:SmallImage> <ns2:URL>http://g-ecx.images-amazon.com/images/G/01/x-site/icons/no-img-sm._V192198896_.gif</ns2:URL> <ns2:Height Units="pixels">40</ns2:Height> <ns2:Width Units="pixels">60</ns2:Width> </ns2:SmallImage> <ns2:Studio>Saunders College Publishers, USA</ns2:Studio> <ns2:Title>Introduction to Environmental Studies.</ns2:Title> </ns2:ItemAttributes> </AttributeSets> <Relationships/> <SalesRankings/></Product>\[/code\]I have cut it down for brevity.My php is this:\[code\] foreach($parsed_xml->GetMatchingProductForIdResult as $item ) { //$ean =$parsed_xml->GetMatchingProductForIdResult->attributes()->Id; var_dump($ean);//->attributes()->Id $current = $parsed_xml->GetMatchingProductForIdResult->Products; print_r(" passed the foreach statement "); //$status = $parsed_xml->GetMatchingProductForIdResult->attributes()->status; //$isbn13 = $ean;print_r($isbn13); if(isset($parsed_xml->GetMatchingProductForIdResult, $current, $current->Product, $current->Product->AttributeSets)){ $amazonResult = array( 'isbn' => $parsed_xml->GetMatchingProductForIdResult->attributes()->Id,//$isbn13, 'ImageURL' => str_replace('SL75','SL200',$current->Product->AttributeSets->children('ns2', true)->ItemAttributes->SmallImage->URL), ); print_r(" Success was true "); } else {$amazonResult = array( 'isbn' => $parsed_xml->GetMatchingProductForIdResult->attributes()->Id,//$isbn13, 'ImageURL' => "Jim", ); print_r(" Success was false ");} //update image in images table print_r(" at the insert statement ");$conn->query("INSERT INTO images (isbn, image) VALUES ('" . $amazonResult['isbn'] . "', '" . $amazonResult['ImageURL'] . "')");\[/code\]How do I get each individual Id when going through the loop?
roductGroup>Book</ns2roductGroup> <ns2roductTypeName>BOOKS_1973_AND_LATER</ns2roductTypeName> <ns2ublicationDate>2004-12-07</ns2ublicationDate> <ns2ublisher>Saunders College Publishers, USA</ns2ublisher> <ns2:SmallImage> <ns2:URL>http://g-ecx.images-amazon.com/images/G/01/x-site/icons/no-img-sm._V192198896_.gif</ns2:URL> <ns2:Height Units="pixels">40</ns2:Height> <ns2:Width Units="pixels">60</ns2:Width> </ns2:SmallImage> <ns2:Studio>Saunders College Publishers, USA</ns2:Studio> <ns2:Title>Introduction to Environmental Studies.</ns2:Title> </ns2:ItemAttributes> </AttributeSets> <Relationships/> <SalesRankings/></Product>\[/code\]I have cut it down for brevity.My php is this:\[code\] foreach($parsed_xml->GetMatchingProductForIdResult as $item ) { //$ean =$parsed_xml->GetMatchingProductForIdResult->attributes()->Id; var_dump($ean);//->attributes()->Id $current = $parsed_xml->GetMatchingProductForIdResult->Products; print_r(" passed the foreach statement "); //$status = $parsed_xml->GetMatchingProductForIdResult->attributes()->status; //$isbn13 = $ean;print_r($isbn13); if(isset($parsed_xml->GetMatchingProductForIdResult, $current, $current->Product, $current->Product->AttributeSets)){ $amazonResult = array( 'isbn' => $parsed_xml->GetMatchingProductForIdResult->attributes()->Id,//$isbn13, 'ImageURL' => str_replace('SL75','SL200',$current->Product->AttributeSets->children('ns2', true)->ItemAttributes->SmallImage->URL), ); print_r(" Success was true "); } else {$amazonResult = array( 'isbn' => $parsed_xml->GetMatchingProductForIdResult->attributes()->Id,//$isbn13, 'ImageURL' => "Jim", ); print_r(" Success was false ");} //update image in images table print_r(" at the insert statement ");$conn->query("INSERT INTO images (isbn, image) VALUES ('" . $amazonResult['isbn'] . "', '" . $amazonResult['ImageURL'] . "')");\[/code\]How do I get each individual Id when going through the loop?