Hi all,

Does anybody knows how to make a CSV (comma separated values) file with
PHP based on results fetched from MySQL? I need it to import it with
Microsoft Outlook Express.

Thanks in advanced,

Cesar Aracena
www.icaam.com.ar

csv file format as follows:
value,"value\" with quotes",value with space,value<CR>
with optional column headings on the first line. the <CR> is a actual
carriage return "\n".

I'm not sure what you mean by importing it with OE.


Curt.

You could do something like:

$result = mysql_query($query) or die(mysql_error()); // don't display
errors on production machines
$first = TRUE;
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");
}

That is pseudo code though. (i.e. I don't have time to test it and
debug it and make it nice and neat and readable and conform to your
specifications -- but it should give you a good idea of how to start).

-Dan

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));
}

: On Fri, 10 Oct 2003 18:38:04 -0300, Cesar Aracena <lists@icaam.com.ar> : wrote:
: >
: >Does anybody knows how to make a CSV (comma separated values) file
: >with PHP based on results fetched from MySQL? I need it to import it
: >with Microsoft Outlook Express.
:
: csv file format as follows: :
: value,"value\" with quotes",value with space,value<CR>

What about values with commas?

doh!

"value, with comma"


Curt
--
"My PHP key is worn out"

PHP List stats since 1997:
http://zirzow.dyndns.org/html/mlists/