dtgr6303 2016-04-11 12:38
浏览 198
已采纳

PHP - 将CSV文件流式传输到浏览器

I'm having issues getting CSV files to download directly to my browser without storing the files somewhere on my server. I found a tutorial (https://www.perpetual-beta.org/weblog/php-stream-file-direct.html) but I can't seem to get it working!

This is my main function:

public function exportRecord($id) {
    $contest = (string) $this->getContest($id);
    $entries = (array) $this->getEntries($id);

    $filename = sprintf('%1$s-%2$s-%3$s', str_replace(' ', '', $contest['name']), date('Ymd'), date('His'));
    $output = fopen('php://output', 'w');

    ob_start();

    $header = array(
        'First Name',
        'Last Name',
        'Address',
        'City',
        'State',
        'Zip',
        'Phone',
        'Email',
        'Item Purchased',
        'Partner Name',
        'Partner #',
        'Date Entered',
        'Subscribe'
    );

    fputcsv($output, $header);

    foreach ($entries as $entry) {
        fputcsv($output, $entry);
    }

    $string = ob_get_clean();

    header('Pragma: public');
    header('Expires: 0');
    header('Cache-Control: must-revalidate, post-check=0, pre-check=0');
    header('Cache-Control: private', false);
    header('Content-Type: application/octet-stream');
    header('Content-Disposition: attachment; filename="' . $filename . '.csv";');
    header('Content-Transfer-Encoding: binary');

    exit($string);
}

I am calling the following two functions, which just do queries on my database...

private function getContest($id) {
    $query = sprintf(
        'SELECT name ' .
        'FROM contests ' .
        'WHERE id = %s;',
        $id
    );

    $result = $this->mysql->query($query);
    $response = '';

    if ($result) {
        while ($row = mysqli_fetch_assoc($result)) {
            $response = $row;
        }
    } else {
        echo $this->mysql->error;
    }

    return $response;
}

private function getEntries($id) {
    $query = sprintf(
        'SELECT firstName, ' .
            'lastName, ' .
            'CONCAT(address1, ", ", address2), ' .
            'city, ' .
            'state, ' .
            'zip, ' .
            'phone, ' .
            'email, ' .
            'itemPurchased, ' .
            'partnerName, ' .
            'partnerNum, ' .
            'dateEntered, ' .
            'subscribe ' .
        'FROM entries ' .
        'WHERE contestID = %s;',
        $id
    );

    $result = $this->mysql->query($query);
    $response = '';

    if ($result) {
        while ($row = mysqli_fetch_assoc($result)) {
            $response[] = $row;
        }
    } else {
        echo $this->mysql->error;
    }

    return $response;
}

I appreciate any help/advice that you'll give! Here is a screenshot, just to give you an idea of what the issue is: Screenshot Thank you!

展开全部

  • 写回答

2条回答 默认 最新

  • douhuan4699 2016-04-18 10:13
    关注

    I ended up doing this with JS.

                        } else if (action == 'export') {
                        if (result.data !== false) {
                            var data = encodeURIComponent(result.data);
                            var contest = result.contest.trim();
                            var filename = contest + '.csv';
                            var dataUri = 'data:text/csv;charset=utf-8,' + data;
                            var link = document.createElement('a');
    
                            link.setAttribute('href', dataUri);
                            link.setAttribute('download', filename);
                            document.body.appendChild(link);
                            link.click();
    
                            showMessage('Export successfully created!', 'success');
                        } else {
                            showMessage('There are no entries for this contest! Nothing to export...', 'error');
                        }
                    }
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(1条)
编辑
预览

报告相同问题?

悬赏问题

  • ¥15 损失匹配问题,求解答
  • ¥15 3500常用汉字书法体检测数据集下载
  • ¥15 odoo17在制造模块或采购模块良品与次品如何分流和在质检模块下如何开发
  • ¥15 Qt音乐播放器的音乐文件相对路径怎么写
  • ¥15 VB.NET利用摄像头拍照的程序
  • ¥15 linux下vscode设置不了字连体
  • ¥20 游戏mod是如何制作的
  • ¥15 关于#hadoop#的问题:按照老师上课讲的步骤写的
  • ¥20 有人会用这个工具箱吗 付fei咨询
  • ¥30 成都市武侯区住宅小区兴趣点