I know how to upload images directly into a SQL table, but I was curious if it's possible to automatically create a thumbnail version in the table every time an image is uploaded. I know how to do this if the images are being stored in a directory, but not a SQL database. Is it even possible? I chose to store the images in the database because I am doing a site for a client and I want them to be able to make updates through an admin page I made for them... so they can add, update, and delete the images attached to their journal entries and whatnot without any orphaned images filling up their directories. Is it possible to not orphan files when storing the images in a directory and just have the SQL table point to that file name? (without creating any extra work for my client, of course) Any ideas?
http://www.phpbuilder.com/columns/florian19991014.php3?aid=38 It would be better to store the images as regular files, and store the filenames in your database. To avoid orphaning... just add something in your logic where, when a particular row is deleted, physically delete the images and its thumbnail from the filesystem as well.