blocks|key|328776|text|我没有足够的名气回复@complex857+857解决方案。它工作得很好，但我必须在Content-Disposition头的末尾添加。如果没有它，浏览器会在文件名的末尾添加两个破折号(例如，文件将保存为"export.csv“，而不是"export.csv--")。它可能试图清理\r\n标题行末尾的内容。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|328777|正确的行应如下所示：|328778|header('Content-Disposition:+attachment;filename="'.$filename.'";');|code-block|syntax|javascript|328779|如果CSV中包含UTF-8字符，则必须通过更改Content-Type行将编码更改为UTF-8：|328780|header('Content-Type:+application/csv;+charset=UTF-8');|328781|此外，我发现使用rewind()而不是fseek()会更优雅：|328782|rewind($f);|328783|感谢您的解决方案！|328784|entityMap^0|0|0|0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|U|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|V|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|W|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|X|8|@]|9|@]|A|$]]|$1|K|3|L|5|F|7|Y|8|@]|9|@]|A|$G|H]]|$1|M|3|N|5|6|7|Z|8|@]|9|@]|A|$]]|$1|O|3|P|5|F|7|10|8|@]|9|@]|A|$G|H]]|$1|Q|3|R|5|6|7|11|8|@]|9|@]|A|$]]|$1|S|3|-4|5|6|7|12|8|@]|9|@]|A|$]]]|T|$]]

I don't have enough reputation to reply to @complex857 solution. It works great, but I had to add ; at the end of the Content-Disposition header. Without it the browser adds two dashes at the end of the filename (e.g. instead of "export.csv" the file gets saved as "export.csv--"). Probably it tries to sanitize \r\n at the end of the header line.

Correct line should look like this:

<pre><code>header('Content-Disposition: attachment;filename="'.$filename.'";');
</code></pre>

In case when CSV has UTF-8 chars in it, you have to change the encoding to UTF-8 by changing the Content-Type line:

<pre><code>header('Content-Type: application/csv; charset=UTF-8');
</code></pre>

Also, I find it more elegant to use rewind() instead of fseek():

<pre><code>rewind($f);
</code></pre>

Thanks for your solution!

blocks|key|328816|text|试试..。csv下载。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|328817|<?php+
mysql_connect('hostname',+'username',+'password');
mysql_select_db('dbname');
$qry+=+mysql_query("SELECT+*+FROM+tablename");
$data+=+"";
while($row+=+mysql_fetch_array($qry))+{
++$data+.=+$row['field1'].",".$row['field2'].",".$row['field3'].",".$row['field4']."\n";
}

header('Content-Type:+application/csv');
header('Content-Disposition:+attachment;+filename="filename.csv"');
echo+$data;+exit();
?>|code-block|syntax|javascript|328818|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Try...
csv download.

<pre><code>&lt;?php 
mysql_connect('hostname', 'username', 'password');
mysql_select_db('dbname');
$qry = mysql_query("SELECT * FROM tablename");
$data = "";
while($row = mysql_fetch_array($qry)) {
 $data .= $row['field1'].",".$row['field2'].",".$row['field3'].",".$row['field4']."\n";
}

header('Content-Type: application/csv');
header('Content-Disposition: attachment; filename="filename.csv"');
echo $data; exit();
?&gt;
</code></pre>

blocks|key|111382|text|使用以下代码将php数组转换为CSV|type|unstyled|depth|inlineStyleRanges|entityRanges|data|111383|<?php
+++$ROW=db_export_data();//Will+return+a+php+array
+++header("Content-type:+application/csv");
+++header("Content-Disposition:+attachment;+filename=test.csv");
+++$fp+=+fopen('php://output',+'w');

+++foreach+($ROW+as+$row)+{
++++++++fputcsv($fp,+$row);
+++}
+++fclose($fp);|code-block|syntax|javascript|111384|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

Use the below code to convert a php array to CSV

<pre><code>&lt;?php
 $ROW=db_export_data();//Will return a php array
 header("Content-type: application/csv");
 header("Content-Disposition: attachment; filename=test.csv");
 $fp = fopen('php://output', 'w');

 foreach ($ROW as $row) {
 fputcsv($fp, $row);
 }
 fclose($fp);
</code></pre>

blocks|key|111406|text|这就是我在我的项目中使用的函数，它按预期工作。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|111407|function+array_csv_download(+$array,+$filename+=+"export.csv",+$delimiter=";"+)
{
++++header(+'Content-Type:+application/csv'+);
++++header(+'Content-Disposition:+attachment;+filename="'+.+$filename+.+'";'+);

++++//+clean+output+buffer
++++ob_end_clean();
++++
++++$handle+=+fopen(+'php://output',+'w'+);

++++//+use+keys+as+column+titles
++++fputcsv(+$handle,+array_keys(+$array['0']+),+$delimiter+);

++++foreach+(+$array+as+$value+)+{
++++++++fputcsv(+$handle,+$value,+$delimiter+);
++++}

++++fclose(+$handle+);

++++//+flush+buffer
++++ob_flush();
++++
++++//+use+exit+to+get+rid+of+unexpected+output+afterward
++++exit();
}|code-block|syntax|javascript|111408|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|I|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|J|8|@]|9|@]|A|$E|F]]|$1|G|3|-4|5|6|7|K|8|@]|9|@]|A|$]]]|H|$]]

