Remove first line in CSV and then save the file overwriting existing

Question

I have a CSV file which is generated dynamically. I want to remove the first line of CSV and then save it again.

I have googled and was able to get first line of csv but the part of writing it again after removing is where I am stuck.

Here is example

line1,data1
line2,data2
line3,data3

What I want to acheive

line2,data2
line3,data3

That is first line removed and file saved again

Here is my code

$file = fopen('words.csv', 'r');
$data = fgetcsv($file,10000,",");
$data = array_shift($data);
$file = fopen('words.csv', 'w');
fputcsv($file,$data,",");
fclose($file);

I get this: ! ) Warning: fputcsv() expects parameter 2 to be array, string given in C:\wamp\www\scrape\test.php on line 7

And output file is empty.

Ahmar

Answer 1

// Read the file
$file = fopen('words.csv', 'r');

// Iterate over it to get every line 
while (($line = fgetcsv($file)) !== FALSE) {
  // Store every line in an array
  $data[] = $line;
}
fclose($file);

// Remove the first element from the stored array / first line of file being read
array_shift($data);

// Open file for writing
$file = fopen('words.csv', 'w');

// Write remaining lines to file
foreach ($data as $fields) {
    fputcsv($file, $fields);
}
fclose($file);