execute SQL insert on user demand

svenski

I have a sytem whereby a user uploads a plain text file and this file is then checked and assuming it passes some tests an array is made with data being split on new lines form the original file.

This array is then being inserted in to a database, using a loop and insert statement. Problem is i want users to be able to confirm they want to add the files to the database before it is done, is there anyway to delay the execution of the INSERT statement untill the user requests it?

TIA

majiclab

Not really that I know of. MySQL 4 has transaction-safe queries, but I don't think that is what you want.

I think the best thing would be to just run the INSERT statement after they've confirmed that they want to insert it.

Hope that helps,

-Percy

svenski

thanks,

but how do i do this?

majiclab

You would have to create another page after the user submits the information. That page will check it to make sure, and if it passes, show another form that allows them to confirm and add it. You would probably need to have a hidden field in the form with the data they originally submitted.

Hope that helps.

-Percy

svenski

Well its as i suspected....which brings me nicely back to my original thread which was how to pass an array between two PHP pages....

majiclab

Why don't you just pass the temporary filename of the uploaded file? Then on the second page you could just re-do what you did on the first page but then INSERT it. Another option would be to save the array as a session variable.

Learn about sessions here:

http://ca.php.net/manual/en/ref.session.php

Hope that helps.

-Percy