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

user357812 · Accepted Answer · 2010-10-08 13:00:24Z

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

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']

answered Oct 8, 2010 at 13:00

user357812

Sign up to request clarification or add additional context in comments.

Comments

jarnbjo · Accepted Answer · 2010-10-08 07:35:46Z

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

answered Oct 8, 2010 at 7:35

jarnbjo

34.4k7 gold badges75 silver badges95 bronze badges

1 Comment

Shinu Thomas Over a year ago

It is working fine.But it giving all the values with item number 1 and 2

fabrik · Accepted Answer · 2010-10-08 07:37:29Z

0

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

answered Oct 8, 2010 at 7:37

fabrik

14.4k8 gold badges58 silver badges71 bronze badges

Comments

Dennis Münkle · Accepted Answer · 2010-10-08 09:09:59Z

0

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

answered Oct 8, 2010 at 9:09

Dennis Münkle

5,0711 gold badge22 silver badges18 bronze badges

Collectives™ on Stack Overflow

Parsing xml file using xpath and xquery

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related