php - 将mysql数据导出到csv文件

Question

我正在尝试将mysql数据导出到csv文件中，但问题是csv文件显示字段名称而不是csv文件中的字段数据。

这是我的 php 代码

<?php

error_reporting(0);

include"../connection.php";
$output = fopen('php://output', 'w'); 

$query = "SELECT 'claim_dateclaim','claim_clientname', 'claim_account', 'claim_contract', 'claim_parcelno', 'claim_refno', 'claim_datecollected', 'claim_coladdress', 'claim_colpostcode', 'claim_counsineaddres', 'claim_conpostcode', 'claim_retailvalue', 'claim_claimvalue', 'claim_protitle', 'claim_reason', 'claim_type', 'claim_repparcelno'  FROM tbl_claimdetail ";

$rows = mysql_query($query );

fputcsv($output, array('Claim Date Raised','Client Name','Account no','Contract Number','Parcel Number','Company','Claim Ref no','Collection Date', 'Collection Address','Collection Postal code','Consignee Address','Consignee Post Code','Retail value','Claim value','Product','Reason','Type','Replacement no'));

while ($row = mysql_fetch_assoc($rows)) {
    fputcsv($output, $row);
}
fclose($output);

header("Content-type: text/csv; charset=utf-8'");
header("Content-Disposition: attachment;   filename=discussdesk".date('dmY').".csv");
header("Pragma: no-cache");
header("Expires: 0");
print "$header\n$data";

?>

这是我的 csv 文件

[![enter image description here][1]][1]


 [1]: http://i.stack.imgur.com/9GNh6.jpg

Answer 1

用途:

while ($row = mysql_fetch_array($result,MYSQL_ASSOC)) {
    fputcsv($fp, array_values($row));
}

关联数组将与 array_values 一起使用