Databases
StackOverflow2013
Postsdbo
POBlock submit after reload page
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POBlock submit after reload page
    text
    copied!<p>I "finished" my commenting system but one problem left. After I write a comment and then reload the page, then the comment gets posted again.. Ive googled now 2~ hours and cant find some help</p> <p>code:</p> <pre><code>&lt;script type="text/javascript"&gt; function toggle_comment(id) { var e = document.getElementById(id); if(e.style.display == 'block') e.style.display = 'none'; else e.style.display = 'block'; } $(function() { $(".submit").click(function() { var comment = $("#comment").val(); var dataString = 'comment=' + comment; if(comment=='') { alert('Please enter at least 30 characters'); return false } else { $.post("pages/comment.php", $("#postcommentform").serialize(), function(data) { }); } }); }); $(function() { $(".login").click(function() { var username = $("#username").val(); var password = $("#password").val(); var dataString = 'username=' + username + '&amp;password=' + password; if(username=='' || password=='') { alert('Login is incorrect'); return false } else { $.post("pages/login.php", $("#postlogin").serialize(), function(data) { }); } }); }); &lt;/SCRIPT&gt; &lt;a class="sitelinksblue" onclick="toggle_comment('commentfield');" style="font-family: Verdana, Geneva, sans-serif;font-size:12px;font-weight:bolder;"&gt;+ Kommentar abgeben für Englisch Für Anfänger&lt;/a&gt; &lt;BR&gt;&lt;/BR&gt; &lt;?php if(isset($_POST['submitcomment']) &amp;&amp; $_POST['submitcomment']=="Submit") { if((checkComment($_POST['comment']) &amp;&amp; strlen($_POST['comment'])&gt;=10 &amp;&amp; strlen($_POST['comment'])&lt;=1500)) { $sqlCmd = "INSERT INTO topmovies.comments (username,comment,date) VALUES ('".mysql_real_escape_string($_SESSION['user_username'])."','".mysql_real_escape_string($_POST['comment']);."','".$sqlZeit."')"; $sqlQry = mysql_query($sqlCmd,$sqlHp); ?&gt; &lt;?PHP if (!$sqlQry) { die('Invalid query: ' . mysql_error()); }else { echo'Comment Added!'; } }else{ echo'Error! Please enter a comment with 30 or more and 1500 or less characters';} } else { } ?&gt; &lt;div id="commentfield" style="display:none"&gt; &lt;?PHP if (isset($_SESSION['user_username'])){ if($getAdmin-&gt;status=='BANN'){ echo $lang['BANN']; exit(); }else{ ?&gt; &lt;form id="postcommentform" method="POST" action=""&gt; &lt;p&gt;Dein Name: &lt;?PHP echo $_SESSION['user_username']; ?&gt;&lt;/p&gt; &lt;textarea class="textareacom" name="comment" id="comment" rows="5" cols="20" maxlength="1500" value=""&gt;&lt;/textarea&gt;&lt;br /&gt; &lt;input name="submitcomment" id="submit" type="submit" class="submit" value="Submit" /&gt; &lt;/form&gt; &lt;?PHP } }else{ ?&gt; &lt;FORM id="postlogin" action="" method="POST"&gt; &lt;p style="font-weight:bolder;"&gt;Um Kommentare schreiben zu können musst du dich zuerst einloggen&lt;/p&gt; &lt;TABLE&gt; &lt;TR&gt; &lt;TD align="left"&gt;&lt;font face="Arial" color="#000000"&gt;&lt;?php echo $lang['REGISTER_USERNAME']; ?&gt;&lt;/TD&gt; &lt;TD align="left"&gt;&lt;input type="text" name="username"/&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD align="left"&gt;&lt;font face="Arial" color="#000000"&gt;&lt;?php echo $lang['REGISTER_PASSWORD']; ?&gt;&lt;/TD&gt; &lt;TD align="left"&gt;&lt;input type="password" name="password"/&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;TR&gt; &lt;TD&gt;&lt;/TD&gt; &lt;TD align="left"&gt;&lt;input type="submit" id="login" value="login" name="submit" /&gt;&lt;/TD&gt; &lt;/TR&gt; &lt;/TABLE&gt; &lt;a href="index.php?s=register"&gt;&lt;?php echo $lang['LOGIN_REGISTER']; ?&gt;&lt;/a&gt; | &lt;a href="index.php?s=forgotpw"&gt;&lt;?php echo $lang['FORGOT_PW']; ?&gt;&lt;/a&gt; &lt;BR&gt;&lt;/BR&gt; &lt;/FORM&gt; &lt;?PHP } ?&gt; &lt;/div&gt; &lt;?php $sql=mysql_query("select * from topmovies.comments ORDER BY date DESC"); while($row=mysql_fetch_array($sql)) { $username=$row['username']; $comment=$row['comment']; $date=$row['date']; $name=$row['name']; ?&gt; &lt;div id="comments" name="comments"&gt; &lt;div class="comments" style="padding-top:5px;"&gt; &lt;BR&gt; &lt;table width="746px" style="display:inline;" border="0" cellspacing="0" cellpadding="0"&gt; &lt;tr&gt; &lt;td rowspan="4" valign="top" width="154px" style="padding-right:19px;"&gt;&lt;img style="display: block; padding-top:10px;" src="http://img.movie4k.to/img/user_top.gif" height="8px"/&gt; &lt;span class="test"&gt;&lt;?php echo $username; ?&gt;&lt;br /&gt; &lt;br /&gt; &lt;font size=1&gt;&lt;?PHP echo date("d-m-Y", strtotime($date))?&gt;&lt;/br&gt; &lt;?PHP echo date("H:i", strtotime($date))?&gt;&lt;/font&gt;&lt;/span&gt; &lt;img style="display: block; background-color: #AFAFAF; padding-left:10px; padding-right:10px;" src="http://img.movie4k.to/userpics/476090.gif" width=40 height=50/&gt; &lt;img style="display: block;" src="http://img.movie4k.to/img/user_bottom.gif" height="8px"/&gt;&lt;/td&gt; &lt;td colspan="2" valign="bottom" height="8px"&gt;&lt;img style="display: block; padding-top:10px;" src="http://img.movie4k.to/img/comment_top2.gif" height="8px"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td rowspan="2" width="522px" class="comment" valign="top" bgcolor="#E3E3E3" style="padding-left:10px; padding-right:17px;"&gt; &lt;?php echo $comment; ?&gt; &lt;/td&gt; &lt;td width="85px" valign="top" bgcolor="#E3E3E3" style="font-size:19px;"&gt; &lt;div style="min-height:50px;"&gt;&lt;/div&gt; &lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td bgcolor="#E3E3E3" valign="bottom"&gt;&lt;/td&gt; &lt;/tr&gt; &lt;tr&gt; &lt;td colspan="2" valign="top" height="8px"&gt;&lt;img style="display: block;" src="http://img.movie4k.to/img/comment_bottom2.gif" height="8px"/&gt;&lt;/td&gt; &lt;/tr&gt; &lt;/table&gt; &lt;/div&gt; &lt;/div&gt; &lt;BR /&gt; &lt;?php } ?&gt; </code></pre> <p>Does anyone see there a mistake what is wrong? I tryed 1 thing, but then it dont show the echo "comment added!"</p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload