PHP - Fetching xml values and returning conditional values

Question

I'm fetching some xml and convert it to csv similar to this post PHP - Fetch correct XML values if elements have similar tags per record. If I have an incorrect Date element like '0000-00-00' ... in the csv I want it to be empty ''.

This is my structure

XML Elements:

<abc:ABC>5EXZX4LPK</abc:ABC>
<abc:Date>0000-00-00</abc:Date> 
<abc:Name>I Bornheim</abc:Name>

php xpath xmlreader:

fputcsv(
  $output, 
  [
    $xpath->evaluate('string(abc:ABC)', $node),
    $xpath->evaluate('string(abc:Entity/abc:Date)', $node)        
    $xpath->evaluate('string(abc:Entity/abc:Name)', $node)
  ]
);

Output:

5EXZX4LPK,0000-00-00,"I Bornheim"

Desired Output:

5EXZX4LPK,,"I Bornheim"

How can I accomplish this?

Nigel Ren · Accepted Answer · 2018-12-17 18:14:21Z

1

You can check if it's a valid date by decomposing it into the year-month-day and then using checkdate()...

$date = $xpath->evaluate('string(abc:Entity/abc:Date)', $node);
$parts = explode("-", $date);
$date = (count($parts)== 3) &&
    checkdate($parts[1], $parts[2], $parts[0]) ? $date : '';

This explodes the date with - and checks there are 3 parts and that all the parts make up a valid date.

answered Dec 17, 2018 at 18:14

Nigel Ren

57.3k11 gold badges49 silver badges59 bronze badges

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

Collectives™ on Stack Overflow

PHP - Fetching xml values and returning conditional values

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related