Get data in .csv format from php form

Question

I'm using below code to get data from PHP form. Its working fine.

	<?php

$email=$_POST['email'];
$name=$_POST['name'];
$designation=$_POST['designation'];
$company=$_POST['company'];
$phone=$_POST['phone'];
$data=$name.",".$email.",".$designation.",".$company.",".$phone;

$file="file.csv";


file_put_contents($file, $data . PHP_EOL, FILE_APPEND);


?>

Whenever any user puts information in the form with separated (.) then name and email come in different cells in .csv file.

below is issue/csv image

How it will solved?

Thanks!

just build an array of the values, then use fputcsv(); PHP's built-in csv writer function, that knows how to handle a separator in the values — Mark Baker
– Mark Baker, Commented Jan 9, 2018 at 16:25

Cameron Hurd · Accepted Answer · 2018-01-09 16:33:01Z

2

Use PHP's fputcsv. Let it handle the particulars of CSV formatting for you!

<?php

$email       = $_POST['email'];
$name        = $_POST['name'];
$designation = $_POST['designation'];
$company     = $_POST['company'];
$phone       = $_POST['phone'];

$data = [
         $name,
         $email,
         $designation,
         $company,
         $phone,
];

$file = fopen('file.csv', 'a'); // Append data to end of file.

fputcsv($file, $data);

If you need a delimiter other than the default (,) put that for the third argument. Same for enclosure & escape chars (", \) as 4th and 5th args.

answered Jan 9, 2018 at 16:33

Cameron Hurd

5,0511 gold badge26 silver badges34 bronze badges

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

1 Comment

Rohit Verma Over a year ago

Thanks @Cameron Hurd

Collectives™ on Stack Overflow

Get data in .csv format from php form

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