fputcsv() not including comma in PHP

Question

I am passing an array from Javascript to PHP using AJAX and attempting to write the array as a new line in a CSV file. This row is being appended correctly but isn't including the necessary closing "," at the end.

$row = $_POST['row'];
$handle = fopen('filename.csv', 'a');
fputcsv($handle, $row);
fclose($handle);

I've tried messing with auto_detect_line_endings but to no success.

What "necessary" closing `,` at the end? Since when did a csv file terminate lines with a `,`? — Mark Baker, Jul 10 '15 at 22:21
Commas are just put **between** fields. There's no comma after the last field. — Barmar, Jul 10 '15 at 22:42

score 2 · Answer 1 · edited Oct 07 '21 at 11:02

2

A final , is not part of the CSV spec at all, unless the last field is null or empty.

Also, fputcsv() expects an array of fields. Is $_POST['row'] actually an array of fields? You may need to translate your POSTDATA into an appropriate array.

edited Oct 07 '21 at 11:02

Community

1
1

answered Jul 10 '15 at 22:49

Will

24,082
14
97
108

fputcsv() not including comma in PHP

1 Answers1