[SOLVED] How To Write Id On CSV File

[refiking]

I need to insert an id on each row of a csv file that is auto-increment and I need it to be the first column.  Is there a way in PHP that I can do this?

[ratcateme]

$file = file("file.csv");
for($i = 0;$i < count($file); $i++){
    $file[$i] = ($i+1) . "," . $file[$i];
}
file_put_contents("file.csv",implode("\r\n",$file));

should do it

 

Scott.

[refiking]

Here's what that returned:

 

Call to undefined function: file_put_contents()

 

Here's the script used:

<?php
$file = file("file.csv");
for($i = 0;$i < count($file); $i++){
    $file[$i] = ($i+1) . "," . $file[$i];
}
if(file_put_contents("file.csv",implode("\r\n",$file))){
Echo 'Successful';
}
ELSE{
Echo 'Uh Oh!';
}
?>

[ratcateme]

try

<?php
$file = file("file.csv");
for($i = 0;$i < count($file); $i++){
    $file[$i] = ($i+1) . "," . $file[$i];
}
//
if($fh = fopen("file.csv","w")){
    fwrite($fh,implode("\r\n",$file));
    echo 'Successful';
    fclose($fh);
}else{
    echo 'Uh Oh!';
}
?>

 

Scott.

[refiking]

What does this mean?

 

Allowed memory size of 12582912 bytes exhausted (tried to allocate 7262 bytes)

[ratcateme]

how big is the csv file?

what is the line number?

 

Scott.

[refiking]

5MB

There are hundreds of lines and each one needs an id

[ratcateme]

try adding

ini_set("memory_limit","64M");

to the top it looks like the script is running out of memory as it is only allowed 12MB

[refiking]

Ok.  So, it added the id perfectly.  Only problem is it created an additional line between rows.  Any way to do it without those rows there?

[ratcateme]

try changing

fwrite($fh,implode("\r\n",$file));
to
fwrite($fh,implode($file));

 

Scott.