That is the function that I used for my project, and it works as expected.
<pre><code>function array_csv_download( $array, $filename = &quot;export.csv&quot;, $delimiter=&quot;;&quot; )
{
 header( 'Content-Type: application/csv' );
 header( 'Content-Disposition: attachment; filename=&quot;' . $filename . '&quot;;' );

 // clean output buffer
 ob_end_clean();
 
 $handle = fopen( 'php://output', 'w' );

 // use keys as column titles
 fputcsv( $handle, array_keys( $array['0'] ), $delimiter );

 foreach ( $array as $value ) {
 fputcsv( $handle, $value, $delimiter );
 }

 fclose( $handle );

 // flush buffer
 ob_flush();
 
 // use exit to get rid of unexpected output afterward
 exit();
}
</code></pre>

blocks|key|111429|text|UTF-8编码更新|type|unstyled|depth|inlineStyleRanges|entityRanges|data|111430|更新@complex857+857的答案|111431|function+array_to_csv_download($array,+$filename+=+"export.csv",+$delimiter=",")+{
++++header('Content-Disposition:+attachment;+filename="'.$filename.'";');
++++header('Content-Type:+application/csv;+charset=UTF-8');

++++//+open+the+"output"+stream
++++$f+=+fopen('php://output',+'w');
++++//+Write+utf-8+bom+to+the+file
++++fputs($f,+chr(0xEF)+.+chr(0xBB)+.+chr(0xBF));

++++foreach+($array+as+$line)+{
++++++++fputcsv($f,+$line,+$delimiter);
++++}
}++|code-block|syntax|javascript|111432|代码可能有点难看，但它是有效的！|111433|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|O|8|@]|9|@]|A|$G|H]]|$1|I|3|J|5|6|7|P|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

<h1>Update for UTF-8 Encoding </h1>
Updating @complex857 's answer
<pre><code>function array_to_csv_download($array, $filename = &quot;export.csv&quot;, $delimiter=&quot;,&quot;) {
 header('Content-Disposition: attachment; filename=&quot;'.$filename.'&quot;;');
 header('Content-Type: application/csv; charset=UTF-8');

 // open the &quot;output&quot; stream
 $f = fopen('php://output', 'w');
 // Write utf-8 bom to the file
 fputs($f, chr(0xEF) . chr(0xBB) . chr(0xBF));

 foreach ($array as $line) {
 fputcsv($f, $line, $delimiter);
 }
} 
</code></pre>
May be a bit ugly code but it works!

I am a novice programmer and I searched a lot about my question but couldn't find a helpful solution or tutorial about this.

My goal is I have a PHP array and the array elements are showing in a list on the page.

I want to add an option, so that if a user wants, he/she can create a CSV file with array elements and download it.

I don't know how to do this. I have searched a lot too. But yet to find any helpful resource.

Please provide me some tutorial or solution or advice to implement it by myself. As I'm a novice please provide easy to implement solutions.

My array looks like: 

<pre><code>Array
(
 [0] =&gt; Array
 (
 [fs_id] =&gt; 4c524d8abfc6ef3b201f489c
 [name] =&gt; restaurant
 [lat] =&gt; 40.702692
 [lng] =&gt; -74.012869
 [address] =&gt; new york
 [postalCode] =&gt; 
 [city] =&gt; NEW YORK
 [state] =&gt; ny
 [business_type] =&gt; BBQ Joint
 [url] =&gt; 
 )

)
</code></pre>

How to create and download a csv file from php script?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

我是一个新手程序员，我搜索了很多关于我的问题，但找不到关于这个问题的有用的解决方案或教程。我的目标是拥有一个PHP数组，并且数组元素显示在页面上的列表中。我想添加一个选项，这样如果用户愿意，他/她可以创建一个包含数组元素的CSV文件并下载它。我不知道该怎么做。我也搜索了很多。但是还没有找到任何有用的资源。请为我提供一些...

问如何从php脚本中创建和下载csv文件？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问如何从php脚本中创建和下载csv文件？EN