PHP XML Xpath get price lower than doesn't work

Question

<Product>
  <Price>
   <SalePrice>
      14,95
   </SalePrice>
  </Price>
</Product>  
<Product>
  <Price>
   <SalePrice>
     16,95
   </SalePrice>
  </Price>
</Product>



$response->xpath('Product/Price/[SalePrice <= "16,95"]/parent::*

Hello, i wanna get every Sale Price equals or lower than 16,95 as it is in my example. But everytime i try, it gives a empty array. If i only use:

$response->xpath('Product/Price/[SalePrice = "16,95"]/parent::*

i got a result. I hope you can help me with this problem. Thanks

The error 500 is a sign that there is an error in your code, have you tried to catch the error with `error_reporting(E_ALL);` ? — node_modules, Apr 10 '17 at 14:07
Escape the single quotes, or use double quotes for the encapsulation. — chris85, Apr 10 '17 at 14:07
If you're seeing a 500 error and a blank screen, you need to [learn how to display errors or access your error log](http://stackoverflow.com/questions/12769982/reference-what-does-this-error-mean-in-php/12772851#12772851). Then if you still don't understand the error message, [edit] your question to include the exact wording/. — IMSoP, Apr 10 '17 at 14:07
Try this expression `Product/Price/SalePrice[text()<= '16,95']` — vold, Apr 10 '17 at 14:15
I've tried changing the expression without success. There are any other ideas? — Chris Müller, Apr 10 '17 at 18:27
`//Product/Price/SalePrice[number(translate(.,',','.'))<= 16.95]/parent::*` — splash58, Apr 10 '17 at 19:08

splash58 · Accepted Answer · 2017-04-10T19:51:01.330

1

translate comma to point to get correct float number
convert string to number
compare result with float number but not string

//Product/Price/SalePrice[number(translate(.,',','.'))<= 16.95]/parent::*

demo on eval

edited Apr 10 '17 at 19:51

answered Apr 10 '17 at 19:33

splash58

26,043
3
22
34

PHP XML Xpath get price lower than doesn't work

1 Answers1