36

In an XML document, I have elements which share the same name, but the value of an attribute defines what type of data it is, and I want to select all of those elements which have a certain value from the document. Do I need to use XPath (and if so, could you suggest the right syntax) or is there a more elegant solution?

Here's some example XML:

<object>
  <data type="me">myname</data>
  <data type="you">yourname</data>
  <data type="me">myothername</data>
</object>

And I want to select the contents of all <data> tags children of <object> who's type is me.

PS - I'm trying to interface with the Netflix API using PHP - this shouldn't matter for my question, but if you want to suggest a good/better way to do so, I'm all ears.

dimo414
  • 47,227
  • 18
  • 148
  • 244

2 Answers2

54

Try this XPath:

/object/data[@type="me"]

Which reads as:

  • Select (/) children of the current element called object
  • Select (/) their children called data
  • Filter ([...]) that list to elements where ...
    • the attribute type (the @ means "attribute")
    • has the text value me

So:

$myDataObjects = $simplexml->xpath('/object/data[@type="me"]');

If object is not the root of your document, you might want to use //object/data[@type="me"] instead. The // means "find all descendents" rather than "find all children".

IMSoP
  • 89,526
  • 13
  • 117
  • 169
Gumbo
  • 643,351
  • 109
  • 780
  • 844
5

I just made a function to do this for me; it only grabs the first result though. Your mileage may vary.

function query_attribute($xmlNode, $attr_name, $attr_value) {
  foreach($xmlNode as $node) { 
    if($node[$attr_name] == $attr_value) {
        return $node;
    }
  }
}

Usage:

echo query_attribute($MySimpleXmlNode->Customer, "type", "human")->Name;

(For the XML below)

<Root><Customer type="human"><Name>Sam Jones</name></Customer></Root>
IMSoP
  • 89,526
  • 13
  • 117
  • 169
willbradley
  • 694
  • 7
  • 11
  • 11
    Why not use the XPath Gumbo suggested? And why use a switch instead of the easier to read `if($node[$attr_name] == $attr_value)`? – dimo414 May 29 '12 at 15:34
  • This is a useful example to have, because sometimes you want to incorporate additional logic, so that XPath isn't the best approach. – IMSoP Jul 06 '20 at 10:18