Parse XML and get value with namespaces

Question

Here's my XML response generated in PHP, how do I get ns2:weight in php? I've tried a few different queries, but can't get it to work. This is an XML response from Amazon's API.

<?xml version="1.0"?>
<GetMatchingProductResponse xmlns="http://mws.amazonservices.com/schema/Products/2011-10-01">
  <GetMatchingProductResult ASIN="B000QSNYGI" status="Success">
    <Product xmlns="http://mws.amazonservices.com/schema/Products/2011-10-01" xmlns:ns2="http://mws.amazonservices.com/schema/Products/2011-10-01/default.xsd">
      <Identifiers>
        <MarketplaceASIN>
          <MarketplaceId>ATVPDKIKX0DER</MarketplaceId>
          <ASIN>B000QSNYGI</ASIN>
        </MarketplaceASIN>
      </Identifiers>
      <AttributeSets>
        <ns2:ItemAttributes xml:lang="en-US">
          <ns2:Binding>Health and Beauty</ns2:Binding>
          <ns2:Brand>Optimum Nutrition</ns2:Brand>
          <ns2:Department>unisex-adult</ns2:Department>
          <ns2:Feature>One 5-pound tub of chocolate-flavored whey protein</ns2:Feature>
          <ns2:Feature>Packed with whey protein isolates</ns2:Feature>
          <ns2:Feature>For maintaining and increasing lean muscle mass</ns2:Feature>
          <ns2:Feature>Instantized to mix easily with a spoon</ns2:Feature>
          <ns2:Feature>Each serving provides over 5 grams of BCAAs</ns2:Feature>
          <ns2:Flavor>Double Rich Chocolate</ns2:Flavor>
          <ns2:ItemDimensions>
            <ns2:Height Units="inches">10.75</ns2:Height>
            <ns2:Length Units="inches">8.00</ns2:Length>
            <ns2:Width Units="inches">8.00</ns2:Width>
            <ns2:Weight Units="pounds">5.00</ns2:Weight>
          </ns2:ItemDimensions>
          <ns2:IsAdultProduct>false</ns2:IsAdultProduct>
          <ns2:IsAutographed>false</ns2:IsAutographed>
          <ns2:IsMemorabilia>false</ns2:IsMemorabilia>
          <ns2:Label>Optimum Nutrition</ns2:Label>
          <ns2:ListPrice>
            <ns2:Amount>82.45</ns2:Amount>
            <ns2:CurrencyCode>USD</ns2:CurrencyCode>
          </ns2:ListPrice>
          <ns2:Manufacturer>Optimum Nutrition</ns2:Manufacturer>
          <ns2:Model>1054618</ns2:Model>
          <ns2:NumberOfItems>1</ns2:NumberOfItems>
          <ns2:PackageDimensions>
            <ns2:Height Units="inches">7.95</ns2:Height>
            <ns2:Length Units="inches">11.50</ns2:Length>
            <ns2:Width Units="inches">7.95</ns2:Width>
            <ns2:Weight Units="pounds">5.65</ns2:Weight>
          </ns2:PackageDimensions>
          <ns2:PackageQuantity>1</ns2:PackageQuantity>
          <ns2:PartNumber>1054618</ns2:PartNumber>
          <ns2:ProductGroup>Health and Beauty</ns2:ProductGroup>
          <ns2:ProductTypeName>HEALTH_PERSONAL_CARE</ns2:ProductTypeName>
          <ns2:Publisher>Optimum Nutrition</ns2:Publisher>
          <ns2:ReleaseDate>2007-05-14</ns2:ReleaseDate>
          <ns2:Size>5 Pound</ns2:Size>
          <ns2:SmallImage>
            <ns2:URL>http://ecx.images-amazon.com/images/I/51MRGj4bbuL._SL75_.jpg</ns2:URL>
            <ns2:Height Units="pixels">75</ns2:Height>
            <ns2:Width Units="pixels">50</ns2:Width>
          </ns2:SmallImage>
          <ns2:Studio>Optimum Nutrition</ns2:Studio>
          <ns2:Title>Optimum Nutrition 100% Whey Gold Standard, Double Rich Chocolate, 5 Pound</ns2:Title>
        </ns2:ItemAttributes>
      </AttributeSets>
      <Relationships>
        <VariationParent>
          <Identifiers>
            <MarketplaceASIN>
              <MarketplaceId>ATVPDKIKX0DER</MarketplaceId>
              <ASIN>B00OXVNR66</ASIN>
            </MarketplaceASIN>
          </Identifiers>
        </VariationParent>
      </Relationships>
      <SalesRankings>
        <SalesRank>
          <ProductCategoryId>health_and_beauty_display_on_website</ProductCategoryId>
          <Rank>35</Rank>
        </SalesRank>
        <SalesRank>
          <ProductCategoryId>6973717011</ProductCategoryId>
          <Rank>1</Rank>
        </SalesRank>
        <SalesRank>
          <ProductCategoryId>3764441</ProductCategoryId>
          <Rank>4</Rank>
        </SalesRank>
      </SalesRankings>
    </Product>
  </GetMatchingProductResult>
  <ResponseMetadata>
    <RequestId>1420dfd3-997d-4db9-bc81-a9a4cb665188</RequestId>
  </ResponseMetadata>
</GetMatchingProductResponse>

Please post your code here so it is preserved for future SO visitors. — Jay Blanchard
– Jay Blanchard, Commented Apr 27, 2015 at 12:46
No problem, thanks. I attempted to do that, but it said I had more code than text. I just had the one question I couldn't elaborate on further. — Geek Grid
– Geek Grid, Commented Apr 27, 2015 at 12:48
I think you will find the answer you want by reading php.net/manual/en/domdocument.getelementsbytagnamens.php — Professor Abronsius
– Professor Abronsius, Commented Apr 27, 2015 at 12:55
Thanks, Ram. I got it to display the local name and prefix, how do I nab the value? — Geek Grid
– Geek Grid, Commented Apr 27, 2015 at 13:13

ThW · Accepted Answer · 2015-04-28 08:38:01Z

Create a DOM and load the XML:

$dom = new DOMDocument();
$dom->loadXml($xml);

Create a DOMXpath object for it and register prefixes/aliases for the namespaces:

$xpath = new DOMXpath($dom);
$xpath->registerNamespace(
  'p', 'http://mws.amazonservices.com/schema/Products/2011-10-01'
);
$xpath->registerNamespace(
  'pd', 'http://mws.amazonservices.com/schema/Products/2011-10-01/default.xsd'
);

Use XPath expressions to fetch node lists and iterate them:

foreach ($xpath->evaluate('//p:Product') as $product) {
  ...
}

Use XPath expressions to fetch the actual values for a context node. The registered prefixes are resolved to the namespaces internally:

var_dump(
 [
   'MarketplaceId' => $xpath->evaluate(
     'string(p:Identifiers/p:MarketplaceASIN/p:MarketplaceId)', $product
   ),
   'Brand' => $xpath->evaluate(
     'string(p:AttributeSets/pd:ItemAttributes/pd:Brand)', $product
   )
 ]
);

Collectives™ on Stack Overflow

Parse XML and get value with namespaces

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related