0

The Xpath & PHP code below checks to see if the text in any of the "name" elements in the XML file contain the string "desk" (see the second line of code). If the Xpath search string was "Desk" (with an uppercase D) it would retrieve the text in the first XML name element which is "Desktop". But since the Xpath search string is "desk" (with a lowercase d) nothing is retrieved.

Is there a way to code this so the Xpath search string "desk" (with a lower case d) can retrieve "Desktop" (with an upper case D) from the name element of the XML file? Or is there a way to make the query NOT case sensitive?

Here is the XPath and PHP code:

$xmldoc = simplexml_load_file("products.xml");
$query = $xmldoc->xpath('/products/product[contains(name,"desk")]');  
foreach($query as $Products) {
echo $Products->name . " ";
echo $Products->price . "<br>";
}

Here is the XML file (named product.xml):

<products>
   <product type="Electronics">
      <name>Desktop</name>
      <price>499.99</price>
      <store>Best Buy</store>
   </product>
   <product type="Hardware">
      <name>Hand Saw</name>
      <price>99.99</price>
      <store>Lowes</store>
   </product>
</products>

Thanks!

ohlmar
  • 958
  • 8
  • 17
Dean Olsen
  • 131
  • 4
  • 13
  • possible duplicate of [case insensitive xpath searching in php](http://stackoverflow.com/questions/3238989/case-insensitive-xpath-searching-in-php) – Jens Erat Feb 07 '14 at 18:34

2 Answers2

0

Try this..

$query = $xmldoc->xpath('/products/product[contains(name,"_esk")]');
Vegeta
  • 1,319
  • 7
  • 17
0

If you use

$query = $xmldoc->xpath('/products/product[contains(translate(name, "ABCDEFGHIJKLMNOPQRSTUVWXYZ", "abcdefghijklmnopqrstuvwxyz"),"desk")]');

you have a case insensitive comparison, at least for the letters the translate call converts.

Martin Honnen
  • 160,499
  • 6
  • 90
  • 110