file upload php

[manzoor]

Hey, I have a form with which I take information about the user and a file. Then I insert them into database. What I want to achieve is that, I want to save the filename as the new ID inserted in MySQL database. I also have to validate the file to make sure it is of a specific type and size which I have done.

I only want to upload the file to my upload dir when everything is validated and it is okay to go. The 'action' attribute of my form refers to the same script.

1) So I want to know that if there are errors in other input fields but not in the file uploaded and then the form is submitted again, so will the file will be there? Or does it need to be uploaded again?

2) Second, I want to save the filename as the ID in MySQL database, but I also want to save the filename in MySQL database so whats the solution for this? The problem is I don't know what will be the new ID generated since it is auto-incremented. I can use the mysql_insert_id() function but then how do I save the filename in the table?

I guess everything is clear 🙂. Since English is not my native language, please ask if you don't understand what I mean.

[sneakyimp]

I would not recommend storing the file in a database table. It's easier to just to put them in a directory.

In the code that handles your form submission do the following:
1) check form inputs. If they are bad, delete the uploaded file.
2) check the file upload for errors. If it is bad, delete the uploaded file.
3) If you have encountered any errors, report them and die.
4) Insert the form data into your database.

5) use mysql_insert_id to get the id of the last inserted record. Use this id as the filename of your file and save it to some directory on the server. You'll always know which file goes with which record because the record id is the same as the filename and they are unique.