i want to remove the Upload
, and change 0 to 888 in qty
column,
the following is my code, it make the csv
file content disordered. how to correct my code. thank you
$dir = getcwd();
$files = scandir($dir);
foreach ($files as $file)
{
$parts = pathinfo($file);
if($parts['extension']!="csv") continue;
if (($handle = fopen($file, "r")) !== FALSE)
{
$new_content = implode(',', fgetcsv($handle, 1000, ","))."
";
while (($data = fgetcsv($handle, 1000, ",")) !== FALSE)
{
$data[12]=substr($data[12],9);
$data[13]=substr($data[13],9);
$data[14]=substr($data[14],9);
$data[42]=888;
$new_content .= implode(',', $data)."
";
}
fclose($handle);
file_put_contents($file, $new_content);
}
}
the test csv file http://phplist.xxmn.com/women.csv