insert an image into mysql

itaym02

Greetings,

Can I insert an Image into a MySql db?
How would I do it with php (what var can hold an image), and what format is best to save the image as.

Thanks
I M

Phrank

Works quite well.

Here is a mysql database I use to hold images.

Hope it helps. (Note. You can look in the php documentation on-line to see how big a field the blob and mediumblob are). I put thumbnails in blobs and larger images in mediumblobs.

images CREATE TABLE images ( ImageID int(7) NOT NULL auto_increment, ImageType varchar(100) default NULL, ImageSize int(10) default NULL, Description varchar(200) default NULL, Image mediumblob, Thumbnail blob, OriginalFileName varchar(100) default NULL, AdditionalImage char(1) default NULL, Code1 varchar(20) NOT NULL default '', Code2 varchar(20) default NULL, Code3 varchar(20) default NULL, Code4 varchar(50) default NULL, Code5 varchar(200) default NULL, Code6 float(10,2) default NULL, Code7 int(10) default NULL, Code8 blob, CreatedBy varchar(20) default NULL, DateCreated varchar(20) default NULL, ModifiedBy varchar(20) default NULL, DateModified varchar(20) default NULL, PRIMARY KEY (ImageID,Code1) ) TYPE=MyISAM

Phrank

You will find several good tutorials about storing images in mysql.

Try:

http://www.onlamp.com/pub/a/onlamp/2002/05/09/webdb2.html

For a start.

itaym02

Thanks

I will start the tutorial now.
Does it also cover the subject on how to read images from DB and show them?

(If you have an example, I will appreciate it)

Thanks again
I M

Drakla

Why do you want to store the images in the DB? There are loads of reasons not to store images in a database, do a search here and you'll find plenty of info on how to do it, and how not to do it.

itaym02

I need the simplest way to have my users see only the images i want them to see from a list of images.
Each user should see diffrent list of images.

I am open to any idea.

rikmoncur

I've never put an image into a db.
I just put the filename or the path/filename and keep the images in a normal web folder.

This works ok if you know the paths beforehand but I'd imagine on a large, convoluted website it might be more convenient to have the images called from the db.

itaym02

Ok - tahnks

Do you see any ineficiency in this way (images from db)?
I expect the db to increase in size in time,
But the movment in the site is expected to be very small. 100 a day (And I exagerate).

regards