Storing/retrieving a jpg in a mySQL blob?

Is it possible to have a form that uploads a jpg into a  field of type (blob?) of a mysql database? If so, can anybody give me any direction. Once it's there, can it be retreived and put into a page along with the other fields of the record?

Thanks for any help you can give me,

Jim
studioEtcAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

geir_andersenSystems engineerCommented:
there is a great tutorial on this here: http://www.phpbuilder.com/columns/florian19991014.php3?page=1
This takes care of an upload form, insert into mysql code, and code to display it again.

basically, it shows you how to use header() to set what type you're displaying.


-Geir

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
DawnlightCommented:
This topic has always been an issue of much debate.  As far as I am concerned I would rather store a jpg in this manner:

Save the .jpg to a specified folder and insert the folder/img path into the mysql DB.  Then use your php code to display the img from the path in the DB.  In my opinion this is a much easier way to handle things.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
PHP

From novice to tech pro — start learning today.