主页 / 问题 / 1075059
Accepted
user357670
Asked:2020-01-27 23:27:50 +0000 UTC2020-01-27 23:27:50 +0000 UTC

飞来的 csv 编码看不懂西里尔文

  • 772

控制器：

public function export (Request $request)
{
    $dateStart = $request->dateStart;
    $dateFinish = $request->dateFinish;
    $table = Orders_user::where('created_at', '>=', date($dateStart))->where('created_at', '<=', date($dateFinish))->get();
    // dd($table);
    $filename = "test2.csv";
    $handle = fopen($filename, 'w+');
    // fprintf($handle, chr(0xEF).chr(0xBB).chr(0xBF));
    fputs($handle, chr(0xEF) . chr(0xBB) . chr(0xBF)); // BOM
    @fputcsv($handle, array('sep=,'));
    fputcsv($handle, array('Imya','Telephone', 'Nomer zayavok', 'Gorod', 'Address', 'Obshaya cena', 'status', 'Vid oplaty', 'shippingttype', 'email'));

    foreach($table as $row) {
        fputcsv($handle, array(iconv('utf-8', 'windows-1251', $row['name']), 
        iconv('utf-8', 'windows-1251', $row['phone']), 
        iconv('utf-8', 'windows-1251', $row['description']), 
        iconv('utf-8', 'windows-1251', $row['city']), 
        iconv('utf-8', 'windows-1251', $row['address']), 
        iconv('utf-8', 'windows-1251', $row['totalprice']), 
        iconv('utf-8', 'windows-1251', $row['status']), 
        iconv('utf-8', 'windows-1251', $row['paymenttype']), 
        iconv('utf-8', 'windows-1251', $row['shippingttype']), 
        iconv('utf-8', 'windows-1251', $row['email'])
        ));
    }

    fclose($handle);

    $headers = array(
        'Content-Type' => 'text/csv',
    );

    return Response::download($filename, 'test.csv', $headers);
}
php

1 个回答

  1. Best Answer

    我喜欢这样：第一个标题

    $headers = array(
        "Content-type" => 'application/excel',
        "Content-Disposition" => "attachment; filename=base_"." (".date("d.m.Y").")".".csv",
        "Pragma" => "no-cache",
        "Cache-Control" => "must-revalidate, post-check=0, pre-check=0",
        "Expires" => "0"
    );

    第二

    $columns = ['Imya','Telephone', 'Nomer zayavok', 'Gorod', 'Address', 'Obshaya cena', 'status', 'Vid oplaty', 'shippingttype', 'email'];
$callback = function() use ($table, $columns)
    {
        $file = fopen('php://output', 'w');
        fputs($file, chr(0xEF) . chr(0xBB) . chr(0xBF)); // BOM
        fputcsv($file, $columns, ';','"');

        foreach($table as $row) {
            fputs($file, chr(0xEF) . chr(0xBB) . chr(0xBF));
            fputcsv($file, $row, ';','"');
        }
        fclose($file);
    };
    return \response()->stream($callback, 200, $headers);

    你明白其中的含义和区别吗...

    • 0

相关问题