How to get the upload Form to Submit a second time?

chrisj

In my Video Upload Form, I've added an Image upload section,
where a File name is chosen, then the File name is renamed with a unique name,
and moved to upload/ folder.

I needed to grab the image's new file-name on the Form page, and add it to Form Field-A
before proceeding with 'Submit',
but was told "only after submission can PHP know what the new file-name is".

When I fill out everything on the Form, except one required thing,
and click Submit, I stay on that same Form page and see the message "Error - **** is required",
and I see that all fields remain filled, and I also see that my code has successfully, filled in Form Field-A with the new-filename.

So, I fill in the required thing and proceed with another 'Submit".

The Form is successful. Form Field A's info has been entered into the db.

However, I don't want every visitor to this Form to have to do that, of course.

So, how can I trigger the Form to not proceed, upon Submit, like an error has occurred,
and trigger a message, that says something like (but not this): "click Submit again"?

bradgrafelman

If "Form Field A" is just based on the file name... then why do you need the field at all? Sounds like you should get rid of it entirely.

chrisj

Thanks for your reply. I need FormField-A to process the newfilename into the db.
Any additional help will be appreciated

bradgrafelman

But why? If you moved the file, you already know its new name.

Why do you need to tell yourself information you already know by placing it in a form field? That doesn't really make much sense.

chrisj

The Form field doesn't know it's new name (until Submit is selected).

The Form needs to process the new name into the db

bradgrafelman

Again, nothing you've described requires the new name of the file to be submitted in the form.

The basic workflow sounds like this:

User fills out form, including a file upload element.
User submits the form.
Form processor receives form data, including an uploaded file.
Form processor moves the uploaded file from a temporary location to a new location, using a newly generated name.
Form processor places elements of the received form data into a SQL query and executes the query to store the information in a database.

Does that sound right? If so, there is absolutely no reason why the "newly generated name" needs to be in the form data. You already know the new name of the file from step #4 above; step #5 can just combine that information with the form data when it generates the SQL query. There's nothing that says all data in a SQL query must originate from form fields.

chrisj

You are absolutely right. Thanks for that explanation. I was overthinking this - overdoing it. That was extremely helpful. Much thanks Brad. If I could get some guidance with what I would need to create a hyperlink to the image on the html web page where the Video Upload Form info (title, description, etc.) is displayed, I'd be grateful. The image that gets uploaded, via the Form, adds the user_id to the beginning of the file name, for example people.png is uploaded (by user 9) and the new file name is 9people.png and gets uploaded into the /upload/ folder, and stores that new file name into a db table called 'videos', into the column named 'thumbnail'. Any idea on what I would need to make the a successful hyperlink (to the image) appear where the Video Upload Form info is displayed, would be appreciated. Much, much, thanks again.