将数据从php导出到csv

Question

正如前面提到的here那样，我正在使用这段代码。

$file = date('dmY-His');
header("Content-type: text/csv");
header("Content-Disposition: attachment; filename=visitors-$file.csv");
header("Pragma: no-cache");
header("Expires: 0");
$sql = "select id, ip, server, time, date from visitors";
$res = mysql_query($sql);
$data = array();
$data[] = array('id', 'ip', 'server', 'time', 'date');
while ($row = mysql_fetch_array($res)) {
    $data[] = array_values($row);
}

$output = fopen("php://output", "w");
foreach ($data as $val) {
    fputcsv($output, $val);
}
fclose($output);

首先，这个程序不是在我的localhost上工作，而是在server上工作得很好。为什么？

第二，我得到的数据包含两个条目，即，

+----+----+---------+---------+-----------+
| id | ip | server  | time    | date      |
+----+----+---------+---------+-----------+
| 1  | 1  | :::1    | :::1    | server1   | server1  | 10:00:00 am | 12-12-2012 |
+----+----+---------+---------+-----------+----------+-------------+------------+
| 2  | 2  | :::2    | :::2    | server2   | server2  | 10:15:00 am | 13-12-2012 |
+----+----+---------+---------+-----------+----------+-------------+------------+

Answer 1

将mysql_fetch_array()更改为mysql_fetch_assoc()。mysql_fetch_array()同时获取数据库结果的数值数组和关联数组。

while ($row = mysql_fetch_array($res)) {

至

while ($row = mysql_fetch_assoc($res)) {