mysql 导出 没有函数_没有MYSQL FILE函数的CSV导出

构建最佳CSV。你可以按照以下方式做。

$filename ='data.csv';

$csv_terminated = "\n";

$csv_separator = ",";

$csv_enclosed = '"';

$csv_escaped = "\\";

$results = array('1','2','3');// value

$schema_insert = '';

$header = array('a','b','c');// header

for ($i = 0; $i< count($header); $i++)

{

$l = $csv_enclosed . str_replace($csv_enclosed, $csv_escaped . $csv_enclosed,

stripslashes($header[$i])) . $csv_enclosed;

$schema_insert .= $l;

$schema_insert .= $csv_separator;

} // end for

$out = trim(substr($schema_insert, 0, -1));

$out .= $csv_terminated;

// Format the data

for($i=0;$i

{

$row = $results[$i];

$schema_insert = '';

for ($j = 0; $j < count($header); $j++)

{

if ($row[$j] == '0' || $row[$j] != '')

{

if ($csv_enclosed == '')

{

$schema_insert .= $row[$j];

} else

{

$schema_insert .= $csv_enclosed .

str_replace($csv_enclosed, $csv_escaped . $csv_enclosed, $row[$j]) . $csv_enclosed;

}

} else

{

$schema_insert .= 'NULL';

}

if ($j < count($header) - 1)

{

$schema_insert .= $csv_separator;

}

} // end for

$out .= $schema_insert;

$out .= $csv_terminated;

} // end while

header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

header("Content-Length: " . strlen($out));

// Output to browser with appropriate mime type, you choose

header("Content-type: text/x-csv");

//header("Content-type: text/csv");

//header("Content-type: application/csv");

header("Content-Disposition: attachment; filename=$filename");

echo $out;请注意，

+当你为具有html代码的描述做封闭时，你应该使用双引号。

+空值 - >更改为空文本或零值

他们会让你的CSV变得更好。