Create CSV File with PHP

Question

I want to create a new .csv file (without opening the raw file first via fopen). So far I have tried this:

$list[] = array
(
    "Name" => "John",
    "Gender" => "M",
    "Age" => "21"
);
$timestamp0 = date("Y-m-d H:i:sa", time());
$datetime = new DateTime($timestamp0);
$datetime->setTimezone(new DateTimeZone('Asia/Jakarta'));
$timestamp = $datetime->format("Y-m-d_H-i");

$filename = __DIR__ . "/file/" . $timestamp . ".csv";

$header = array("name", "gender", "age");
file_put_contents($filename, implode("\n", $list)); // error here bcs array given :')

My questions are:

How can I change array 2d to csv?

Very need your help :( Thank you so much :")

Ismail RBOUH · Accepted Answer · 2016-08-01 05:38:38Z

8

Using fopen with w will create the file if does not exist:

$list = [
    ["Name" => "John", "Gender" => "M"],
    ["Name" => "Doe", "Gender" => "M"],
    ["Name" => "Sara", "Gender" => "F"]
];

$fp = fopen($filename, 'w');
//Write the header
fputcsv($fp, array_keys($list[0]));
//Write fields
foreach ($list as $fields) {
    fputcsv($fp, $fields);
}
fclose($fp);

If you don't like fputcsv and fopen you can use this alternative:

$list = [
    ["Name" => "John", "Gender" => "M"],
    ["Name" => "Doe", "Gender" => "M"],
    ["Name" => "Sara", "Gender" => "F"]
];

$csvArray = ["header" => implode (",", array_keys($list[0]))] + array_map(function($item) {
    return implode (",", $item);
}, $list);

file_put_contents($filename, implode ("\n", $csvArray));

I hope this will help you.

edited Aug 1, 2016 at 5:38

answered Aug 1, 2016 at 3:59

Ismail RBOUH

10.5k2 gold badges26 silver badges37 bronze badges

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

5 Comments

barney Over a year ago

Im sorry forget to change, Im using array multidimensional, what should I do? :')

Ismail RBOUH Over a year ago

Just update the question with your array and I will assist you in a better alternative ;)

Haresh Vidja Over a year ago

@ismail RBOUH, -1because it not a perfect way to create CSV file. php.net/manual/en/function.fputcsv.php

Ismail RBOUH Over a year ago

@HareshVidja I'm still waiting for you to remove the downvote ! Because it was the OP request to not use open and fputcsv. However, I've updated the answer for future users ;) Thank you ;)

Haresh Vidja Over a year ago

You have not given perfect solution first time so I have given down vote... You have to think first for give perfect solution... thanks :)

Haresh Vidja · Accepted Answer · 2016-08-01 05:10:06Z

0

You can use below code

$list[]=array ("name","gender","age"); // push header here
$list[] = array("John","M","21"); // push record here

$timestamp0     = date("Y-m-d H:i:sa",time());
$datetime       = new DateTime($timestamp0);
$datetime->setTimezone(new DateTimeZone('Asia/Jakarta'));
$timestamp      = $datetime->format("Y-m-d_H-i");

$filename = __DIR__ . "/file/" . $timestamp . ".csv";

$fp = fopen($filename, 'w');
foreach ($list as $fields) {
    fputcsv($fp, $fields);
}
fclose($fp);

For more detail read php manual about CSV file. http://php.net/manual/en/function.fputcsv.php

answered Aug 1, 2016 at 5:10

Haresh Vidja

8,4713 gold badges29 silver badges44 bronze badges

Collectives™ on Stack Overflow

Create CSV File with PHP

2 Answers 2

5 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

5 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related