PHP fputcsv insert into a new line in csv file

Question

I have a file name checklist.csv

I try to insert a new information in this file using php

My method work and i can insert a new information in the file

But i have a problem that the new information is near the past information

Example

,92,electrical,Final As built drawing,,,,,,,,,,,,,,,,,,,,,93,electrical,test,,,,,,,,,,,,,,,,,,,,

But what i want is to look like this in the file:

,92,electrical,Final As built drawing,,,,,,,,,,,,,,,,,,,,

,93,electrical,test,,,,,,,,,,,,,,,,,,,,

This is the code i use

 $number=secure($_POST['txt_number'],"num");
      $category=secure($_POST['txt_category'],"text");
      $desc=secure($_POST['txt_desc'],"ibtext");
      $file = fopen('checklist.csv', 'a+');
      $csv=array();
      $csv[]="";
      $csv[]=$number;
      $csv[]=$category;
      $csv[]=$desc;
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      $csv[]="";
      fputcsv($file,$csv);
      fclose($file);

How I add the new information in a new line??!!

Community · Accepted Answer · 2017-05-23 12:02:16Z

3

I expect that you are opening the CSV file on Windows.

Windows only shows a new line for \r\n whereas Linux shows a new line for \n.

See fputcsv and newline codes for someone else who has had a similar issue.

edited May 23, 2017 at 12:02

CommunityBot

11 silver badge

answered May 3, 2017 at 8:42

Tom Wright

2,8714 gold badges24 silver badges30 bronze badges

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

Collectives™ on Stack Overflow

PHP fputcsv insert into a new line in csv file

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related