Database and Pictures

[dario]

Hi,

Namely, how can I insert the picture into table row in dB and then previw it in Dreamweaver MX?
When previw it in DMX I only see a picture error element (i.e. small "x" displayed) instead a picture.
please help,
Dario

[nnichols]

If you are retrieving the image from a blob field in a db you cannot output it along with the rest of the page as your script can only output a single mime format at a time.

It is very inefficient to store images in a db table instead you should store the location of the image, NOT the image itself and keep your images in your file system.

Hope this helps 😉

[dario]

Hi,

How can I do that (to store the location of the images)? Can you give me some simple example?

thanks

Dario

[nnichols]

I normally use the db to name the files so that there are no problems with overwriting existing images.

So if I were uploading a thumbnail of a user it would have a prefix of "user_" and be stored in a directory /image/user/thumbs/ for example.

When the file is uploaded the first thing I do is assign a unique number (I use auto_increment column) to the image so it can be saved without the risk of overwriting any existing image.

Then you move the uploaded image to the corresponding folder using the name "$prefix.$unique_number".

Then when you come to retrieve the image from the db you have the text to put in the "src" attrib for the <img>.

If you search on here or Google there are lots of complete examples of this sort of script with explanations.

Hope this helps 😉