Writing Images to MySQL 4.x

[jackpod]

Hi,
I have been trying to write an image to a database table BLOB field in
MySQL but when I try to retrieve the image to display it, it shows as
being empty. Are there any special considerations I need to take into
account when reading and writing images to a DB? Thanks.

[Petr Vileta]

jackpod wrote:

Hi,
I have been trying to write an image to a database table BLOB field in
MySQL but when I try to retrieve the image to display it, it shows as
being empty. Are there any special considerations I need to take into
account when reading and writing images to a DB? Thanks.

Writing images into database is not good idea expect if the images are very
small. Better is to create some upload directory and save images here. Into
database you write the (generated) filenames only. The procedure is some
like this:

IF file is attached (uploaded)
genetare new unique filename
get file extension from original filename
save attached file into upload directory as
generated_filename.original_extension
put new filename into some table
ENDIF

And procedure for viewing in browser is like this

IF ! EMPTY(filename in table)
echo "<img src=\"upload_directory/$filename\">";
ENDIF

--

Petr Vileta, Czech republic
(My server rejects all messages from Yahoo and Hotmail. Send me your mail
from another non-spammer site please.)

[Jerry Stuckle]

jackpod wrote:

Hi,
I have been trying to write an image to a database table BLOB field in
MySQL but when I try to retrieve the image to display it, it shows as
being empty. Are there any special considerations I need to take into
account when reading and writing images to a DB? Thanks.

There shouldn't be a problem with storing it in the database and
retrieving it later. Can you post the code you're using so we can take
a look at it?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[Andy Hassall]

On 12 Sep 2006 06:31:44 -0700, "jackpod" <jo*******@gmail.comwrote:

I have been trying to write an image to a database table BLOB field in
MySQL but when I try to retrieve the image to display it, it shows as
being empty. Are there any special considerations I need to take into
account when reading and writing images to a DB? Thanks.

One thing to consider is that BLOB only stores up to 64kB, which may not be
big enough. But as Jerry says, you should post some code.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool

[jackpod]

Thanks all for your replies. I have been able to read and write images
to the db successfully. I ended up using longblob type and things
worked ok. thanks.
Andy Hassall wrote:

On 12 Sep 2006 06:31:44 -0700, "jackpod" <jo*******@gmail.comwrote:

I have been trying to write an image to a database table BLOB field in
MySQL but when I try to retrieve the image to display it, it shows as
being empty. Are there any special considerations I need to take into
account when reading and writing images to a DB? Thanks.

One thing to consider is that BLOB only stores up to 64kB, which may not be
big enough. But as Jerry says, you should post some code.

--
Andy Hassall :: an**@andyh.co.uk :: http://www.andyh.co.uk
http://www.andyhsoftware.co.uk/space :: disk and FTP usage analysis tool