thinkphp 导出

<?php
namespace app\index\controller;

use think\Controller;
use think\Db;

class ExportController extends Controller
{
    public function export()
    {
        // 查询数据
        $data = Db::name('user')->select();

        // 设置文件名和表头
        $fileName = 'user_list.csv';
        $header = ['ID', '姓名', '邮箱'];

        // 打开文件句柄
        $fileHandle = fopen('php://output', 'w');

        // 写入表头
        fputcsv($fileHandle, $header);

        // 写入数据
        foreach ($data as $row) {
            fputcsv($fileHandle, [$row['id'], $row['name'], $row['email']]);
        }

        // 关闭文件句柄
        fclose($fileHandle);

        // 设置响应头
        header('Content-Type: text/csv');
        header('Content-Disposition: attachment; filename="' . $fileName . '"');
        header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
        header('Expires: 0');
        header('Pragma: public');

        // 输出文件内容
        echo ob_get_clean();
    }
}