Images in the SQL DB

[Warlord]

I've made a submissions form to enter information in my database, but how do I allow users to upload images into the database and then call those images with the rest of the information?

[Velocd]

When in doubt, look how other people do it.

vBulletin does it, so look at their `attachment` table schema.

Note storing images in the database isn't good for gallery purposes.

Usually DB images would be accessed by a script from a url such as:
image.php?id=56

In which image.php will output the image with proper header().

If you are listing 50 images in a gallery, that would be:
image.php?id=x

50 showings, 50 queries. For a gallery it's probably faster storing the images on the server. You can still use a database table to store the info and the path to the images.

[Warlord]

Well it's not really a gallery.. it'll only show one image per page.. but thanks for the reply. I'll look into it.

You can view what I'm trying to do here:


http://www.neropolis.com/index.php?page=bios

Click on one of the character names to view the bio.. I want users to be able to upload images for the bios they submit.

[Tekton]

Originally Posted by Warlord

Well it's not really a gallery.. it'll only show one image per page.. but thanks for the reply. I'll look into it.

You can view what I'm trying to do here:


http://www.neropolis.com/index.php?page=bios

Click on one of the character names to view the bio.. I want users to be able to upload images for the bios they submit.

You could store it as a file and still make a database reference that links to it though.

[AN-net]

if your making a gallery your best option is to put it in its own database