How to store images directly a database

tlane

RE: article "How to store images directly in the sql database"
location: http://www.phpbuilder.com/columns/florian19991014.php3?print_mode=1
by Florian Dittmer

I read the article on “How to store images directly in the sql database” and the examples seem to work good when uploading an image. I am although having problems getting the image out of the database and displaying it.

MySQL v 3.23.34

PHP v 4.0.6
OS Windows 2000 Professional

I log into the phpAdmin and I can see the rows I inserted into the binary_data table. I used all the examples you listed in your article to see how it is supposed to work. When I execute the getdata.php script it returns a broken image and I cant see any of the images I’ve stored. Could you tell me what I’m doing wrong?

Have others had this problem?

Anon

you can always comment the headers for debugging and see if what is coming out is correct. also, make sure you stripslashes() the image before displaying it.

paul
http://xhawk.net

tlane

i tried this and it does not work... still getting teh broken link/image

tlane

the problem exists in the storing of the image. on a windows platform (which is what i'm developing on) needs to:

$data = addslashes(fread(fopen($form_data, "rb"), filesize($form_data)));

instead of:

$data = addslashes(fread(fopen($form_data, "r"), filesize($form_data)));

extracted from php manual:
Note: The mode may contain the letter 'b'. This is useful only on systems which differentiate between binary and text files (i.e. Windows. It's useless on Unix). If not needed, this will be ignored.

thanks for your help though!