-2

A user makes a booking. They enter their name, the Pickup address and a Dropoff address and a time of pickup.

If, the user has an internet problem and their form doesn't seem to send, they press the submit button a second time, I often end up with 2 entries both the same in the database. Sometimes, Date_added column could change by amount of seconds because of when user clicks submit button.

I am trying to stop 2 entries being added to the database.

How do I check the database to see if their first submit was a successful entry into the database and stop a second row/record being added?

I was going to try using UNIQUE, but the user books trips and other times and also other users could use the same address's at times.

My columns names are: Date_added, Username, Pick_up_Address, Drop_off_Address, PU_time

How do I check the database to see if it's not a duplicate entry about to be added, that is only different by under a minute.

I don't know where to start with this or how to do it.

I tried UNIQUE in query but this would not work as other users would use the address's.

Dharman
  • 30,962
  • 25
  • 85
  • 135
Donnan31
  • 5
  • 5
  • Does this answer your question? [How to prevent multiple form submission on multiple clicks in PHP](https://stackoverflow.com/questions/4614052/how-to-prevent-multiple-form-submission-on-multiple-clicks-in-php) – Progman Nov 24 '22 at 23:12
  • I don't believe this would work as if the user refresh's the page a different token would be placed in the form. – Donnan31 Nov 24 '22 at 23:19
  • You can have `UNIQUE` indices which spans over multiple columns, see https://stackoverflow.com/questions/635937/how-do-i-specify-unique-constraint-for-multiple-columns-in-mysql – Progman Nov 24 '22 at 23:34

2 Answers2

0

This is not an issue from the back I believe but from the front.

Once the user hits the button, disable it, and add a "Loading functionality" and that should prevent the double save.

If the back answer with "200" (or whatever status you want) on the AJAX request, then, send the user to another page where they can see the booking data or any other kind of things like that.

If the back answers with another apart of "200", then re-enable the button.

So, you control everything from your back.

Now, if the user is not able to finish the request but the data has been saved to the database, validate that using your time. I see your PU_Time, so maybe if you have users with accounts, you can validate them using the same account + PU_Time "if PU_time > now - 60 seconds" send the user to the "booking data page"

That should solve it.

Asfo
  • 413
  • 10
  • 20
-1

I believe I may have found an answer to my problem.

When the first database entry is INSERTed...I then set a session variable.

Then added:

if (!$_session['booked']){
  //Insert entry into database//

  $_session['booked'] = 1;
}
Donnan31
  • 5
  • 5