PHP array to CSV issues

Question

I have an array: $rowcsv['reasonforabsence'] this contains an undetermined amount of values. I want to output the values of this array to a CSV along with other values like this:

fputcsv($output, array( $overtime, $rowcsv['reasonforabsence']));

But when I do this the CSV outputs:

|6|"Holiday Full Day,Sick Full Day,Sick AM,Sick PM,Holiday Full Day,Holiday AM,Holiday PM,Absent Full Day,Absent AM|`

So basically instead of the $rowcsv['reasonforabsence'] array putting the values into new cells the array is just putting all the values into 1 cell. I have tried:

$reasonforabsence = explode( ',', $rowcsv['reasonforabsence'] );

$reasonforabsence = implode('","', $reasonforabsence);

But I get the output:

"Holiday Full Day"",""Sick Full Day"",""Sick AM"",""Sick PM"",""Holiday Full Day"",""Holiday AM"",""Holiday PM"",""Absent Full Day"",""Absent AM"

And everything still appears in 1 cell just this time with the quotes.

What does one line of your $rowcsv['reasonforabsence'] actually look like, please add a print_r() or var_dump() and what does $overtime look like — RiggsFolly
– RiggsFolly, Commented Jul 31, 2015 at 13:31
You could also try adding the last 2 parameter to fputcsv($output, array( $overtime, $rowcsv['reasonforabsence']), ',', '"'); — RiggsFolly
– RiggsFolly, Commented Jul 31, 2015 at 13:35

FuzzyTree · Accepted Answer · 2015-07-31 13:39:11Z

1

Combine $overtime and $rowcsv['reasonforabsence'] into a single array using array_merge and pass the combined array to fputcsv

$row = array_merge(array($overtime),explode(',',$rowcsv['reasonforabsence']));
fputcsv($output,$row);

edited Jul 31, 2015 at 13:39

answered Jul 31, 2015 at 13:31

FuzzyTree

32.4k3 gold badges58 silver badges87 bronze badges

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

1 Comment

Anthony Broadbent Over a year ago

Nice one. I had to explode the $rowcsv['reasonforabsence'] string into an array but it works as I wanted. Ive been trying for about 6 hours to solve it so thank you very much!

SiCK · Accepted Answer · 2015-07-31 13:44:57Z

0

With array( $overtime, $rowcsv['reasonforabsence']) you construct an array with two entries. Accordings $rowcsv['reasonforabsence'] is a plain comma separated values string, you have to explode() this into an array and merge it with your $overtime value :

fputcsv($output, array_merge(array($overtime), explode(',', $rowcsv['reasonforabsence'])));

answered Jul 31, 2015 at 13:44

SiCK

3674 silver badges15 bronze badges

Collectives™ on Stack Overflow

PHP array to CSV issues

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