我应该如何在 csv 导出中用"-"替换任何空值 - PHP

Question

public function exportCsv()
{
$this->download_send_headers("subscriber_list_export_" . date("Y-m-d") . ".csv");
$model = $this->getModel('clientsdatas');
$array = $model->getCsvArray();
echo $this->array2csv($array);  
die();
}
function array2csv(array &$array)
{
if (count($array) == 0) {
return null;
}
ob_start();
$df = fopen("php://output", 'w');
fputcsv($df, array_keys(reset($array)));
foreach ($array as $row) {
$row['id'] = '="' . $row['id'] . '"';
fputcsv($df, $row);
}
fclose($df);
return ob_get_clean();
}
function download_send_headers($filename) {
// disable caching
$now = gmdate("D, d M Y H:i:s");
header("Expires: Tue, 03 Jul 2001 06:00:00 GMT");
header("Cache-Control: max-age=0, no-cache, must-revalidate, proxy-revalidate");
header("Last-Modified: {$now} GMT");

// force download  
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");

// disposition / encoding on response body
header("Content-Disposition: attachment;filename={$filename}");
header("Content-Transfer-Encoding: binary");
}
}

Answer 1

如果你认为问题是PHP或CSV，你可能没有注意数据源，因为你可以根据需要查询数据，而不必操作数组：

CASE WHEN column IS NULL THEN "-" ELSE column END AS column