作者:干杯13ds_198 | 来源:互联网 | 2023-09-12 11:20
php读取上传的csv文件$filePath$_FILES[file][tmp_name];$data[];if(file_exists($filePath)){$handlefo
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();
}