Row is inserted into database everytime I refresh the page

Question

Every time I try to refresh the page I get a new row. I tried to read many posts regarding to this problem, but I couldn't do anything since I'm new in database programming.

I don't know where the value come from, because the same value is repeated over and over.

My code.

<?php
require('connect.php');

$sql="CREATE TABLE test(id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
user VARCHAR(25),message LONGTEXT)";

if($sql==true){
$res=mysql_query( $sql);

}
?>

<?php

$user=null;
$message=null;

if(isset($_POST['user'])){
$user=$_POST['user'];
}
if(isset($_POST['message'])){
$message=$_POST['message'];
}


 if(!empty($_POST)){

if($user&&$message){
$insert=mysql_query("INSERT INTO test(user,message)VALUES('$user','$message')");
}
else{
echo "please fill out the fields";
}
}
?>



<html>
<body>
<form action="database.php" method="post">
<p><label for="user">Name:</label><br/>
<input type="text" name="user" id="user"/></p>
<p><label for="message">Message:</label><br/>
<textarea ="message" name="message"> </textarea></p>
<button type="submit" name="submit" value="send">Send Message:</button>
</form>
 <br/><br/><tr><td>The Users Comments:</td><td><br/><br/>
</html>


<?php
$query=mysql_query("SELECT * FROM test ORDER BY id DESC");
while($row=mysql_fetch_ASSOC($query)){

$name=$row["user"];
$message=$row["message"];

echo "username:",$name,'<br/>'," Messages: ",$message,'<br/>','<br/>';
}

?>

Is this the answer you're searching for : http://stackoverflow.com/questions/4327236/stop-browsers-asking-to-resend-form-data-on-refresh ? — Aurélien Grimpard, Jun 21 '14 at 15:14
Sidenote: Your ` ` contains a space and should read as `` - This will result in a space being inserted into DB right before the text that will be written in the textarea, and may cause problems later on. Plus, it's better to use a header to redirect to another page after submission, including a seperate file for both form and PHP/SQL, which may solve the issue. — Funk Forty Niner, Jun 21 '14 at 15:25
I noticed a space each time I try to write in textarea window, but I couldn't figure out the problem. Thank you very much user3763103 — user3763103, Jun 21 '14 at 15:30

score 0 · Answer 1 · answered Jun 21 '14 at 15:11

0

Problem is that everytime you refresh the page your browser is re-posting the same data. To workaround it you should consider implementing the Post, Redirect, Get pattern in your page.

Fundamentally this means that upon a successful POST (i.e. row was inserted) you should redirect to another page. This effectively stops the user from having the ability to re-post the same data.

The link above has a good overview of how to implement...

answered Jun 21 '14 at 15:11

Dean Ward

4,793
1
29
36

Thank you "dean" your post was helpful. I will read it, hope I learn more. – user3763103 Jun 21 '14 at 15:18

Shahrzad · Answer 2 · 2014-06-21T15:24:48.270

0

I don't find a problem in your code. Probably when you post data first time and then refresh the page, data is posted again. Most of the browsers like firefox gets confirmation if browser is re-posting data. Edit: To avoid this you must use redirect to GET method. see this

edited Jun 21 '14 at 15:24

answered Jun 21 '14 at 15:13

Shahrzad

1,062
8
26

Me either, that why I tried to ask here. I will try to change the browser hope it fix the problem . thanks. – user3763103 Jun 21 '14 at 15:19

score 0 · Answer 3 · answered Jun 21 '14 at 15:30

0

try to edit this

Blockquote

 if(!isset($_POST)){

     if($user && $message){

     $insert=mysql_query("INSERT INTO test(user,message)VALUES($user,$message)");

}

and be sure ctrl+f5 then refresh page

answered Jun 21 '14 at 15:30

Ashouri

906
4
19

The condition doesn't work, nothing can be inserted into database, because the condition is false. – user3763103 Jun 21 '14 at 15:35
I tried isset without negation sign, but the same problem occurs. – user3763103 Jun 21 '14 at 15:37

score 0 · Answer 4 · edited Feb 13 '17 at 15:58

Before insert check database if those values are present in database or not like

if(!empty($_POST)) {
    if($user && $message) {
        //check if this user and message in present database or not 
        $query = mysql_query("SELECT * FROM test WHERE user='".$user."' AND message='".$message."'");
        $count = mysql_num_rows($query);

        if ($count > 0 ){ // if $count is greater than 0 means values exists in database then 
            echo "Data exists";
        }
        else {
            // insert 
            $insert=mysql_query("INSERT INTO test(user, message) VALUES ('$user','$message')");
        }
    }
    else {
        echo "please fill out the fields";
    }

it is just a example you can modified it with your requirement :)

Row is inserted into database everytime I refresh the page

4 Answers4