Ak. I need to avoid a double insert ...

[Anon]

It's pretty simple.

I'm just tired I'm sure. I want to insure the data integirty of my db, and avoid users inserting data 2x by reloading (I had one guy put 15 inserts in the db, that's a lot of reloading!).

What's the best way?

J

[Anon]

Nevermind...

$query = "SELECT status, title, summary, contact FROM $tableName
AND status = '$statusCheck'
AND title = '$titleCheck'
AND summary = '$summaryCheck'
AND contact = '$contactCheck'
";

Then I just check the page vars against the check vars. I'm sure this could be done with an array as easily.

Anybody got a better way? A build in function of some cool SQL?

J

[[deleted]]

One simple way to avoind inserts by reloading the page is to use header('location: url') top redirect the user to a 'clean' page after the record has been inserted. If the user reloads the page, he will reload the clean page, not the page with the submitted data.

[Anon]

After you've added the data into the table with your PHP you could re-direct the user to a seperate confirmation page? and then they can re-load all they like but it wont add any new records.