Re: Tutorial/Example of Insert/Select PDF Postgres DB ?

From: Chris <dmagick(at)gmail(dot)com>
To: ben wilko <wilko_ben(at)hotmail(dot)com>
Cc: pgsql-php(at)postgresql(dot)org
Subject: Re: Tutorial/Example of Insert/Select PDF Postgres DB ?
Date: 2006-10-09 05:28:33
Message-ID: 4529DE01.7040003@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

ben wilko wrote:
> Hi Guys
>
> I am looking for an examples on how to insert a PDF file into Postgres
> DB and also selecting it so that someone can download it from a page.

You would be much better off storing the path to the file (or just the
filename) in the database, leaving the file itself on the filesystem and
password protecting the downloads folder with a .htaccess file or something.

You could then have something like download.php?file=filename.txt and go
from there (it would use fpassthru to just spit the file out to the
browser etc)..

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-php by date

  From Date Subject
Next Message Chris 2006-10-09 05:51:46 Re: Tutorial/Example of Insert/Select PDF Postgres DB ?
Previous Message ben wilko 2006-10-09 04:53:32 Tutorial/Example of Insert/Select PDF Postgres DB ?