xpath node containing anothe rnode with certain value

[vertmonkee]

The following is part of a larger XML document.

<gmd:descriptiveKeywords>
            <gmd:MD_Keywords>
               <gmd:keyword>
                  <gco:CharacterString>Addresses</gco:CharacterString>
               </gmd:keyword>

           <gmd:keyword>
              <gco:CharacterString>Administrative units</gco:CharacterString>
           </gmd:keyword>

           <gmd:keyword>
              <gco:CharacterString>Atmospheric conditions</gco:CharacterString>
           </gmd:keyword>

           <gmd:thesaurusName>
              <gmd:CI_Citation>
                 <gmd:title>
                    <gco:CharacterString>GEMET - INSPIRE themes, version 1.0</gco:CharacterString>
                 </gmd:title>

                 <gmd:date>
                    <gmd:CI_Date>
                       <gmd:date>
                          <gco:Date>2008-01-06</gco:Date>
                       </gmd:date>

                       <gmd:dateType>
                          <gmd:CI_DateTypeCode codeList="http://standards.iso.org/ittf/PubliclyAvailableStandards/ISO_19139_Schemas/resources/Codelist/gmxCodelists.xml#CI_DateTypeCode" codeListValue="revision">revision</gmd:CI_DateTypeCode>
                       </gmd:dateType>
                    </gmd:CI_Date>
                 </gmd:date>
              </gmd:CI_Citation>
           </gmd:thesaurusName>
        </gmd:MD_Keywords>
     </gmd:descriptiveKeywords>

     <gmd:descriptiveKeywords>
        <gmd:MD_Keywords>
           <gmd:keyword>
              <gco:CharacterString>'Other' wave statistics</gco:CharacterString>
           </gmd:keyword>

           <gmd:keyword>
              <gco:CharacterString>Acoustic noise in the water column</gco:CharacterString>
           </gmd:keyword>

           <gmd:thesaurusName>
              <gmd:CI_Citation>
                 <gmd:title>
                    <gco:CharacterString>SeaDataNet P021 parameter discovery vocabulary</gco:CharacterString>
                 </gmd:title>

                 <gmd:date>
                    <gmd:CI_Date>
                       <gmd:date>
                          <gco:Date>2009-11-16</gco:Date>
                       </gmd:date>

                       <gmd:dateType>
                          <gmd:CI_DateTypeCode codeList="http://standards.iso.org/ittf/PubliclyAvailableStandards/ISO_19139_Schemas/resources/Codelist/gmxCodelists.xml#CI_DateTypeCode" codeListValue="revision">revision</gmd:CI_DateTypeCode>
                       </gmd:dateType>
                    </gmd:CI_Date>
                 </gmd:date>
              </gmd:CI_Citation>
           </gmd:thesaurusName>
        </gmd:MD_Keywords>
     </gmd:descriptiveKeywords>

There are several

gmd:descriptiveKeywords

tags.

What I need to do is get the gmd:descriptiveKeywords tag that contains the following path

<gmd:thesaurusName>
                  <gmd:CI_Citation>
                     <gmd:title>
                        <gco:CharacterString>

The gco:CharacterString tag will contain the following

<gco:CharacterString>GEMET - INSPIRE themes, version 1.0</gco:CharacterString>

The closest I have come is using the following syntax

$inspire_keywords = $importxml->xpath('//gmddescriptiveKeywords[//gcoCharacterString[. = "GEMET - INSPIRE themes, version 1.0"]]');

But this just returns me all of the gmd:descriptiveKeywords not just the one I am targeting above.

Can anyone offer up the correct xpath syntax I should be using?

Thanks for any help.

[Weedpacket]

Try [.//gcoCharacterString[ (note the '.'). Otherwise that predicate just starts from the document root again when it looks for CharacterString elements, instead of starting from the context node.

[vertmonkee]

Thanks very much Weedpacket that has worked.

I'm having a slight problem with the part of the XML I am now retrieving.

The first part of the data I am returned is the following

Array
(
    [0] => SimpleXMLElement Object
        (
            [gmdMD_Keywords] => SimpleXMLElement Object
                (
                    [gmdkeyword] => Array
                        (
                            [0] => SimpleXMLElement Object
                                (
                                    [gcoCharacterString] => Addresses
                                )

                        [1] => SimpleXMLElement Object
                            (
                                [gcoCharacterString] => Administrative units
                            )

                        [2] => SimpleXMLElement Object
                            (
                                [gcoCharacterString] => Atmospheric conditions
                            )

                    )

I need to pull in the values Addresses, Administrative units, Atmospheric conditions. However if I try to assign that array to a variable like so

$keywords = $inspire_keywords_path[0]->gmdMD_Keywords->gmdkeyword;

It only returns me the first entry like so

SimpleXMLElement Object
(
    [gcoCharacterString] => Addresses
)

Does anyone have any ideas on this part of the problem?

Thanks