PHP array to csv - Always rewrites the file

Question

I'm trying to save 3 variables to a csv file. I get the variables data then I'm creating an array containing them. I can open the file and write it. I would like to store the following data on every page load: - referer - user agent - date

My problem is that on every page load it rewrites the file instead of just inster the new data.

Any idea? Every comment is appreciated.

<?php

session_start();

if ( !isset( $_SESSION["origURL"] ) )
$_SESSION["origURL"] = @$_SERVER["HTTP_REFERER"];

$referer = @$_SERVER['HTTP_REFERER'];
$userAgent = @$_SERVER['HTTP_USER_AGENT'];
$date = date('Y-m-d H:i:s');

$visitorData = array("referer", "userAgent", "date");
$result = compact($visitorData);
print_r($result);

$fp = fopen('file.csv', 'w');

foreach ($result as $fields) {
    fputcsv($fp, $result, $delimiter = ',', $enclosure = '"');
}

fclose($fp);
exit();

?>

append mode use - $fp = fopen('file.csv', 'a');

splash58
– splash58

2016-07-03 11:54:47 +00:00
Commented Jul 3, 2016 at 11:54 — splash58
– splash58, Commented Jul 3, 2016 at 11:54

ClementNerma · Accepted Answer · 2016-07-03 11:58:16Z

1

As @splah58 says, you must open your file in append mode to add data, like this :

if( !isset( $_SESSION["origURL"] ))
  $_SESSION["origURL"] = @$_SERVER["HTTP_REFERER"];

$referer = @$_SERVER['HTTP_REFERER'];
$userAgent = @$_SERVER['HTTP_USER_AGENT'];
$date = date('Y-m-d H:i:s');

$visitorData = array("referer", "userAgent", "date");
$result = compact($visitorData);
print_r($result);

$fp = fopen('file.csv', 'a'); // 'a' means 'append' instead of 'w' for 'writing' which always delete the file's content

foreach ($result as $fields) {
  fputcsv($fp, $result, $delimiter = ',', $enclosure = '"');
}

fclose($fp);
exit();

answered Jul 3, 2016 at 11:58

ClementNerma

1,1111 gold badge11 silver badges16 bronze badges

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

7 Comments

Gyorgy Over a year ago

You are right! Thank you! I experienced one more weird behavior. Do you have any idea why does it log 3 times a row in one session?

ClementNerma Over a year ago

That's because the PHP page is loaded 3 times in one session :)

Gyorgy Over a year ago

I mean one page load = 3 lines of data.

ClementNerma Over a year ago

$result may contains 3 content

Gyorgy Over a year ago

When I print it I get this: Array ( [referer] => localhost:8088/php-log/ref.html [userAgent] => Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/51.0.2704.103 Safari/537.36 [date] => 2016-07-03 18:39:51 )

|

Collectives™ on Stack Overflow

PHP array to csv - Always rewrites the file

1 Answer 1

7 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Related