how can I save picture files in database?

[Anon]

As title.Thinks!!

[Anon]

There is a tutorial on phpbuilder that deals with exactly that.....but if it were me, I would be saving only the image src in the database and then copying the images to an actual directory.....thus not stressing out your database too much.

regards,
scott d~

[Anon]

Save only the path of the image on your database!!! Is more "smart"...

Like as:

img_desc img_path
flower /img/flower.gif
ball /img/ball.gif

then copy these files to the correct directory...

[Anon]

It's more "smart"? What's that all about?

There are many cases when storing binary data in a db is the best move. Although it can put a strain on your database, a correctly structured database should have no trouble. I have used MySQL to store thousands of pictures without having to worry about the potential problems that can arise from the filesystem and finding a file naming convention.

There are pros and cons for both methods. Never rule out the power of the BLOB.

Bye,

Matt

PS: The tutorial on here is pretty good.

[vlcinsky]

I must say, that we preffer storing images inside of database.
"Files" are then much easier managable.
To solve application efficiency, we use cashing for pictures, so mostly the application uses file stored in cash, instead of querying the database.

Jan