更新时间:2022-11-27 21:04:18
>
You'd want something like this:
$csvName = "export.csv"
$sqlQuery = 'select * from sqlserver_table';
$sqlRresult = odbc_exec($conMsSql, $sql);
$fp = fopen(csvName , 'w');
while ($export = odbc_fetch_array($sqlRresult)) {
if (!isset($headings))
{
$headings = array_keys($export);
fputcsv($fp, $headings, ',', '"');
}
fputcsv($fp, $export, ',', '"');
}
fclose($fp);