[phorm] Preventing double records in MySQL with phorm

  • From: "Ton E" <dj.ton.e@xxxxxx>
  • To: <phorm@xxxxxxxxxxxxx>, <support@xxxxxxxxx>
  • Date: Wed, 7 May 2003 01:34:55 +0100

When logging the (phorm) form entries to MySQL normally it is possible that
the same data can be entered more than once. I would like to prevent this by
checking the new form entries against what is already in the database. So if
the sender's email address and the settings are the same more than once the
new entry should be blocked.

Blocking would mean in this case these main points:
>> no entry in the MySQL database (=no use of "INSERT")
>> no sending of information email message to admin (email.html)
>> no sending of responder message to the form user (responder.html),
instead the ack.html should show the user that there was a "double entry and
his data was not accepted and he should try again".

Did anyone try to do this already? Or even if you don't know a solution is
this possible to do with phorm?


-------------------------------------------------
You are receiving this message because you are subscribed to the Phorm mailing 
list. To send messages to the mailing list, simply send email to 
phorm@xxxxxxxxxxxxx from the address you have subscribed. You may unsubscribe 
from the list by sending email to phorm-request@xxxxxxxxxxxxx with 
'unsubscribe' in the SUBJECT field.

Other related posts: