①データ一覧画面にボタンを設置
②DBから全データ取得
③CSVデータで出力
②
<?php $items = array(); $sql = "select * from item"; $stmt = $pdo->query($sql); foreach ($stmt->fetchAll() as $row) { array_push($items, $row); }
③
<?php $temp = tmpfile(); foreach ($items as $key => $item) { $array = array($item['○○'], $item['○○']); fputcsv($temp, $array); } unset($pdo); header("Content-Type: application/octet-stream"); header("Content-Disposition: attachment; filename=data.csv"); $meta = stream_get_meta_data($temp); readfile($meta['uri']); fclose($temp);