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>
   </type>
   <type name="PANTS">
        <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]');

The out put will give the itemNumber name and price.How i can get the type name i mean SWEATERS

//category/type[@name="SWEATERS"] ?

mhitza
– mhitza

2010-10-11 11:26:05 +00:00
Commented Oct 11, 2010 at 11:26 — mhitza
– mhitza, Commented Oct 11, 2010 at 11:26
I want type name with product id =1

Shinu Thomas
– Shinu Thomas

2010-10-11 11:28:51 +00:00
Commented Oct 11, 2010 at 11:28 — Shinu Thomas
– Shinu Thomas, Commented Oct 11, 2010 at 11:28

Gus · Accepted Answer · 2010-10-11 11:29:30Z

2

You can get this using the parent .., then the @name attribute.

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

xPath Syntax

answered Oct 11, 2010 at 11:29

Gus

7,3792 gold badges29 silver badges23 bronze badges

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

Comments

Oliver Hallam · Accepted Answer · 2010-10-11 12:07:41Z

2

You are looking for the name attribute of the type with a product element with an id of 1:

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

answered Oct 11, 2010 at 12:07

Oliver Hallam

4,2621 gold badge28 silver badges30 bronze badges

Collectives™ on Stack Overflow

Parsing xml file using xpath and xquery

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related