How to convert an array to CSV file in PHP ?
To convert an array into a CSV file we can use fputcsv() function. The fputcsv() function is used to format a line as CSV (comma separated values) file and writes it to an open file. The file which has to be read and the fields are sent as parameters to the fputcsv() function and it returns the length of the written string on success or FALSE on failure.
fputcsv( file, fields, separator, enclosure, escape )
After running the above PHP program you can find a file named
persons.csv in the same directory where the program file is located. When you open this file with a CSV file reader application like Microsoft Excel you’ll see the contents as shown in the below image.
Example 2: Suppose you want to put all the form inputs in a CSV file then first create a form to take input from the user and store it into an array. Then convert the array element into csv file.
- Input form:
- Input data display in excel as output: