PHP output to CSV

Question

I have the following PHP script which reads from two CSV files, At the moment I am putting the data into a table however I need it to output to a CSV file...

<?php

$products_file = fopen('Products.csv', 'r');
$manufacturers_file = fopen('Manufacturers.csv', 'r');

$manufacturers = array();

while (($manufacturers_line = fgetcsv($manufacturers_file)) !== FALSE) {

     $manufacturers[$manufacturers_line[0]] = $manufacturers_line [1];

    }

echo '<table><tr><th>SKU</th><th>Make and Model</th><th>Make and Model</th></tr>';

while (($products_line = fgetcsv($products_file)) !== FALSE ) {

  echo '<tr><td>'.$products_line[3].'</td><td>';

  echo $manufacturers[$products_line[5]];

  echo '</td><td>'.$products_line[4].'</td></tr>';
}

echo '</table>';

fclose($products_file);
fclose($manufacturers_file);

?>

How can I do this using fputcsv ?

php.net/manual/en/function.fputcsv.php is all you need. The function takes a file handle and an array witch is saved in you're file on one line . — Poelinca Dorin
– Poelinca Dorin, Commented Mar 14, 2011 at 15:19

Richard Adnams · Accepted Answer · 2011-03-14 15:23:25Z

3

Looks like you just need to change where it renders the html table to write it to a csv file like this as from the PHP documentation:-

$fp = fopen('newfile.csv', 'w');

while (($products_line = fgetcsv($products_file)) !== FALSE )
{
  fputcsv($fp, $products_line);
}

fclose($fp);

Hope that helps.

Rick.

answered Mar 14, 2011 at 15:23

Richard Adnams

3,1082 gold badges27 silver badges31 bronze badges

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

4 Comments

Martin Hennings Over a year ago

Mind though that this will output different values than what's in your html table.

Richard Adnams Over a year ago

This is true as it will just output the whole row but that depends what data he wants to print out. It can easily be changed like you did by creating a new array.

Charles Marsh Over a year ago

Ta very Richard, I did end upp using this in the end... nice one!

Richard Adnams Over a year ago

Ah your most welcome, shame I didn't get the answer though :)

Martin · Accepted Answer · 2011-03-14 15:33:06Z

3

You could also do it this way:

Declare $csv outside your while loop:

$csv = '';

Then in your while loop populate the variable:

$csv .= $products_line[3].','.$manufacturers[$products_line[5]].','.$products_line[4]."\n";

Then once outside your loop you can write $csv to a file:

$myFile = 'testFile.csv';
$fh = fopen($myFile, 'w') or die('cannot open file');
fwrite($fh, $csv);
fclose($fh);

Done!

Note the double quote around the \n. If you use single quotes the \n character will not have the expected result.

edited Mar 14, 2011 at 15:33

answered Mar 14, 2011 at 15:25

Martin

10.6k13 gold badges66 silver badges84 bronze badges

1 Comment

Martin Hennings Over a year ago

+1 for double quote around the \n - I wouldn't have thought of that!

Martin Hennings · Accepted Answer · 2011-03-14 15:22:53Z

2

I'd suggest this:

$outfile = fopen('output.csv', 'w');

while (($products_line = fgetcsv($products_file)) !== FALSE 
      && fputcsv(
        array($products_line[3], $manufacturers[$products_line[5]], $products_line[4]
      ) !== FALSE) {
  echo '<tr><td>'.$products_line[3].'</td><td>';
  echo $manufacturers[$products_line[5]];
  echo '</td><td>'.$products_line[4].'</td></tr>';
}

First, a new array is being created with
array($products_line[3], $manufacturers[$products_line[5]], $products_line[4].
Then this array is being fed to fputcsv().

The above code outputs both csv and html. Remove the echo if you don't want html output.

answered Mar 14, 2011 at 15:22

Martin Hennings

17k9 gold badges51 silver badges70 bronze badges

Collectives™ on Stack Overflow

PHP output to CSV

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

4 Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related