Re: Duplicate record

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



after entering the data, send the user to another (confirmation) page...then you avoid the possiblity of duplicates

Bastien

From: Miles Thompson <miles@xxxxxxxxxxxxxxxxx>
To: "Hallvard" <hallvard@xxxxxxxxxx>, php-db@xxxxxxxxxxxxx
Subject: Re:  Duplicate record
Date: Sat, 30 Jul 2005 10:54:16 -0300



Do a seek on the fields which cannot be duplicated; if there's a hit reload the page with the appropriate error message, otherwise reload the page with a success message.

Although I have not worked with AJAX, this would appear to be an excellent spot to use it. Silently check after focus has left the final field which must be unique, doing nothing if data is OK, putting up a flag if there was duplication.

As for a unique ID for each record, i.e. one that autoincrements, that's almost always a good idea.

Regards - Miles Thompson

At 07:17 AM 7/30/2005, Hallvard wrote:
I have a page that posts data from a form to a mysql database.

The problem is that if the user hits the reload button on the browser, the
data will be posted again, resulting in a duplicate record.

How can I avoid that?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux