A CSV referred to Comma separated values. This is widely supported format for transferring data between applications. Data can be exported with a .CSV file and it also can be imported by uploading .CSV file. However, in this blog we’ll see the implementation of CSV exports using php. Implementing a code for exporting data to CSV is useful in many applications. We have written this code in our product JGive to export donor data.
Note: This blog is purely targeted to developers!
Here goes the code:
<?php $csvExport = null; // Column name separated by using semicolon(;) as a delimiter $csvExport .= 'Id;Donor Name;Campaign Name;Donation amount'; $csvExport .= "\n"; // Code to write and download xsl file using php header("Content-type: application/vnd.ms-excel"); // Set file name $fileName = 'student-report'.date("Y-m-d"); header("Content-disposition: filename=" . $fileName . ".csv"); // Append 1st record, each column value separated by semicolon $csvExport .= '1;David;Go Green Save Earth;$100'; // Add new line after each record $csvExport .= "\n"; // Append 2nd record $csvExport .= '2;Josh;Health and Humanity;$50'; // Discards the contents of the output buffer. ob_clean(); // Echo the csv data echo $csvExport."\n"; exit(); ?>
I hope this will help you implement it in your products!