I recently created a PHP/MySQL comment system, and it was working until a few hours ago (no changes at all in the code). When I tell the submit form code to echo the query, it shows that the area for commenttext and date is missing. I don't see why. Here's my code:
mysql_connect("localhost","commentUser","password");
mysql_select_db("comments");
$name = mysql_real_escape_string($_POST['name']);
$postID = mysql_real_escape_string($_POST['postId']);
if(!is_numeric($postID))
exit();
$email = mysql_real_escape_string($_POST['email']);
$comment = strip_tags(mysql_real_escape_string($_POST['comment']), '');
$date = mysql_real_escape_string($_POST['date']);
if($email == '' || $comment = '' || $date = '')
exit();
$query = "INSERT INTO comments (PostID,Name,Email,Text,Date) VALUES($postID, '$name', '$email', '$comment', '$date')";
mysql_query($query) or die(mysql_error());
mysql_close();
echo "
window.location = \"snippet.php?id=$postID\";
";
asked Sep 10, 2011 at 20:02
airplaneman19
1,1577 gold badges19 silver badges32 bronze badges
-
1You should post the HTML code for the formDrew Galbraith– Drew Galbraith2011年09月10日 20:04:49 +00:00Commented Sep 10, 2011 at 20:04
-
1can you post the code of the html form?itsmeee– itsmeee2011年09月10日 20:05:23 +00:00Commented Sep 10, 2011 at 20:05
-
Are the single equal signs typos in the post or are they in the actual code? if($email == '' || $comment = '' || $date = '') should all be double equals.Charlie– Charlie2011年09月10日 20:10:28 +00:00Commented Sep 10, 2011 at 20:10
2 Answers 2
You are assigning the empty string to $comment and $date with =
if($email == '' || $comment = '' || $date = '')
exit();
// Should use `==` for all three:
if($email == '' || $comment == '' || $date == '')
exit();
answered Sep 10, 2011 at 20:17
Michael Berkowski
271k47 gold badges450 silver badges395 bronze badges
Sign up to request clarification or add additional context in comments.
Comments
You are trying to compare $comment and $date with invalid character
please replace this line:
if($email == '' || $comment = '' || $date = '')
with
if($email == '' || $comment = '' || $date == '')
Sébastien Renauld
19.8k2 gold badges50 silver badges69 bronze badges
answered May 28, 2019 at 10:40
Javed Khan
3955 silver badges9 bronze badges
Comments
default