3 Questions in One (Uploading Images)

[jmhall09]

Hey there everyone. I will try and make it short. Have a table (Property_Type, Rent, Available, Image_Associated). Have a form to input these fields (except the image). I need to input all the data into this table. I am familiar with insert regular fields, but when it comes to uploading images, what do I do???? SO...

1. What and how do I store image information in my database and on my web server.

2. Does anyone have sample code on how to upload images. If so could you please send it my way.

3.What code do I use to see if a user has click the submit button to come to the page to insert new information w/image.

Thanks in advance

[Anon]

I would suggest not storing the image data in the DB, rather store the image URL in the DB and copy the file into the filesystem.

something like this for your form
<form method="post" action="my_file.php" enctype="multipart/form-data">
<input type="hidden" name="MAX_FILE_SIZE" value="1000000">
<input type="file" name="my_image">
</form>

then in your upload script ...
copy ("$my_image", "/var/www/$my_image_name")

and insert the $my_image_name varible in a field in your table and use the image by building a URL from the table data.

that is, unless you really must store the image data as a BLOB in the DB.

[jmhall09]

Thanks I will give it a try this weekend. I am sure you will be hearing from me again.