Re: Saving result to file for download - Mailing list pgsql-php

From Michael Glaesemann
Subject Re: Saving result to file for download
Date
Msg-id F136D279-08D9-11D8-9192-0005029FC1A7@myrealbox.com
Whole thread Raw
In response to Re: Saving result to file for download  (Mariusz Pekala <skoot@qi.pl>)
List pgsql-php
Hi M.P.

On Tuesday, Oct 28, 2003, at 04:56 Asia/Tokyo, Mariusz Pekala wrote:
>
> Why have you decided to store results in a file? Is that file to be
> really
> big? or takes long to prepare?

Actually the file is pretty small (less than 8K) and is pretty quick to
make (less than 2 seconds). I just didn't know how to do it any other
way.

> Maybe generating the file 'on the fly' would be easier:
>
> 1) Provide a link to a script that generates the file
> (eg: <a href="file.php?type=whatever">get file here</a>
>
> 2) The script "file.php" sets the content type header to text/plain
> and just
> outputs the result of a query. I am not sure how to set HTTP header on
> Your
> webserver (with apache there is a PHP function header(string) )

This sounds like *exactly* what I am after. I'll give it a try!

Thanks for taking the time to respond. I knew there should be a better
way but didn't know where to even start looking. I really appreciate
your help.

Michael


pgsql-php by date:

Previous
From: Mariusz Pekala
Date:
Subject: Re: Saving result to file for download
Next
From: "S.P.Vimala"
Date:
Subject: Upgrade problem with postgresql 7.3.4 and php 4.2