xpath php sort attribute based on greater than date

Question

Need to xpath xml data based on greater than date attribute. The dashes in the date below prevent the greater than symbol from working. Is there a way to remove the dashes in the xml on the fly?

XML

<revisions>
  <revision date="2010-07-12">blah</revision>
  <revision date="2010-06-12">blah</revision>
</revisions>

PHP

$rdate = 2010-07-01;
$programs = $item->xpath("/programs/program[revisions/revision[@date>'".$rdate."']]");

Wrikken · Accepted Answer · 2010-07-29 00:06:56Z

4

You might try:

$rdate = 20100701;

/programs/program[revisions/revision[translate(@date,'-','') > '20100701']

Edit: one should note that in XPath 2.0 the compare() function is available (-1 smaller, 0 equal, 1 higher), so you can just compare strings. As far is I know most PHP implementations are still using XPath 1.0 though.

edited Jul 29, 2010 at 0:06

answered Jul 28, 2010 at 23:52

Wrikken

70.8k8 gold badges99 silver badges136 bronze badges

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

Comments

Ben G · Accepted Answer · 2010-07-28 23:47:29Z

0

http://php.net/manual/en/function.str-replace.php

str_replace($date, '-', '')

answered Jul 28, 2010 at 23:47

Ben G

26.9k35 gold badges112 silver badges177 bronze badges

Collectives™ on Stack Overflow

xpath php sort attribute based on greater than date

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related