case insensitive xpath searching in php

by

Gordon’s recommendation to use a PHP function from within XPath will prove more flexible should you choose to use that. However, contrary to his answer, the translate string function is available in XPath 1.0 so that means you can use it; your problem is how.

First, there is the obvious typo that Charles pointed out in his comment to the question. Then there is the logic of how you’re trying to match the text values.

In word form, you are currently asking, “does the text contain the lowercase form of the keyword?” This is not really what you want to be asking. Instead, ask, “does the lowercase text contain the lowercase keyword?” Translating (pardon the pun) that back into XPath-land would be:

(Note: truncated alphabets for readability)

//line[contains(translate(text(),'ABC...Z','abc...z'),'chicago')]

The above lowercases the text contained within the line node then checks that it (the lowercased text) contains the keyword chicago.

And now for the obligatory code snippet (but really, the above idea is what you really need to take home):

$xml    = simplexml_load_file($data);
$search = strtolower($keyword);
$nodes  = $xml->xpath("//line[contains(translate(text(), 'ABCDEFGHJIKLMNOPQRSTUVWXYZ', 'abcdefghjiklmnopqrstuvwxyz'), '$search')]");

echo 'Got ' . count($nodes) . ' matches!' . PHP_EOL;
foreach ($nodes as $node){
   echo $node . PHP_EOL;
}

Edit after dijon’s comment

Inside the foreach, you could access the line number, chapter number and book name like below.

Line number — this is just an attribute on the <line> element which makes accessing it super-easy. There are two ways, with SimpleXML, of accessing it: $node['number'] or $node->attributes()->number (I prefer the former).

Chapter number — to get at this, as you rightly said, we need to traverse up the tree. If we were using the DOM classes, we would have a handy $node->parentNode property leading us directly to the <chapter> (since it is the immediate ancestor to our <line>). SimpleXML does not have such a handy property, but we can use a relative XPath query to get it. The parent axis allows us to traverse up the tree.

Since xpath() returns an array we can cheat and use current() to access the first (and only) item in the array returned from it. Then it is just a matter of accessing the number attribute as above. 

// In the near future we can use: current(...)['number'] but not yet
$chapter = current($node->xpath('./parent::chapter'))->attributes()->number;

Book name — the process for this is the same as that of accessing the chapter number. A relative XPath query from the <line> could make use of the ancestor axis like ./ancestor::book (or ./parent:chapter/parent::book). Hopefully you can figure out how to access its name attribute.

More Related Contents:

  1. SimpleXML: Selecting Elements Which Have A Certain Attribute Value
  2. Selecting a css class with xpath
  3. Implementing condition in XPath [duplicate]
  4. How can I set text value of SimpleXmlElement without using its parent?
  5. How to handle double quotes in string before XPath evaluation?
  6. Will XPath 2.0 and/or XSLT 2.0 be implemented in PHP?
  7. Using regex to filter attributes in xpath with php
  8. DOMXpath – Get href attribute and text value of an a element
  9. Regex / DOMDocument – match and replace text not in a link
  10. XPath query with PHP
  11. Using Xpath with PHP to parse HTML
  12. Warning: foreach staement
  13. PHP: Access Array Value on the Fly
  14. Insert multiple rows with one query MySQL
  15. Why does PHP 5.2+ disallow abstract static class methods?
  16. Allowed memory size of X bytes exhausted
  17. With “magic quotes” disabled, why does PHP/WordPress continue to auto-escape my POST data?
  18. How to check if a file exists from a url
  19. PHP – include a php file and also send query parameters
  20. Limit execution time of an function or command PHP
  21. Regular expressions for a range of unicode points PHP
  22. Allow only [a-z][A-Z][0-9] in string using PHP
  23. Detect EXIF Orientation and Rotate Image using ImageMagick
  24. How do you make strings “XML safe”?
  25. Unsetting array values in a foreach loop [duplicate]
  26. PHP generated XML shows invalid Char value 27 message
  27. Find out the error_log’s path
  28. PHP E-mail Form Sender Name Instead Of E-mail?
  29. PHP: Escape RegEx pattern to prevent being applied?
  30. Group array data on one column and sum data from another column to form a flat associative array

Leave a Comment