pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Michael Glaesemann <grzm@myrealbox.com>
To: pgsql-php@postgresql.org
Subject: Saving result to file for download
Date: Mon, 27 Oct 2003 00:43:49 +0900
Message-ID: <315833F6-07CB-11D8-B456-0005029FC1A7@myrealbox.com> (raw)

Hi all!

I made a PHP script that formats and saves the output of a query to a 
file and provides a link to the file for download. I've never done this 
before and would appreciate any feedback. Here are things I'd like to 
improve or am concerned about.

I've looked through Sklar & Trachtenberg's 'PHP Cookbook', googled 
('PHP postgresql saving result file download' gives you a wide 
assortment of links!), and attempted to search the archives of 
pgsql-php, but I keep timing out after 60 seconds. Has anyone else been 
experiencing problems searching the archives?

1. Right now the file is permanently saved in a directory (used only 
for saving these results files, unimaginatively named /temp) in the web 
root of the server (in my case /Library/Webserver/Documents on Mac OS X 
10.2). I'd rather it be a temporary file so I wouldn't have to worry 
about clearing out the files if a lot of people generate results files. 
I'm not concerned that people won't be able to come back to the results 
file at a later date—they can just generate a new one. Perhaps I should 
make a cron job to clear out the folder every once in a while?

2. Security. I've changed the owner on /temp to www (the webserver) so 
that PHP can write to the directory. Here are the permissions.
drwxr-xr-x  23 www       admin      782 Oct 27 00:05 temp
I'm guessing I should change the permissions to drwxr--r-- (or even 
drw-r--r--) as there's no reason there should be execute permissions on 
the directory.

If anyone's curious, here's the file handling part of the code. Truly 
nothing special. If anyone would like to see anything else, I'd be 
happy to oblige.

     $docroot   = '/Library/Webserver/Documents/';
     $dir       = 'temp/';
     $path      = $docroot.$dir;
     $id_string = uniqid('',1);
     $filename = 'apps-'.$id_string.'.txt';
     $fh =fopen($path.$filename,'w') or die($php_errormsg);
     fputs($fh,$app_string);
     fclose($fh) or die($php_errormsg);
     echo 'Here\'s your file! Download now!<br />';
     echo '<a href="/'.$dir.$filename.'">'.$filename.'</a>';

As this is the first time of done anything like this, I'd appreciate 
any comments.

Thanks!

Michael



view thread (5+ messages)  latest in thread

Message-ID: <315833F6-07CB-11D8-B456-0005029FC1A7@myrealbox.com>
Permalink:  ../315833F6-07CB-11D8-B456-0005029FC1A7@myrealbox.com/
Also on:    postgresql.org/message-id/315833F6-07CB-11D8-B456-0005029FC1A7@myrealbox.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: grzm@myrealbox.com
  Subject: Re: Saving result to file for download
  In-Reply-To: <315833F6-07CB-11D8-B456-0005029FC1A7@myrealbox.com>
  References: <315833F6-07CB-11D8-B456-0005029FC1A7@myrealbox.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox