From: operationsengineer1@yahoo.com
To: Frank Bax <fbax@sympatico.ca>
To: pgsql-php <pgsql-php@postgresql.org>
Subject: Re: Automatically opening pdf files stored in a bytea
Date: Tue, 11 Oct 2005 08:52:37 -0700 (PDT)
Message-ID: <20051011155237.26375.qmail@web33302.mail.mud.yahoo.com> (raw)
In-Reply-To: <5.2.1.1.0.20051011072754.03649050@pop6.sympatico.ca>
--- Frank Bax <fbax@sympatico.ca> wrote:
> At 06:58 AM 10/11/05, Adam Witney wrote:
> >I have PDF files stored in a bytea field in the
> database and I want to all
> >the user to click a link on the web page and have
> the file automatically
> >opened in acrobat (or whatever they have set to
> read the pdf). It works for
> >most browsers except for in Internet Explorer on
> windows (surprise
> >surprise!). Here is my code
> >
> > header("Content-type: application/pdf");
> > header('Content-Disposition: attachment;
> > filename="'.$data['filename'].'"');
>
>
> Here's mine...
> if(isset($_SERVER['HTTP_USER_AGENT']) &&
>
> strpos($_SERVER['HTTP_USER_AGENT'],'MSIE'))
> header('Content-Type:
> application/force-download');
> else
> header('Content-Type:
> application/octet-stream');
> header('Content-Length:
> '.strlen($this->buffer));
> header('Content-disposition: attachment;
> filename="'.$name.'"');
>
>
> But on a some systems (both Win98 & WinXP), user
> must save/open instead of
> open directly - haven't figured out why yet.
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org
i have had very good success storing links to pdf
files in the database and storing the actual files in
the locations pointed to by the link.
my application is work instructions - i have a naming
convention that i use so once you know the part
number, you know the name of the pdf if it exists.
i have two types of pdf documents and a name prefix
differentiates them from each other.
both firefox and ie will open these pdfs as expected.
if this approach makes sense for your application, you
may want to try it.
__________________________________
Start your day with Yahoo! - Make it your home page!
http://www.yahoo.com/r/hs
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: operationsengineer1@yahoo.com, fbax@sympatico.ca
Subject: Re: Automatically opening pdf files stored in a bytea
In-Reply-To: <20051011155237.26375.qmail@web33302.mail.mud.yahoo.com>
References: <5.2.1.1.0.20051011072754.03649050@pop6.sympatico.ca> <20051011155237.26375.qmail@web33302.mail.mud.yahoo.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