用PHP创建CSV文件 [英] Create CSV File with PHP

问题描述

我想创建一个新的.csv文件(无需先通过 fopen ). 到目前为止，我已经尝试过:

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 :')

我的问题是:

1. 如何将数组2d更改为csv?

非常需要您的帮助:(非常感谢:)

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

推荐答案

使用 fopen 与w一起创建的文件将不存在:

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);

如果您不喜欢 fputcsv 和 fopen 您可以使用以下替代方法:

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.

这篇关于用PHP创建CSV文件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！