How to gzip SQL output to .gz download?

[Anon]

Hi there!!

I've got a script that dumps sql data into a csv file that the user can download.

Problem is that the data has become so much that we really need to gzip the stuff.

I tried this:

$rowvalue contains the result from the SQL statement

$filename=sprintf("blablabla.gz");

$gzrowvalue = gzcompress($rowvalue, 9);
header("Content-disposition:filename=$filename");
header("Content-type:application/gzip");
header("Pragma: no-cache");
header("Expires: 0");

echo $gzrowvalue;

But I can't unzip the downloaded file!

[[deleted]]

Check out the manual:

http://www.php.net/manual/en/function.gzcompress.php

-- quote from the manual --
Note: This is not the same as gzip compression, which includes some header data. See gzencode() for gzip compression.

-- end quote --

[Anon]

I tried using gzencode, but the function gzencode seens to be unknown...

I've got PHP 4.0.3pl1 installed with ZLib ver 1.1.3.

Would it be cheaper to create a temporary file and delete it after download?

[Anon]

While hunting for a solution, I came upon this:

http://www.php.net/manual/admin-notes.php?last_entry=1200

I think I'll revert to creating a temp file unless severe security (or speed) concerns lead me into doing that messy gzcompress() stuff.

ciao,

chris