Re: blob

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



it's very useful to store images in the db then
in the other page show the image by selecting it then
print it out to the page with "Content-type: image" (jpeg/gif/etc) header;
But, i didn't find how to show pdf binary file so that the browser
can directly call acrobat reader to show it,
i tried to use content-type : application/pdf but it failed!
i think maybe in the pdf cases,
browser called acrobat reader because of its extension (pdf),not because
the header is it true?
could someone help me?

Luke Woollard writes:
I agree with Dave. I wrote an application to allow a client to upload/manage
images and categorise them into diff. parts of their website.
Images were stored as normal image files after upload and a pointer made to
them from the appropriate database record (which had additional image info
e.g. description)
Since I now have to move this website to a new server -> transferring all
these files was a bit annoying. Storing them as binary data in mysql would
have been easier to manage...



-----Original Message-----
From: David Smith [mailto:DavidSmith@byu.net]
Sent: Wednesday, 8 January 2003 10:19 AM
To: php-db@lists.php.net
Subject: Re: Re: blob

On Tue, 2003-01-07 at 15:52, Jeffrey_N_Dyke@Keane.com wrote:
I agree with this method.  i have not yet seen an advantage of storing
blobs in a database.  Is there one?  i'm sure those on this list would
have
an opinion if there was one.  personally, i like storing all this stuff on
the file system.
There is one advantage. You must either chown the upload directory to
the user that your web-server runs as, or chmod it to be world-writable.
When creating a web-application that you plan to distribute (like
Slashcode), you can't assume that your users will have that privilege.
So, storing it in MySQL is a great option.
--Dave

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


&$BS
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux