Re: CSV file with PHP

On Fri, 10 Oct 2003 18:09:14 -0400, Dan Anderson <dan@mathjunkies.com> wrote:

while ($line = mysql_fetch_array($result)) { if ($first)

{     foreach ($line as $key => $value)

{ if ($first) { fwrite($file_handle, $key); $first = FALSE; } else { fwrite($file_handle, ", $key"); } } fwrite ($file_handle, "\n"); } $number1 = TRUE; foreach ($line as $value) { if ($number1) { fwrite ($file_hande, $value); $number1 = FALSE; } else { fwiret ($file_hande, ", {$value}"; }; } fwrite ($file_handle, "\n"); }

Here is a little more efficient code: if ($row = mysql_fetch_assoc($result)) { $line = ''; foreach ($row as $key => $value) { $line .= "$key,"; } fwrite($file_handle, substr($line, 0, -1)."\n"); do { $line = ''; foreach ($row as $value) {

     if (strpos($value, '"') ) {
       $line .= sprintf('"%s",', str_replace('"', '\\"', $value));
     } else {
       $line .= "$value,";
     }

} fwrite($file_handle, substr($line, 0, -1)."\n"); } while ($line = mysql_fetch_assoc($result)); }