Images in the SQL DB
 

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?

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.

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.

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