how to avoid double clicking button = two inserts?

__greg

im writing a program now in which users submit data which is inserted into a database...

Sometimes it takes a while to insert because of resizing images, etc... but if the user clicks the submit button again, the data will be inserted again

if there any way that after a user clicks submit once, to have that button become inactive so they CAN'T impatiently click it a second time and have duplicate entries into the database?

csousley

My guess would be javascript to handle disabling the submit button. Now you could always test the information submitted and see if it already exists in the DB before entering it. If that works for your situation anyway. Good luck.

Shuriken1

What you could do is set a hidden field in the form with a random number in it and a corresponding field i the DB. The script checks to see if there is a row with the number in the field (ie the user has already submitted) and exit if so, if not carry on.
Not quite sure how you would impliment it but it seems feasible.

Shuriken1.

__greg

i chose to use javascript to disable the button after submit.. i know this is not a javascript site, but in case anyone else searches for this in the future... use this javascript:

<script>
function validForm(){
//after you check form and it's valid...
  document.getElementById("SubBtn").disabled = true
  return true
}
</script>


<form onSubmit="return validForm()" name="myForm">
<input type="Submit" id="SubBtn">

works like a charm.

Weedpacket

But be warned that this won't work if Javascript is turned off, of course; in which case Shuriken1's suggestion can be used for backup.