How to prevent automatic data insert into DB while reload the page using PHP and MySQL

Question

I have an issue.My previous data is inserting again and again at each time of page reload using PHP and MySQL.I am explaining my code below.

 $result = $dbobj->savePincode($newCustomerobj);
    if($result == 1)
    {
        $msg='3';
    }
    else
    {
        $msg='2';
    }
    function messagestatus(st)
{
    switch(st)
    {   
        case 1:
        {
            alert("Data Updated Successfully.");
            <?php header("location:localhost/demo/pincode.php"); ?>
            break;
        } 
        case 2:
        {
            alert("This user id already exist..");
            break;
        } 
        case 3:
        {
            alert("Data Saved Successfully");
            <?php header("location:localhost/demo/pincode.php"); ?>
            break;
        }
        case 4:
        {
            alert("Data deleted Successfully");
            <?php header("location:localhost/demo/pincode.php"); ?>
            break;
        }
    }
}
messagestatus(<?php echo $msg ?>);

Here i am also adding the header but still when user is reloading the page after first time insert again same is inserting.Please help me.

does code you provided also present in the page "localhost/demo/pincode.php" ? — PHPExpert
– PHPExpert, Commented Feb 9, 2016 at 13:35

PHPExpert · Accepted Answer · 2016-02-09 13:40:22Z

1

As far I get from your question, you are posting the form data using POST method and after that redirecting user to same page, so your data is getting insert again and again. Do small change as shown below in your code-

<?php header("location:localhost/demo/pincode.php?hash=".time()); ?>

By appending hash parameter with time() value, your browser will consider it as an new url and your form data will not get insert again.

Hope so it will work for your.

answered Feb 9, 2016 at 13:40

PHPExpert

9435 silver badges9 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

user5443928 Over a year ago

@ PHPExpert : actually what is my problem,Suppose user inserted the data for first time.After inserting when the user is reloading the page again the same data is inserting.

PHPExpert Over a year ago

Yes, I considered this scenario and posted solution. Have you tried this solution ? If yes, then me suggest another way.

Collectives™ on Stack Overflow

How to prevent automatic data insert into DB while reload the page using PHP and MySQL

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related