amending data before writing to CSV

phpdeano

Hi All,

I am trying to create a csv file that can be sent as a datafeed to a website on behalf of my client. The data written to the csv file comes from the clients database (MySQL) and I am using the following script.

$handle = fopen("dstock.csv","w");  //local file

$sql = "select regnum, manu, model, spec, year, regnum, colour, blank, miles, price, gears, blank, fuel, doors, cc, regnum, blank, extra from stock";
$result = mysql_query($sql);
$count = mysql_num_fields($result);
   while ($rows = mysql_fetch_array($result))
   {
     fwrite($handle,'"","",');
     for ($i=0;$i<$count;$i++){
       fwrite($handle, '"'.$rows[$i].'",');  //data
     }
     fwrite($handle,("\n"));  //new line
  }

fclose($handle);

That bit works fine, however, I need to amend some of the data in the CSV and I am not sure how to do it. Basically the field for 'gears' may have a character 'a', which in the CSV needs to read 'Automatic'.

There are several fields that need amending and I wondered if anyone could point me in the right direction.

I am currently considering writing the csv file back into a different table and changing it as I write it back.

Is that the best way? Any suggestions would be most welcome.

Thanks

AstroTeg

Maybe I missed something, but why not just make the changes before writing out to the CSV file?

       while ($rows = mysql_fetch_array($result))
       {
         // // //   MAKE CHANGES HERE   // // //

     fwrite($handle,'"","",');
     for ($i=0;$i<$count;$i++){
       fwrite($handle, '"'.$rows[$i].'",');  //data
     }
       // // //   OR MAKE CHANGES HERE IF APPENDING  // // //
   fwrite($handle,("\n"));  //new line
  }

phpdeano

This may sound a little dumb but I am not sure how to make changes in the places you suggest.

Lets say, for instance, the 15th field (cc) may need to be trimmed to 3 characters, if it ends with a zero.

How would I do that. I have tried a few things but can not get it to work. I understand how to trim it, just not how to write the code within the loop.

Some pointers would be much appreciated as I need to send the datafile tonight.

Thanks

AstroTeg

You'll want to read up on some for() loop tutorials.

Its not rough.

for([initialization], [continue looping until this criteria is false], [before starting next loop iteration, do something])

So you've got $i.

When $i is 12 (aka: the 13th field), you can work your magic.

You might use a switch statement where

switch($i)
{
  case 12:
    // do something to 13th field
    break;
}  // end

Then keep adding case statements on a per field basis as you need them.

phpdeano

Thank you very much for the pointer.

I appreciate the help.