CSV Export Экспорт CSV
В редакторе
CSV Export Экспорт CSV
Brain_Script
768
2019-07-12 11:36:58
<?php
/*
* Export your array to csv
* Created by Leo Watanabe <leow_74 at yahoo dot com> - August 2003
*/
// Caution: $data MUST be an array of array
function convertToExcelCSV($data) {
// Sorry, not an array...
if(!is_array($data)) { return ''; }
$csv = '';
foreach($data as $record) {
// all record must be an array
if(is_array($record)) {
// convert this record to csv
$csv .= convertArrayToCSV($record) . "rn";
}
}
return $csv;
}
// convert an array to csv
function convertArrayToCSV($record) {
// need to test because I don't have privative functions :(((
if(!is_array($record)) { return ''; }
$ret = '';
foreach($record as $field) {
if (is_array($field)) {
// convert recusively
$ret .= convertArrayToCSV($field);
}
else {
// if field has double quotes or commas
if (strpos($field,'"')!==false || strpos($field,',')!==false) {
// replace " by "", and put all inside "
// "all_field_value,_will_be_here"
$ret .= '"' . str_replace('"','""',$field) . '"';
}
else {
$ret .= $field;
}
}
// comma separated values
$ret .= ',';
}
// strip last comma
return substr($ret, 0, strlen($ret)-1);
}
?>
Войдите для добавления комментария.