fpassthru表现得很奇怪（发送页面html而不是我想要的文件）

问题描述：

I'm really really new to PHP, so if you can explain it to me what my code is actually doing and why the result is what it is I would appreciate very much. I'm probably screwing up something very simple.

Basically I want to query a MySQL database, create a csv with the data, and download the csv. Pretty simple. Here is my code:

<?php
    include("Includes/PHPheader.php");
    $query_string = $_SERVER['QUERY_STRING'];
    parse_str($query_string);

    $sql = "SELECT many_columns_i_removed_from_this_sample_code FROM table WHERE id = '".$id."'";
    $result = $conn->query($sql);
    $row = $result->fetch_assoc();    

    $f = fopen("csv/tmp.csv", "w");
    fputcsv($f, array_keys($row),';');
    fputcsv($f,$row,';');
    rewind($f);
    header('Content-Type: application/csv');
    header('Content-Disposition: attachment; filename="tmp.csv"');
    fpassthru($f);
    fclose($f);
?>

There are some HTML code below it that shouldn't affect anything, but just in case here it is.

<!DOCTYPE html>
<html lang="en">
    <head>
        <meta charset="utf-8" />
        <title></title>
    </head>
    <body>
    </body>
</html>

Well, I thought this would download my csv with no problem. If I go to the csv folder, there it is, the tmp.csv file I created, with the proper header and data.

But when I open the tmp.csv file I downloaded, it is actually the html code of the page, and not the data I expected.

What is going on?

In case it helps, I'm using WebMatrix 3.0.

我真的很擅长PHP，所以如果你能解释一下我的代码实际上是做什么的，为什么结果是什么我会非常感激。我可能搞砸了一些非常简单的东西。 p>

基本上我想查询MySQL数据库，用数据创建一个csv，然后下载csv。很简单。这是我的代码： p>

 ＆lt;？php 
 include（“Includes / PHPheader.php”）; 
 $ query_string = $ _SERVER ['QUERY_STRING']; \  n parse_str（$ query_string）; 
 
 $ sql =“SELECT many_columns_i_removed_from_this_sample_code FROM table WHERE id ='”。$ id。“'”; 
 $ result = $ conn-＆gt; query（$ sql）; 
  $ row = $ result-＆gt; fetch_assoc（）;  
 
 $ f = fopen（“csv / tmp.csv”，“w”）; 
 fputcsv（$ f，array_keys（$ row），';'）; 
 fputcsv（$ f，$ row，  ';'）; 
 rewind（$ f）; 
 header（'Content-Type：application / csv'）; 
 header（'Content-Disposition：attachment; filename =“tmp.csv”'）; \  n fpassthru（$ f）; 
 fclose（$ f）; 
？＆gt; 
  code>  pre> 
 
 下面有一些不会影响任何内容的HTML代码 ，但以防万一。 p> 
 
 
 ＆lt;！DOCTYPE html＆gt; 
＆lt; html lang =“en”＆gt; 
＆lt; head＆gt; 
＆lt;  meta charset =“utf-8”/＆gt; 
＆lt; title＆gt;＆lt; / title＆gt; 
＆lt; / head＆gt; 
＆lt; body＆gt; 
＆lt; / body＆gt; 
＆lt; / html＆gt; 
   code>  pre> 
 
 好吧，我认为这会下载我的csv没有问题。 如果我转到csv文件夹，那就是我创建的tmp.csv文件，带有正确的标题和数据。 p> 
 
 
但是当我打开我下载的tmp.csv文件时， 它实际上是页面的html代码，而不是我期望的数据。 p> 
 
 
发生了什么？ p> 
 
 
如果它有帮助，我 我正在使用WebMatrix 3.0。 p> 
  div>

答

There are two things going on, probably. First, You are trying to read (fpassthru) from a file opened for writing (fopen(..., "w")), so You are not able to read anything from the file. Then, after that "reading nothing" goes Your HTML code, which naturally appends to Your output. Try this:

$f = fopen("csv/tmp.csv", "w+");
...
fclose($f);
exit;

答

Could you please try?

header("Content-type: application/vnd.ms-excel");

instead of

header('Content-Type: application/csv');

I have a test code of CSV output, have a look - https://foowms.googlecode.com/svn/trunk/stockincsv.php

A very informative thread of Stack Overflow Setting mime type for excel document

==============================================

If csv file open, write and save, then you should do as follows-

$list = array ("Peter,Griffin,Oslo,Norway");
$file = fopen("csv/tmp.csv","w");

foreach ($list as $line) {
fputcsv($file,explode(',',$line));
}

fclose($file);

==============================================

You also could try this

fputcsv($fp, array_values($list), ';', ' ');

instead of

fputcsv($f, array_keys($row),';');

fpassthru表现得很奇怪（发送页面html而不是我想要的文件）

相关推荐