MySQLi查询在每次浏览器刷新时运行

Question

When I run this code, the "INSERT INTO aks_balance_history" query and "UPDATE aks_account" query runs again and again.Also database is getting updated on each refresh, while the "UPDATE aks_counter" runs only once (as required). I am really stuck in this code please help.

if(isset($_POST['update_btn_counter']))
        {
            mysqli_query($link,"INSERT INTO aks_balance_history(bh_amount,bh_from,bh_to,bh_reason) VALUES('".$_POST["used_balance"]."','Counter Cash','".$_POST["select_account"]."','".$_POST["reason"]."') ");
            mysqli_query($link,"UPDATE aks_counter SET counter_balance = counter_balance - '$_POST[used_balance]' WHERE counter_id='0' ");
            mysqli_query($link,"UPDATE aks_account SET account_balance = account_balance + '$_POST[used_balance]' WHERE account_title='$_POST[select_account]' ");
        }

Answer 1

Sure, that is because the browser sends the same request again. That is what you asked it to to when refreshing. If you want to prevent that, then you have to redirect the browser after having performed the database operations. You typically redirect it to some read only code that reads the result from the database and displays it. Then you can refresh how often you want.

Currently you do not reload the form, but the result of the form you got after the first submit. To re-deliver that result the server must re-run the same code, thus the same operations are performed.

A typical solution is to send a forms submission to some processing script and the redirect back to the form if that should be offered again.