thinkphp 导出数据库

<?php
namespace app\index\controller;

use think\Controller;
use think\Db;

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

        // 设置文件名和文件类型
        $filename = 'export_data.csv';
        header('Content-Type: text/csv');
        header('Content-Disposition: attachment; filename="' . $filename . '"');
        header('Pragma: no-cache');
        header('Expires: 0');

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

        // 写入表头
        $header = ['id', 'name', 'email'];
        fputcsv($fh, $header);

        // 写入数据
        foreach ($data as $row) {
            fputcsv($fh, $row->toArray());
        }

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