Jump to content

The comments aren't displaying???


cturner

Recommended Posts

After adding a comment I try to view the comment and it just displays a blank page. Can someone please tell me why and how I can fix? Thanks in advance.

Here is the code to add a comment:
[code]
require "config2.php";
$arrErrors = array();

// the publish button
if (isset($_POST['publish'])) {
// if comment field is empty display a message
if ($_POST ['comment'] == '') {
$arrErrors['comment'] = 'Please enter a comment.';
}

// if no errors insert data into database
if (count($arrErrors) == 0) {
// get the id number
$articleid = mysql_real_escape_string($_GET['articleid']);
// get the user's username that made the comment
$username = mysql_real_escape_string($_COOKIE['username']);
// get the comment from the form
$comment = mysql_real_escape_string($_POST['comment']);
// get today's date
$date_entered = date("j F, Y");
$date = mysql_real_escape_string($date_entered);
// insert the articleid into the commentpost table
$insert = "INSERT INTO `commentpost` (`id`, `articleid`, `comment`, `date_entered`, `username`) VALUES (0, '$articleid', '$comment', '$date', '$username')";

if (mysql_query ($insert)) {
// once the data has been added go to the comment_added page
header ('Location: comment_added.php');
} else {
print "<p>Could not add the entry because: <b>" . mysql_error() .
"</b>. The query was $insert.</p>";
}

} else {
// The error array had something in it. There was an error.
    // Start adding error text to an error string.
    $strError = '<div class="formerror"><p>Please check the following and try again:</p><ul>';
    // Get each error and add it to the error string
    // as a list item.
    foreach ($arrErrors as $error) {
$strError .= "<li>$error</li>";
}
    $strError .= '</ul></div>';
}
}
[/code]

Here is the code to view the comments:
[code]
require "config2.php";
$articleid = mysql_real_escape_string($_GET['articleid']);

// select the articleid
$query = "SELECT * FROM `commentpost` WHERE `articleid` = $articleid";
$result = mysql_query ($query) or die("Could not query because: " . mysql_error());

while($row = mysql_fetch_array($result)) {
// print the comments for that article and the date entered and the username
echo "<br /><br />".$row['date_entered']."<br />".$row['comment']."<br />";
echo $row['username']."<br />";
}

mysql_close();
[/code]
Link to comment
https://forums.phpfreaks.com/topic/24623-the-comments-arent-displaying/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.