data is inserting in to database on each page refresh.

Question

3.00/5 (1 vote)

See more:

HTML

PHP

Hi,
When i refresh the page the datas are inserting to database.How can i avoid this?

Thanks,

Posted 21-Oct-11 21:01pm

sreenathpktr

Updated 26-May-22 2:05am

Add a Solution

Comments

Uday P.Singh 22-Oct-11 3:08am

can you post your code?

sreenathpktr 22-Oct-11 3:10am

yes...here it is..
$k=$_POST['Return'];
$l=$_POST['Remarks'];
$btn=$_POST['submit'];

if(isset($btn))
{
$ins=mysql_query("insert into it_clearance2 values('$k','$l')");
if($ins==true)
{
$msg="IT clearance record saved successfully";
header("Refresh:3; url=it.php");

}
else
{
$msg="Error occured..";
}

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

I.explore.code · Answer 1 · 2011-10-22T00:03:00

the HTTP protocol is stateless and no matter what you do, $_POST will always contain the same data coz thats what browsers do, they save the POST data and which is why the $btn is never unset or emptied and which in turn is why it keeps inserting into the table.

Having said that, what you can probably try doing is, don't refresh the page and as soon as the values are inserted the first time and you have a result $msg, redirect to a different page to show that message. You can append that message in querystring of the redirected to URL or you can put it in a session and retrieve it on the other page.

Hope this helps...

EDIT: move the call to header() function outside the if else if you want the failure message to be conveyed to the redirected to page.

Cheers

Member 15651188 · Answer 2 · 2022-05-26T02:05:00

First you should redirect the form into another page like:

HTML

<form action="demo.php" method="POST">

And You should create the demo.php file and paste this code:

PHP

<!--?php
    include 'conn.php';

    $name="";
    $date="";
    $destination="";
    $number="";
    $remarks="";
    $nights="";
    $days="";
    $price="";
    
    
    
    if(isset($_POST['submit'])){
        $name = $_POST['name'];
        $date = date('Y-m-d', strtotime($_POST['date']));
        $destination = $_POST['destination'];
        $number = $_POST['number'];
        $remarks = $_POST['remarks'];
        $nights = $_POST['nights'];
        $days = $_POST['days'];
        $price = $_POST['price'];
       
    
    
    $query = "INSERT INTO date (name,date,destination,number,remarks,nights,days,price) VALUES ('$name','$date','$destination','$number','$remarks','$nights','$days','$price')";
    $iquery = mysqli_query($con, $query);
    }

    header("location:testing.php"); //Redirecting To the main page
?--></form>

data is inserting in to database on each page refresh.

2 solutions

Solution 2

Solution 3

Add your solution here

Preview 0