Parsing xml file using xpath and xquery

Question

I have a xml file

<category>
    <type name="SWEATERS">
        <product id =1>
            <itemNumber>1</itemNumber>
            <name>ProductA2</name>
            <price>345</price>
        </product>
        <product id=2>
            <itemNumber>4</itemNumber>
            <name>Product Test </name>
            <price>456</price>
        </product>
    </type>
</category>

I used the xquery

$xml->xpath('//category/type/product[@id=1]');

When i used this xquery iam getting only the name and price.How i can get the type name 'SWEATERS' along with name and price

Answer 1

If you want to select the type element, you have to change your expression to:

//category/type[product/itemNumber=1]

Or for just the name:

//category/type[product/itemNumber=1]/@name

Answer 2

I'm afraid you can't do it with a single query with Xpath but you can do it with DOMNode->parentNode.

Answer 3

you can try something like:

$xml->xpath('//category/type[product/itemNumber=1]/(@name | product[itemNumber=1]/(name | price))');

this selects one attribute and two elements. The | is a union operator

Answer 4

When i used this xquery iam getting only the name and price.How i can get the type name 'SWEATERS' along with name and price

The XPath 1.0 expression should be:

//category/type/product[itemNumber=1]/*[self::name or self::price]|
//category/type[product[itemNumber=1]]

Or more staticly:

//category/type/product[itemNumber=1]/*[self::name or self::price]|
//category/type[@name='SWEATERS']