Multiple entries of the same information

lch_hosting

How do I make it so that if a client clicks submit twice they same information is not stored in the database twice, but only from the last submission? It would like it so that if the fields "domain" and "date" are that is checks to see if it already exists and if it does it will overwrite the entire record instead of making a new entry.... Anyone know how to do this help would be greattttlyyy apperciated! Thanks!!

GBahle

I wouldnt even try to write it 2 times. Add a session variable to your session that is set as soon as submit is clicked one time. In the processing form, check isset($yourVariable) and if it is, dont process the input at all.

Gernot

lch_hosting

Well if they push back after they submitted the information once I would like it to be updated (if they changed a password or something else). So I will need to overwrite it.... Any idea how to do that?

tasistro

on form page

<?
....

bla bla bla...
$myhash=%some good md5 thing here%

echo "<input type=\"submit\" name=\"thebutton[".$myhash."] value=\"submit\">"

bla ..bla bla

on receive page

<?
blablalbla

if (isset($thebutton)) {
$buttonkeys=array_keys($thebutton);
$sql_cmd="SELECT ID FROM %your table% where lock=\"".$buttonkeys[0]."\"";
$sql_result=mysql_query($sql_cmd,$db);
if (mysql_num_rows($sql_result)==0) {
// DO INSERT DATA HERE
}
}

blablalbla
?>

sarahk

change your submit button to a javascript call eg calls submitform

function submitform
{
document.MyForm.clicks.value += 1;
document.MyForm.submit();
}
<form action="myscript.php" name="MyForm">
<input type="hidden" name="clicks" value=0>
<!-- and all the other fields -->
</form>

then in php

if ($clicks == 1) //insert
else // update

tasistro

just read your repost

on form page

<?
....

bla bla bla...

// INSERT RECORD AND RETRIEVE ID
$myID=%record ID%

echo "<input type=\"submit\" name=\"thebutton[".$myhash."] value=\"submit\">"

bla ..bla bla

on receive page

<?
blablalbla

if (isset($thebutton)) {
$buttonkeys=array_keys($thebutton);
$sql_cmd="UPDATE %your table% SET %all variables here% where ID=\"".$buttonkeys[0]."\"";
$sql_result=mysql_query($sql_cmd,$db);
}

blablalbla
?>

lch_hosting

Thanks, but I'm looking for something a bit simpiler.... Ok for example I would need a script that does this

$string = select from Table WHERE domain=$domain AND date = $date

if results =1 (if it finds results)
die;

else {

run script...

How would I do that?

lch_hosting

Anyone Know?

NiXXeD

Well doing a query would not be 'simpler' but more 'slower.' I would just set a variable in the session that is something like a $lastbuttonpush, and just set it to time(). Check if the last button push is within X seconds and if they pushed it twice, it will be within a certain amount of seconds (figure like 10 or 15 I'd say) I have yet to add this to my site, so I might go try it. It should be pretty easy I'd imagine.

lch_hosting

Sorry but I need to know how to do it like the way I stated above.... Does anyone know the code to do such... IT would be a GREAT HELP!!