Writing to csv from array in php

Question

I have csv files I would like to combine into a single csv file. I have managed to remove all headers. The headers write to the new file in the right column and row. But the rows from from the csv files are not lining up they start from column B instead of column A. Data from the csv is put in an array added to the new file. Is there a way I could remove the trailing commas and invoke a PHP_EOL. Here is an example of an element with data.

Array([0]=>"Joe,Soap,,,25,11,,,,,,"
[1]=>"Jimmy,Tesla,10,,4,,,,,,,,")

I would like each element to write on new line starting from column A. Here is my script.

 $fileload = $filecontents;
        $lines = file($fileload);
        foreach ($lines as $key => $line) {
          $lineArr = explode(',',$line);
          if(count(array_filter($lineArray)) <= 3)
          {
            continue;
          }
          if(count(array_intersect($lineArr, $outputheaders)) >= 1)
          {
            continue;
          }
      //Row Data
          $parts[] = $line;

        }

  $headers = implode(",",$putheaders);
  $sTmp = $sTmp.$headers;
  $details = implode("','",$parts);
  $sTmp = $sTmp.$details;


file_put_contents($Out, $sTmp, FILE_APPEND | LOCK_EX);

Are you reinventing the wheel? http://php.net/manual/en/function.fputcsv.php — GrumpyCrouton, Aug 10 '17 at 20:58
So what is the problem with `$details = implode(PHP_EOL,'",$parts);`? — u_mulder, Aug 10 '17 at 20:58
Possible duplicate of [How to create and download a csv file from php script?](https://stackoverflow.com/questions/16251625/how-to-create-and-download-a-csv-file-from-php-script) — localheinz, Aug 10 '17 at 21:01
@u_mulder Its inserting at right column but now it adds an extra empty row. — saiyan101, Aug 10 '17 at 21:10
This loops through a list of other csv. I am aware of open, but as you can see there are more parts to the script. — saiyan101, Aug 10 '17 at 21:11
@saiyan101 use the `FILE_IGNORE_NEW_LINES` option for `file` to avoid the extra empty rows. — Don't Panic, Aug 10 '17 at 22:43

Writing to csv from array in php

0 Answers0