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:

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

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!