PHP MySQL Image Upload

[DarrenPWS]

Hi all,

I have a couple of things I need to be able to do.

I am building a site that sells scanners.

It will be a database-driven site, and so I want to be able to add new products etc. through the web interface.

I have created an admin section where I will be able to do just this - but I do not know how to upload an image to a directory, and insert the location into a mysql field, called image for example.

There is more to it than this - It would be great if on uploading the image, the image is inserted into the folder (i.e. /img/scanners/) - and into the database (i.e. scanners.image) - and then the image is resized to 100px in width, and then that image is inserted into the folder (i.e. /img/thumbs/) and then into the database (scanners.thumbnails).

I really dont think I can explain in much more detail - but all help / suggestions are greatly appreciated.

Thanks for reading my huge request.

D.

[roban]

What are you using for your site? PHPWebsite? If so Photo Album will do much of that. Do you have access to PHPMyAdmin through your host?

[Corey Bryant]

What shopping cart are you using? Most would actually do this already it would seem?

[DarrenPWS]

I am writing my own shopping cart for it, and so everything is to be done from scratch.

I do have access to PHPMyAdmin.

Thanks.

[speed]

PHP:

$file = $_FILES['filePic'];
move_uploaded_file($file['tmp_name'], $fileName);

HTML:
<form id="upload" action="test.php" method="post" name="upload" enctype="multipart/form-data">
<input type="file" name="filePic" size="40" />
</form>

In the PHP you need to set $fileName to the name of the file you want the image stored as, you can also store $fileName in the database.

If you want to resize/check the image format being uploaded then look up the following in the PHP manual:
getimagesize
ImageCreateFromJPEG
ImageJPEG
ImageCopyResampled

There are other commands but those should get you started :)

[DarrenPWS]

Thanks for the help - I will have a go with that code, and look at the suggested php manual functinos.

Thanks,

D.

[roban]

I use Cube Cart here and I think it would do what you want.

[Corey Bryant]

Sorry Darren, I missed that part. :) - take a look at this code from Dave (sonicgroup) - it might help you out as well.