How to store pictures in a MySQL database in PHP

resetreset · 04-29-2010, 08:54 AM

Hi,
How do I do this? I wish to store the pictures via a "Browse" button on the webpage, and later display them on a particular page on the site.

Thanks.

troop · 04-29-2010, 08:59 AM

You can use blob type.
However, I can't recommend it. The pictures better to store on hdd in most cases.

phunkymunky · 04-30-2010, 12:02 PM

I looked into this last year for a small website to allow uploading photos to a website. From the research I found that the majority of people said to avoid putting images into databases unless absolutely necessary, it is a much better practice to upload/store the picture in a directory or wherever and then just store the path and filename in the DB.