[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. 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
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
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
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
