当我将数据导出为csv文件并使用写字板打开文件时,myfield Sr. No。看起来像。不。我不想在sr后面加两倍的空格也不想在No后面加空格。代码如下:
$filename = "file.csv";
$fp = fopen('php://output', 'w');
$array = array('Sr. No.','Name','DOB','Address');
$header = str_replace('',' ', $array);
header('Content-type: application/csv');
header('Content-Disposition: attachment; filename='.$filename);
fputcsv($fp, $header,',',' ');
$query = "select * from registratin";
$result = mssql_query($query);
$i = 1;
while($row = mssql_fetch_row($result)) {
$row = array_merge(array($i), $row);
fputcsv($fp, $row);
$i++;
}
如果您不希望您的标题行符合CSV的规则,那么只需使用fwrite()
而不是fputcsv()
来编写一行
$headerLine = 'Sr. No,Name,DOB,Address';
fwrite($fp, $headerLine);