image resize from mysql

[Anon]

i was searching this site and forum and didn't found any example how to do image resizing with GD from mysql.. can anyone post any example with GD use only ? thks 🙂

[[deleted]]

The reason you could not find anything is that storing images in a database is an extremely bad idea.

Don't do it. Save the images to disk.

...and that magically solves your problem too 🙂

read this:
http://www.hvt-automation.nl/yapf/faq.php?cmd=viewitem&itemid=22

---

A forum, a FAQ, email notification, what else do you need?

Time to YAPF!: http://www.hvt-automation.nl/yapf/

[Anon]

ergh... now where am i going to find some easy examples of uploading, save "random" names on mysql and resizing images.. ergh.. bad post! bad post!

[[deleted]]

• you don't need random names, because you will ofcourse still store the file-name etc in the database, and the database will give you a value for it's primary key, and that is unique so you can use that as a filename.

• Where are you going to find an example for the upload? uhm... you already have that code, how else are you getting the images in the database now?

• code for resizing? how about the friggin manual?

[Anon]

well.. i've done all the stuff with files.. i used time and filename to store name in mysql.. but about resizing.. if a image width is 2x the image height the thumb looks very ugly.. is there any math crazy funcions that can fix that ? 😛 like croping image.. or something.. :o

[[deleted]]

You could crop (just use different parameters for the copy function) but that would make the thumbnail rather useless.

I think it would be better to just have a max width and height, and adust the image size so that the width-to-height ratio remains the same as in the original.