RE: [PHP] Previous Discussions
Hey thanks Ian!
Could I have some examples, of say a pdf or zip?
It looks like this will work perfectly!
Dan
-Original Message-
From: Ian Samuel [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 28, 2002 9:00 AM
To: [EMAIL PROTECTED]
Subject: RE: [PHP] Previous Discussions
>>Is anyone aware of previous discussions with php/mysql with
>using file
>>inside the db (BLOBs) and integrating php to serve these files? In my
>>opinion, I'm sure there's a better way than store to a temp
>file and send
>>user the hyperlink, then deleting the temp file. Perhaps
>something with
>>output buffering, etc.
Regardless of whether this is a good idea or not, it's fairly easy. Store the file
data itself (accessible via fopen($whatever)) in a longblob, then write it back with
the appropriate headers ("Content-type: iamge/jpeg" or whatever) when the time comes.
I'd be happy to provide examples if anyone is curious.
Regards,
Ian Samuel
RE: [PHP] Previous Discussions
Title: RE: [PHP] Previous Discussions
>>Is anyone aware of previous discussions with php/mysql with
>using file
>>inside the db (BLOBs) and integrating php to serve these files? In my
>>opinion, I'm sure there's a better way than store to a temp
>file and send
>>user the hyperlink, then deleting the temp file. Perhaps
>something with
>>output buffering, etc.
Regardless of whether this is a good idea or not, it's fairly easy. Store the file data itself (accessible via fopen($whatever)) in a longblob, then write it back with the appropriate headers ("Content-type: iamge/jpeg" or whatever) when the time comes. I'd be happy to provide examples if anyone is curious.
Regards,
Ian Samuel
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] Previous Discussions
You want to try to stay away from storing anything so large in a DB like a file or an image (if the option exists). I am not aware of the previous discussion but if you send me a few details maybe I can offer an opinion.. ed At 07:54 AM 5/28/2002 -0600, Dan Vande More wrote: >Is anyone aware of previous discussions with php/mysql with using file >inside the db (BLOBs) and integrating php to serve these files? In my >opinion, I'm sure there's a better way than store to a temp file and send >user the hyperlink, then deleting the temp file. Perhaps something with >output buffering, etc. > >I'm sure this topic has come up before, but I have been unable to find any >relevant information. > >Thank you for your help > >Dan VandeMore > > >-- >PHP General Mailing List (http://www.php.net/) >To unsubscribe, visit: http://www.php.net/unsub.php -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
