php处理csv文件

php读取上传的csv文件

?

1 2 3 4 5 6 7 8 9

$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文件　　

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25

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