StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POwhy php input blank value or duplicate values in one form if submit another form
primarykey
Id
20310328
data
AcceptedAnswerId
20310358
AnswerCount
2
ClosedDate
CommentCount
2
CommunityOwnedDate
CreationDate
2013-12-01T08:39:19.773
FavoriteCount
0
LastActivityDate
2014-08-17T05:04:30.990
LastEditDate
2013-12-01T15:30:28.783
LastEditorUserId
1314404
OwnerUserId
1314404
ParentId
0
PostTypeId
1
Score
0
ViewCount
293
LastEditorDisplayName
text
Body
<p>I am encountering a strange phenomena: When I submit a form in my code, then beside doing what is there in that form, it looks like it also trigger the comment form. So when the page is reloading, I get some blank comments or duplicate comments. In my code I have several forms with submit, and one of that is the form for input comment:</p> <pre><code><form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <input type="hidden" name="a" value="<?php echo $_GET['id'] ?>"> <input type="hidden" name="b" value="<?php echo $_SERVER['REMOTE_ADDR'] ?>"> <input type="text" name="c" value="Name"><br> <textarea name="d"> </textarea> <input type="submit" /> </form> </code></pre> <p>Could any of you point out for me where it gets wrong?</p> <p>As requested, I post the whole (updated) code here:</p> <pre><code><h3>Comments</h3>  <?php //a: commenters $i = addslashes($_POST['a']); $ip = addslashes($_POST['b']); $a = addslashes($_POST['c']); $b = addslashes($_POST['d']); if(isset($_POST['form1'])){ if(isset($i) & isset($ip) & isset($a) & isset($b)) { $connector= new DbConnector(); $r = mysql_query("SELECT COUNT(*) FROM `databasename`.`ban` WHERE ip=$ip"); //Check if banned $r = mysql_fetch_array($r); if(!$r[0]) //Phew, not banned { // echo "a: ".$a." b: ".$b." ip: ".$ip." i: ".$i.""; $Date4=date('Y-m-d H:i:s'); if(mysql_query("INSERT INTO `databasename`.`Comments` VALUES ('$a', '$b', '$ip', '$Date4')")) { ?> <script type="text/javascript"> window.location="/index.php?id=".<?php echo $i; ?>; </script> <?php } else echo "Error, in mysql query"; } else echo "Error, You are banned."; } } $x = mysql_query("SELECT * FROM `databasename`.`Comments` ORDER BY i DESC "); while($r = mysql_fetch_object($x)) echo "<div class='c'>".$r->a."<p>".$r->b."</p> </div>"; ?> <form action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post"> <input type="hidden" name="a" value="<?php echo $_GET['id'] ?>"> <input type="hidden" name="b" value="<?php echo $_SERVER['REMOTE_ADDR'] ?>"> <input type="text" name="c" value="Name"><br> <textarea name="d"> </textarea> <input type="submit" name="form1" /> </form> </code></pre>
Tags
<php><mysql><forms>
Title
why php input blank value or duplicate values in one form if submit another form
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USuser1314404
UserOwnerUserId
1. USuser1314404
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. This table or related slice is empty.
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POwhy php input blank value or duplicate values in one form if submit another form
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTApproveEditSuggestion
CommentsPostId
1. COseams like you have a problem when you retrive the comments, This form seams valid. Do you have more code?
  singulars
  PostPostId
  POwhy php input blank value or duplicate values in one form if submit another form
  UserUserId
  USPhilip G
2. COYes, added ! Thank you.
  singulars
  PostPostId
  POwhy php input blank value or duplicate values in one form if submit another form
  UserUserId
  USuser1314404

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.