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? — Dave Chen
– Dave Chen, Commented Jul 13, 2015 at 5:18

Raghavendra · Accepted Answer · 2015-07-13 05:29:36Z

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, 2015 at 5:29

answered Jul 13, 2015 at 5:20

Raghavendra

3,5901 gold badge19 silver badges18 bronze badges

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

5 Comments

user804401 Over a year ago

Sry, the service returns a CSV, the problem is the response goes to jQuery failCallback, I can see the CSV string in jqXHR.

Raghavendra Over a year ago

set this also in header("Set-Cookie: fileDownload=true; path=/") and try

user804401 Over a year ago

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

Raghavendra Over a year ago

does it coming into sucess callback ?

Raghavendra Over a year ago

i suggest to use iframe or window.location not to use jquery ajax. it will definitely work

Collectives™ on Stack Overflow

PHP convert comma delimited string to CSV file

1 Answer 1

5 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

5 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related