Home

Querying a DOM Document with XPath

Author : Exforsys Inc. Published on: 20th Apr 2008 | Last Updated on: 21st Apr 2008

Querying a DOM Document with XPath

One way to access the DOM tree in a DOMDocument object is through an associated DOMXPath object. Identifying a specifi c node or nodes within the DOM tree of a DOMDocument object with this approach involves use of appropriate XPath expressions passed to the DOMXPath object as parameters.

Ads

NOTE: While the example in this section shows how XPath can be used in PHP, Oracle also has some SQL functions operating on XML, such as existsNode, extractValue, and updateXML, which take XPathexpression arguments.

The following script illustrates how to access XML content held in a DOMDocument object through the DOMXPath object associated with that DOMDocument.

Sample Code

<?php
//File: XPath.php
$dom = new DomDocument();
$dom->load('employees.xml');
$xpath = new DOMXPath($dom);
$query = '//EMPLOYEE/SALARY[. > "15000"]';
$emps = $xpath->query($query);
print '<font face="Arial">';
print '<h3>Executive officers whose salaries > $15,000</h3>';
print '<table border="1" cellpadding="5"><p>';
print '<th>Employee ID</th><th>Last Name</th><th>Salary</th><p>';
foreach ($emps as $emp) {
print '<tr><td>'.$emp->parentNode->getAttribute('id').'</td><p>';
print '<td>'.$emp->previousSibling->nodeValue.'</td><p>';
print '<td>'.$emp->nodeValue.'</td></tr><p>';
}
print '</table>';
print '</font>';
?>

Unlike the preceding example where you generated an XML document from scratch, here you load it from a fi le, using the load method of the DOMDocument object. After the document is loaded, you create a new DOMXPath object, and associate it with the newly created DOMDocument object.

The XPath expression used in the above script is to be applied to the employees XML document loaded to DOMDocument object. You use this expression to identify all the SALARY nodes whose values exceed 15000, passing it to the DOMXPath's query method as the parameter.

NOTE: For more information on XPath, you can refer to the W3C XML Path Language (XPath) Version 1.0 recommendation at http://www.w3.org/TR/xpath" target="_blank" rel="nofollow".

Ads

To iterate over the result set returned by the query issued within the script, you use the foreach construct. Since each row of the result set represents a SALARY node defined within its parent EMPLOYEE node, you access that parent node using the parentNode method of the DOMNode object representing the SALARY node being processed. However, to access the corresponding ENAME node you use the previousSibling method of the DOMNode object.

If you run the XPath.php script discussed here, your browser should display an HTML table representing the list of employees whose salaries exceed 15,000.

Read Next: Transforming and Processing XML with XSLT

This tutorial is part of a PHP Oracle Training Tutorials tutorial series. Read it from the beginning and learn yourself.

PHP Oracle Training Tutorials