Prevent Duplicate Insert

Question

I have a page which is doing an insert. The DB table has a unique column called "order" that auto increments upon adding a new row. I am executing the insert in this way:

$insert = <<<SQL
INSERT INTO `order` (name, email, team, project, startdate, enddate, comment, server) VALUES (?,?,?,?,?,?,?,?);
SQL;
$instat = $mysqli->prepare($insert);
$bind = mysqli_stmt_bind_param($instat, "ssssssss", $name, $email, $team, $project, $timestart, $timeend, $comment, $code);
$exec = mysqli_stmt_execute($instat);
mysqli_stmt_close($instat);
mysqli_close($mysqli);

I am allowing the DB to handle an auto increment of the order column so that it cannot be duplicated. This works just fine, but if I were to hit refresh on the page, it will insert another row with the same data on a new unique order id. How can I prevent another insert upon a page refresh?

Danyal Sandeelo · Accepted Answer · 2015-05-25T18:47:21.270

1

After saving the row, redirect the page to another page with corresponding message . Your flow will be like

  1) $service->saveObject($dataObject);
  2) redirect_to_success page.

edited May 25 '15 at 18:47

answered May 25 '15 at 18:25

Danyal Sandeelo

11,068
6
37
64

How do I carry over the ID that is generated after the insert so that I can query it and display it on the success page? – Wes May 25 '15 at 20:01
redirect_to_success.php?id=$yourId – Danyal Sandeelo May 25 '15 at 20:19
Thanks. I am using mysqli_insert_id() to get the order id and pass that to the "success" page. Appreciate the help! – Wes May 25 '15 at 20:34

score 0 · Answer 2 · edited May 23 '17 at 11:58

0

before every insert - make select query and check
Make insert query with NOT EXIST:
- How to 'insert if not exists' in MySQL?
- MySQL: Insert record if not exists in table

3.Redirect to current page after insert.

edited May 23 '17 at 11:58

Community

1
1

answered May 25 '15 at 18:28

Kristiyan

1,637
13
17

Prevent Duplicate Insert

2 Answers2