export data to csv from php

Question

I'm using this code as mentioned 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);

First of all, this program in not working on my localhost but works fine on server. Why?
Second, the data I'm getting contains double entries, i.e.,

+----+----+---------+---------+-----------+
| 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 |
+----+----+---------+---------+-----------+----------+-------------+------------+

Enable error reporting and see if outputs any error messages. doesn't work alone isn't going to be useful if you want accurate answers. — Amal
– Amal, Commented Sep 25, 2013 at 13:42

John Conde · Accepted Answer · 2013-09-25 13:41:56Z

1

Change mysql_fetch_array() to mysql_fetch_assoc(). mysql_fetch_array() fetches both a numeric and associative array of the database results.

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

to

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

answered Sep 25, 2013 at 13:41

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Amal Over a year ago

I don't know what the real issue is but the OP said not working on my localhost but works fine on server

Collectives™ on Stack Overflow

export data to csv from php

1 Answer 1

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Linked

Related