CODEWITHSUNDEEP
phpcsvmultiple-columns
nielsv
nielsv

Reputation: 6810

Multiple columns in csv

I'm creating a downloadable csv with php. This is what I have so far:

 // output headers so that the file is downloaded rather than displayed
 header('Content-Type: text/csv; charset=utf-8');
 header('Content-Disposition: attachment; filename=data.csv');

 // create a file pointer connected to the output stream
 $output = fopen('php://output', 'w');

 // output the column headings
 fputcsv($output, array('id', 'role_id', 'parent_id'));

 $list = RoleQuery::create()->find();
 $list = $list->toArray();

 $list = array_values($list);
 // loop over the rows, outputting them
 foreach($list as $fields){
     fputcsv($output, $fields);
 }

Just for testing I'm outputting the roles in my database. The problem is that they're all in one column like this:

enter image description here

How can I make sure that id, role_id and parent_id are in different columns?

Upvotes: 0

Views: 7023

Answers (1)

lewsid
lewsid

Reputation: 1910

Your CSV data looks fine, but it looks like whatever tool you're using to open the CSV isn't using commas as the delimiter. You could, as davidkonrad suggested, wrap each value in quotes and see if that helps. Usually though, when opening a CSV in Google Docs or Excel, it will ask you how you'd like to delimit, and they typically default to commas.

Upvotes: 1

Related Questions