Parsing xml file using xpath and xquery

Question

I have a xml file

<?xml version="1.0" encoding="UTF-8"?> <xml> <settings> <title>Calendar for September</title> <subTitle>Calendar for September Calendar for September</subTitle> </settings> <events date="06-09-2010"> <event id="2"> <title>This is My Second Event</title> <description>This is My Second Event </description> </event> <event id="3"><title>This is My Third Event </title><description>This is My Third Event This is My Third Event This is My Third Event </description></event></events> </xml>

I am parsing the xml file using

$xml_str = file_get_contents('xmlfile'); $xml = simplexml_load_string($xml_str); if(!empty($xml)) { $nodes = $xml->xpath('//xml/events/event[@id="'.$id.'"]'); }

It will give only the title and description of event tag with specified id.How i can get the date

kennytm · Accepted Answer · 2010-09-07 07:48:38Z

1

Try

//event[@id="2"]/parent::events/@date

Together with the original XPath:

//event[@id="2"]/parent::events/@date | //event[@id="2"]

edited Sep 7, 2010 at 7:48

answered Sep 7, 2010 at 7:04

kennytm

526k110 gold badges1.1k silver badges1k bronze badges

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

4 Comments

Shinu Thomas Over a year ago

Thanks KennyTM.But it will give only date.

kennytm Over a year ago

@THOmas: You could | with the original XPath.

kennytm Over a year ago

@THOmas: //event[@id="2"]/parent::events/@date | //event[@id="2"]

user357812 Over a year ago

@KennyTM: Two minor: whenever schema is well know, try to avoid starting // operator, the abbreviated syntax .. is also well know. So this could be: /*/*/event[@id='2']|/*/*/event[@id='2']/../@date. Also, with "context free" expresion is a good practice to select in one direction only like /*/events[event[@id='2']]/@date.

VolkerK · Accepted Answer · 2010-09-07 07:31:30Z

Once you've found the <event> element use it as the context node for a new xpath query that fetches the nearest <events> element in the ancestor-axis.

$id = 2; $xml = simplexml_load_file('xmlfile'); if( !$xml ) { echo '!xml doc'; } else if ( !($event=$xml->xpath('events/event[@id="'.$id.'"]')) ) { echo '!event[id=...'; } else if ( !($container = $event[0]->xpath('ancestor::events[1]')) ) { echo '!events parent'; } else { echo $container[0]['date'], ' - ', $event[0]->title, "\n"; }

Collectives™ on Stack Overflow

Parsing xml file using xpath and xquery

2 Answers 2

4 Comments

Comments

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

4 Comments

Comments

Related