Parsing a zero value from CSV

Question

I'm trying to import some data from a CSV file into a WordPress plugin.

I'm having trouble when the value to be imported is '0'. Currently it converts a '0' to NULL when saved in the database. The idea is to import a sport score ie. 2-0, which then gets parsed into an array.

$score = explode( '-', $result );

$home = trim($score[0]);
$away = trim($score[1]);

$goals = array( 'total' => array( 'home' => $home, 'away' => $away) );

update_post_meta( $id, 'total_score', serialize( $goals ) );

Can anybody suggest a solution, knowing me it's probably something blindingly obvious but my brain has hit a brick wall!

Thanks in advance

Thanks for your comment but I've checked and double checked the input and it is definitely a 0 — roofdog
– roofdog, Commented Feb 1, 2015 at 20:14

baao · Accepted Answer · 2015-02-01 21:15:37Z

1

This should do the job:

$home = strval(trim($score[0]));
$away = strval(trim($score[1]));

answered Feb 1, 2015 at 21:15

baao

73.5k18 gold badges152 silver badges209 bronze badges

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

1 Comment

roofdog Over a year ago

Thanks for your suggestion @michael but I have fixed the problem. The problem was elsewhere but your suggestion helped me get there - thanks again!

roofdog · Accepted Answer · 2015-02-02 00:07:23Z

0

I have resolved the issue :)

The original code was correct but a dodgy if/else statement was preventing the value for $score parsing correctly.

The answers below, although not used, did help me slim down the possibilities, thanks.

answered Feb 2, 2015 at 0:07

roofdog

3612 silver badges9 bronze badges

Collectives™ on Stack Overflow

Parsing a zero value from CSV

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related