How to create CSV file using PHP? (code example)

CSV (Comma Separated Values) is one of the most common methods of transferring tabular data between applications; creating code to export data to CSV can be useful in many applications. The following article will show you how to use PHP to create CSV files. I hope it will be helpful to you.

The following is a detailed introduction through code examples:

Creating CSV files using static data

If you want to store the data into a csv file, you can use code similar to the following:

<?php
// 创建并打开“demosaved.csv”文件进行写入
$file = fopen(&#39;demosaved.csv&#39;, &#39;w&#39;);
 
// 保存列标题
fputcsv($file, array(&#39;Column 1&#39;, &#39;Column 2&#39;, &#39;Column 3&#39;, &#39;Column 4&#39;, &#39;Column 5&#39;));
 
// 样本数据，这可以从MySQL中获取
$data = array(
array(&#39;Data 11&#39;, &#39;Data 12&#39;, &#39;Data 13&#39;, &#39;Data 14&#39;, &#39;Data 15&#39;),
array(&#39;Data 21&#39;, &#39;Data 22&#39;, &#39;Data 23&#39;, &#39;Data 24&#39;, &#39;Data 25&#39;),
array(&#39;Data 31&#39;, &#39;Data 32&#39;, &#39;Data 33&#39;, &#39;Data 34&#39;, &#39;Data 35&#39;),
array(&#39;Data 41&#39;, &#39;Data 42&#39;, &#39;Data 43&#39;, &#39;Data 44&#39;, &#39;Data 45&#39;),
array(&#39;Data 51&#39;, &#39;Data 52&#39;, &#39;Data 53&#39;, &#39;Data 54&#39;, &#39;Data 55&#39;)
);
 
// 保存每一行数据
foreach ($data as $row)
{
fputcsv($file, $row);
}
 
// 关闭文件
fclose($file);
?>

Code description

Line 3: Open File, named "demosaved.csv", for writing. Make sure the server can write to the location where this file is saved

Line 6: Add column headers. If you don't want any column headers, you can skip this step.

Lines 9-15: Indicates the data to be stored in the file. If you want to get data from mysql, you must use code to connect to the database and get the data, and then replace these lines to

Lines 17-21: Iterate through each row of data and save the data

Line 24: Close the file. After we finish writing all the data to the file, we need to close the file.

Get data from mysql to create and automatically download CSV files

<?php
// 设置输出标头，以便下载文件
header(&#39;Content-type: text/csv&#39;);
header(&#39;Content-Disposition: attachment; filename="demo.csv"&#39;);
 
// 不缓存文件
header(&#39;Pragma: no-cache&#39;);
header(&#39;Expires: 0&#39;);
 
// 创建连接到输出流的文件指针
$file = fopen(&#39;php://output&#39;, &#39;w&#39;);
 
// 打开数据库连接
$link = mysqli_connect(&#39;localhost&#39;, &#39;my_user&#39;, &#39;my_password&#39;, &#39;my_db&#39;);
 
//查询数据库
$query = &#39;SELECT field1, field2, field3, field4, field5 FROM table&#39;;
 
if ($rows = mysqli_query($link, $query))
{
// 保存每一行数据
while ($row = mysqli_fetch_assoc($rows))
{
fputcsv($file, $row);
}
//自由结果集
mysqli_free_result($result);
}
// 关闭连接
mysqli_close($link);
?>

Code Description:

Because we want to download the file, we have to send some headers (lines 3 and 4) to tell the browser to download the file.

Line 3: Tell the browser that the MIME type of the content is text/csv, since we are sending a csv file

Line 4: Send the header "Content-Disposition" with its value is "attachment" and the file name is "demo.csv". This will tell the browser to download a file called "demo.csv" instead of displaying it.

Lines 7 and 8: Tell the browser not to cache the file. This is useful if we send multiple files with the same name, otherwise this is not necessary

Line 11: Represents opening the file pointer to send data

Line 14 ~ Line 30: From mysql Get data

Note:You need to make sure to change the connection parameters and queries of the database. Additionally, this database-related code is just an example. In a real application it might be in a different file and there should also be error handling.

The above is the entire content of this article, I hope it will be helpful to everyone's study. For more exciting content, you can pay attention to the relevant tutorial columns of the PHP Chinese website! ! !

The above is the detailed content of How to create CSV file using PHP? (code example). For more information, please follow other related articles on the PHP Chinese website!