Submitting An Image To A Database

[dreamerp]

Hello,
I was wondering if anyone knew the best possible way to submit images to a database to be stored with information about the image, and the image itself rather than storing it in a folder.

Thanks,

Peter

[Lukus]

Ya can't store images in a db :)

Only thing you can do is store the location of the image (whether its from a different site, or use a script to upload the image to your site and store that location) :)

[MTsoul]

Yes you can store images in a database (MySQL)

Create a table, and for the property for one column, select BLOB. Select medium/tiny/large blobs according to the file size that you estimate will be. NOrmally, for an image, BLOB is fine.

BLOB is the format to store files as binary. Simply store the file data (the actual image) and the file format (.jpg, .gif etc). When you want to display the picture, use the header() information to select display type for the http request. I remember there's a tut on kirupa.com about it. Search for it. And then simply echo the data that's stored in the BLOB column.

[sinus_]

omg nice. thanks. i planning to try this out in the near future... :D

[Lukus]

Wow, I really didn't know that :P Cool

Must eat up space tho?

[MTsoul]

Not at all. In fact, it takes less space than if you want to automatically store it in a directory. With PHP, you'd have to make a temp file, then move it (and use up memory and temp file space), and then delete the temp file. This takes longer time and bigger memory for the server.

For MySQL, however, all you'd have to do is insert it. Ta-da. No worries. But one thing though, your file is stored in MySQL. MySQL crashes more often than the server does, which means you'd have to frequently back up your data.

[hl]

base64 works too

heres a nice tutorial i found http://www.spoono.com/php/tutorials/tutorial.php?id=42

[teiz77]

read this thread... i posted a full solution
http://www.kirupa.com/forum/showthread.php?t=88979