database and file question

PaulaRun

I have a script to upload photos of products to a file on the server. In my database, for each product, I have an image path field pointing to the to the photo for that product.

The problem is when the user is adding a new product. The user adds the product to the db then uploads the photo (I have the image path default set to an image no_photo_available.gif. I need to update the image path field with the new photo but I don't know the file name of the photo the user user just uploaded. So I need the user to point the new product to the photo. I think I need to display all the photos and have the user pick the photo to go with the new product, but how?? Any ideas?

Thanks!

cgraz

lets say you have

and you want the name of the file they just uploaded, then use

$_FILES['userfile']['name']

Have a look here for info on handling file uploads in php.

Cgraz

PaulaRun

The image file has been uploaded in a previous script and the db record has been added in another script. Now, as a seperate script, I need to match the two. I'd like for the user to pull up the record he wants to add the photo to and choose from a pull down list of all the photos. How can I read from the directory containing the photos? Every example I see of the fopen() will open a specific file such as a text file. I want to list all the files within the directory. Does this make sense?

Thanks!

dalecosp

Hmm, check out readdir(). .

Of course, what cgraz was saying was correct; you should be able to match the pic earlier in the process...it sounds like you've got an extra step.

PaulaRun

Thanks cgraz and dalecosp! I think readdir() will work for me. I know it is an extra step but the user may not upload the photo at the same time as adding a new product.

Thanks so much for the help!