Create csv file after looping through array in php

Question

I have looped through an array and can successfully print out the rows that I need to work with

foreach($array['Stock'] as $row) {
    echo '|' . $row['Code'] . '|' . intval($row['Onhand']) . "\r\n";
}

I need to have all of the printed rows to be saved in a csv file. Should I be converting to an array first and then creating a csv or can I do it from within the loop?

Just to clarify guys, the file requirements are

'This CSV file must contain 3 columns, separated by the pipe symbol (|), without column names. '

it looks like you are delimiting each row with a pipe | for a csv I would have expected to see a comma used. Will add an answer but could you clarify this please — atoms
– atoms, Commented Jun 23, 2016 at 10:32

user128161 · Accepted Answer · 2016-06-23 10:29:17Z

3

Prepend each row onto a variable like:

$csv .= $row['Code'] . ',' . intval($row['Onhand']) . "\r\n";

Then use file_put_contents to save to local file, or use header to output headers to force download to browser.

PS: CSV stands for comma separated values, not pipe separated values, so if I'm correct in assuming you're using the pipe | to separate values it's best to use a comma instead.

answered Jun 23, 2016 at 10:29

user128161

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

1 Comment

atoms Over a year ago

damn beat me to it +1 for the comma seperated values as opposed to pipe

Collectives™ on Stack Overflow

Create csv file after looping through array in php

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related