The consensus is that it is best if you DO NOT store the images as blobs in
a database. Rather, store the images in separate files and store the names
of those files in the database. Then retrieve the file names for the
database, open the image files, and then send the images to the client's
browser. Storing images as blobs tends to make the database unwieldy.
-----Original Message-----
From: Todd Moy [mailto:[EMAIL PROTECTED]]
Sent: Friday, September 14, 2001 1:46 PM
To: [EMAIL PROTECTED]
Subject: [PHP-DB] Another Image prob
I'm new at this and i'm sure that this has been answered before, but
anyway...
I am trying to retrieve images from a MySQL database. They are stored as
BLOBs with the following table format:
Database metonym_metonym - table imgs
Field Type Attributes Null Default Extra
fk_proj_id int(3) No 0
imgname varchar(30)
imgtype varchar(20)
img blob
Keyname Unique Field
PRIMARY Yes fk_proj_id
Is it possible to do this with a printf/ img src statement?
Also, I have heard some talk about header information on retrieval-> how
does this relate to retrieving an image?
Bear in mind that these images are being uploaded via HTML form
Thanks in advance
METONYM
--
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
