calling images from a database

noreencoughlan

hi there i wonder if anyone can help me. I want to store some images in a database and then call them. I have a databse and all that set up. I just cant figure out how to display my images on a page? Any help would be greatly appreciated.

Noreen

weekender

Florian Dittmer wrote an article here entitled How to store images directly in the sql database - should give you the whole rundown

noreencoughlan

the article didnt really help so if anyone else has any other suggestions....

Drakla

How far through php knowledge are you?

Do you understand headers and all that guff, or do you just want to be spoonfed a script that works?

I'll be happy to bung in the php what I did write for myself when doing this very same thing if you want to read and understand it - but like everything else it's pretty 'raw' but that can be useful because the code isn't buried in a safety net. But the tourettes like babble to myself might really annoy you.

drawmack

http://www.onlamp.com/pub/a/php/2000/09/15/php_mysql.html

but this is an old tutorial so you'll need to use the $_GET['form_field_name'] instead of just $form_field_name

TMX

IMO, just store the path.

Much easier, takes less bandwidth, and I can see no reason why you would need to store an entire image in a web database.

drawmack

TMX -

1) how does it take less bandwidth, that doesn't even make any sense?

2) sotring them in the database means that the dynamic pictures will be backed up by the same routines that backup the rest of the database which makes for less coding and testing.

3) storing them in the database means that php doesn't need write access to a folder which leads to security issues.

4) if the picture are dynamic then they are data. Why wouldn't you store all your data in the database?

noreencoughlan

what i want to do is just store the path but i want to know how i will call the image then in my webpage?