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

  

posted @ 2022-11-19 11:08  carol2014  阅读(188)  评论(0编辑  收藏  举报