Tutorial: Storing Images in MySQL with PHP

[Filips]

Thank you very very much.I will try this code.Thank you again.

[jpiche]

Also, if you have a limited number of small images being stored in the table, this technique could also be used to take advantage of mysql's cache--maybe.

[Filips]

Thank you very much.

[ssSuave]

Hi thanks again for your help

So my upload form is working perfectly on Safari and FF but it fails to work on IE. The image just does not get uploaded.
It is really annoying and I cannot figure it out. I have tried searching for an answer on google but couldn't find anything. I know i am not the only one since there were other people who had the same problem but I couldn't find any solutions. I read something about how instead of "enctype" there should be "encoding" for IE but i don't know how to integrate it. I would Really appreciate your help.

Thank you in advance

[Jordan]

Hey ssSuave,
Sure, I'll be glad to help. What version of IE are you using and did you change the code in any way? If so, can you post it?

[phillw]

Thanks for the tutorial, between yourself and Jaan - it's just what I need

Regards,

Phill.

[phillw]

I said I'd be back !! - lol

After a little head scratching, i realised blob is limited to 64k - So i changed to mediumblob (16Mb) and all is well.

Now the $64,000 question - Obviously, i don't want to be firing down lots of pics at this resolution (some of them are 1:1 scale engineering drawings, that may need to be printed). They are about 200k in size.

I see MySQL has a function to display thumb-nails - Am i better using this, or would it better to store a low-res version of the image in the database ?

I'm guessing saving the images at 92dpi for display purposes, and 'persueding' the code to switch over to the larger image when I select printer as the output would be logical. But before I commit to one way - can you suggest which path I should follow ?

Depending on the recommendation, it makes my next question of how to tell the display program which image to choose. My two CSS's may have to come to my help, here !!!

Once again, thanks for a well written and easy to follow tutorial - It didn't take very long to work out why the images weren't saving - and the ammendment was made easy owing to your clear commenting & use of variable names.

Regards,

Phill.

[Vswe]

Thanks Jordan, this helped me. At last I will be able to +rep you

[Jordan]

You are very welcome and thank you.

[ezcat]

Need some education. I looked around but didn't find an answer I understood or it doesn't matter anyway.

On this line:
<input name="image" accept="image/jpg" type="file">

My question is; what does accept="image/jpg" do for me? I can use this same code to upload jpg or pdf files. Should I worry about this to upload different file types?

Thanks,
Jon