php处理csv文件
php读取上传的csv文件
$filePath = $_FILES['file']['tmp_name'];
$data = [];
if (file_exists($filePath)) {
$handle = fopen($filePath, 'r');
while ($tmp = fgetcsv($handle)) {
$data[] = $tmp;
}
fclose($handle);
}
php写入csv文件并下载csv文件
$filename = 'down.csv';
$now = gmdate("D, d M Y H:i:s");
header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");
header("Last-Modified: {$now} GMT");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");
header('Content-type: application/x-csv');
header("Content-Disposition: attachment;filename={$filename}");
header("Content-Transfer-Encoding: binary");
$header = ['age', 'name'];
$data = [
[12, 'rose'],
[14, 'lily'],
];
if (count($data) > 0) {
ob_start();
$df = fopen("php://output", 'w');
fputcsv($df, $header);
foreach ($data as $row) {
fputcsv($df, $row);
}
fclose($df);
echo ob_get_clean();
}
浙公网安备 33010602011771号