why can't update the record in the csv file

[runeveryday]

There are 50 csv files. each csv file have the same column's name. some content in the column are the same, some don't.

eg：test1.csv, example1.csv, hello.csv, world.csv.......test70.csv.
now, i want to make a change to two column's content.

a, all csv files have a column named qty. whose rows content are all 0. now, i want to change it into

 888

b, all csv files have a column named image. whose rows content are all

 upload/img1.jpg
 upload/img2.jpg
 upload/img3.jpg
 upload/img01.jpg
 upload/img14.jpg
 upload/img01.jpg
.......

If i open each csv file then do a search and replace. i fell it too bored.

Thank you in advance.


i want to delete Uploadin the image column, change 0 to 888 in the qty column.

i using the file change.php to update the record.

one csv file. http://phplist.xxmn.com/women.csv



the code:

<?php
$dir    = getcwd();
$files = array_diff(scandir($dir), array('..', '.','change.php'));
foreach ($files as $file) {
    if (($handle = fopen($file, "r")) !== FALSE) {
        $new_content = '';
        while (($data = fgetcsv($handle, 100000, ",")) !== FALSE) {
            //var_dump($data);
           $data[2]=888; 
            $new_content .= implode(',', $data);
            //var_dump($new_content);
        }
       file_put_contents($file, $new_content);
        echo 'down';
    }
}

?>

the code doesn't work how to correct it . thank u

[Fou-Lu]

I'd say stick with the csv handling, and read and write the entire block.

PHP Code:

if (false !== ($fp = fopen($file, 'w+')))
{
    $aData = array();
    while (false !== ($line = fgetcsv($handle)))
    {
        $line[2] = 888;
        $aData[] = $line;
    }
    ftruncate($fp, 0);
    rewind($fp);
    foreach ($aData AS $fields)
    {
        fputcsv($fp, $aData);
    }
    fclose($fp);
} 


Give that a test.

[runeveryday]

Originally Posted by Fou-Lu

I'd say stick with the csv handling, and read and write the entire block.

PHP Code:

if (false !== ($fp = fopen($file, 'w+')))
{
    $aData = array();
    while (false !== ($line = fgetcsv($handle)))
    {
        $line[2] = 888;
        $aData[] = $line;
    }
    ftruncate($fp, 0);
    rewind($fp);
    foreach ($aData AS $fields)
    {
        fputcsv($fp, $aData);
    }
    fclose($fp);
} 


Give that a test.

i put this code in. it's an infinite loop. what's wrong with my code?

<?php
$dir    = getcwd();
$files = array_diff(scandir($dir), array('..', '.','change.php'));
foreach ($files as $file) {
if (false !== ($fp = fopen($file, 'w+')))
{
    $aData = array();
    while (false !== ($line = fgetcsv($handle)))
    {
        $line[42] = 888;
        $aData[] = $line;
    }
    ftruncate($fp, 0);
    rewind($fp);
    foreach ($aData AS $fields)
    {
        fputcsv($fp, $aData);
    }
    fclose($fp);
}
}

[Fou-Lu]

Nothing, I biffed it bad.
Test this one:

PHP Code:

if (false !== ($fp = fopen($file, 'r+')))
{
    $aData = array();
    while (false !== ($line = fgetcsv($fp)))
    {
        $line[2] = 888;
        $aData[] = $line;
    }
    ftruncate($fp, 0);
    rewind($fp);
    foreach ($aData AS $fields)
    {
        fputcsv($fp, $fields);
    }
    fclose($fp);
}