PHP convert comma delimited string to CSV file

Question

I have a delimited string coming from a service, I want to convert this delimited string with headers to a downlodable CSV file.

    empId,empName,salary,depName,depId
    1,John,20000,IT,2

Could someone help me with a code snippet/reference.

Isn't this a CSV already? Do you just want to [force a download](http://stackoverflow.com/questions/7263923/how-to-force-file-download-with-php)? — Dave Chen, Jul 13 '15 at 05:18

Raghavendra · Answer 1 · 2015-07-13T05:29:36.737

1

change header first

<?php
    header('Content-Disposition: attachment; filename="downloaded.csv"');
    echo 'empId,empName,salary,depName,depId';
    echo '1,John,20000,IT,2';   
?>

and then echo your output.

edited Jul 13 '15 at 05:29

answered Jul 13 '15 at 05:20

Raghavendra

3,530
1
17
18

Sry, the service returns a CSV, the problem is the response goes to jQuery failCallback, I can see the CSV string in jqXHR. – user804401 Jul 13 '15 at 05:37
set this also in header("Set-Cookie: fileDownload=true; path=/") and try – Raghavendra Jul 13 '15 at 05:41
no, it doesnt help, i think something should be added to jquery get parameters, trying with several options like dataType: "text/csv", still facing problem – user804401 Jul 13 '15 at 05:59
does it coming into sucess callback ? – Raghavendra Jul 13 '15 at 06:02
i suggest to use iframe or window.location not to use jquery ajax. it will definitely work – Raghavendra Jul 13 '15 at 06:04

PHP convert comma delimited string to CSV file

1 Answers1