Image Upload/Delete

Does anyone know of a script/program that will do the following.

I have a products page that has two inputs for images. One image is the full/regular size and the second input is for a thumbnail. I need the image to be uploaded to an image folder and the image name/location recorded in a database. The above I can accomplish with FP Upload component. I would like to go further in being able to view the image from the products page, delete the actual image and db location marker, either with a delete function or when the record is deleted. Something that would resize and image or auto crate a tumbnail would be good but not necessary.

Thanks

Ernest L. Kendricks

I've always found an image location field in the database to be unnessesary. This is because database tables have Primary Keys.

In your Products table for instance, the primary key will almost certainly be the product_id.

Simply take the product ID and use that as the filename. Have 2 folders (Large and Thumbnail). You know that 45.gif in the thumbnail directory is the thumbnail image for the product who's ID is 45. If it does not exist, then it simply does not have an image associated with the product.

All upload components allow you to save files on the server using whatever filename you wish, and this is a good system,a s it keeps everything regarding a product under it's database ID.

If you were to offer PDF brochures for each product for instance, these could be stored in a 'Brochure' directory. If there is no file in the brochure directory called 45.pdf, then you know product 45 does not have a brochure!!!

Viewing the image from the products page is very simple. The products page will already have to hand the product_ID in order to display product information. A simple call to the filesystem object will reveal if the image associated with the product exists.... if it does, display it... if not, don't (Or use an image to identify no photo exists)

If you are allowed to install third party COM objects on your web server (Not many ISP's allow this on shared hosting plans), then there are plenty of objects out there to resize images and create thumbnails.

Hope this helps!

__________________
Click the 'Thanks!' button if this post has helped you

Rob - Webforumz Founder

Rob is correct and here is a free image resize component:

http://www.silberfish.com/sfir/default.asp

Thanks for the reply and info. Using the Primary key makes sense in identifying what goes with what.

The product page I'm referring to is and admin page used to add, edit and or delete products. This page is not accessible to the public.

My main concern here is being able to delete images from the the image folder without having to do it manually. I would like a function on the products page (admin only) to delete the image or replace the current image with a new one. Also if a product is deleted, the image in the image folder is also deleted, thus preventing orphaned images.

Thanks

Ernest

do you have the VBScript documentation installed, there is an example of how to delete/move files using the file system object.

You could have a look at the following functions that someone made. They simplify the FSO object a hell of a lot and let you concentrate on doing what you want to do - move/delete etc

http://www.asp-help.com/articles/filesys_functions.asp