php - CSV 仅导出标题数组而不是数据

Question

我正在尝试使用以下代码导出和下载包含 mysql 记录的 csv 文件；

    header('Content-Type: text/csv; charset=utf-8');
    header('Content-Disposition: attachment; filename=DepReport_'.$from.'_'.$to.'.csv');

    $output = fopen('php://output', 'w');

    fputcsv($output, array('Reference',
                'Depart Date / Time',
                'Depart Terminal',
                'Depart Flight'
                )
            );

        $i = 2;
        while($rows = mysql_fetch_array($result)) {
            fputcsv($data[$i], array($rows['ReferenceNo'],          
                     date('Y-m-d',strtotime($rows['DepartDate'])).' '.$rows['DepartTime'],
                     $rows['DepartTerminal'],
                     $rows['DepartFlight']
                     )
                );
            $i++;
        }       
    fputcsv($output, $data);
    exit;

但是只得到航向数组却没有记录

需要帮助来修复代码。

问候

Answer 1

在循环中以同样的方式写出来怎么样？

header('Content-Type: text/csv; charset=utf-8');
        header('Content-Disposition: attachment; filename=DepReport_'.$from.'_'.$to.'.csv');

    $output = fopen('php://output', 'w');

    fputcsv($output, array('Reference',
                'Depart Date / Time',
                'Depart Terminal',
                'Depart Flight'
                )
            );

        $i = 2;
        while($rows = mysql_fetch_array($result)) {
            //change to $output so it writes lines to same handler
            fputcsv($output, array($rows['ReferenceNo'],          
                     date('Y-m-d',strtotime($rows['DepartDate'])).' '.$rows['DepartTime'],
                     $rows['DepartTerminal'],
                     $rows['DepartFlight']
                     )
                );
            $i++;
        }       
    //fputcsv($output, $data);
//don't need anymore
        exit;