Learn VBA & Macros in 1 Week!

PHP - Need Help With Ghost Comments

Full Excel VBA Course - Beginner to Expert

Need Help With Ghost Comments	View Content

Hi,
i wonna put on my website to ghosts can post comments and registred users, and i made 2 tables ghosts and users, now i need method to save ghosts on that table, but how to save them with uniq number?
I tried session_id, but it works bad, when someone comment it write in db his session_id, but after some time, when someone else comment, it can get his session_id, or no ?

Full Excel VBA Course - Beginner to Expert

How To Get Count Comments For Multiple Comments Page

Similar Tutorials

View Content

I have a problem with the "comments count" in the toggle link in my blog: www.albertosotophotography.com I have this script for show/hide comments in main page:

<script type= "text/javascript">
// Show/Hide Comments
jQuery(document).ready(function() {

// Get #comments div
var uniqueAppend = 1;
var tempName = 'comments';
while(jQuery("#comments").length > 0 ){
jQuery("#comments").attr('id',tempName + uniqueAppend++).addClass('commentContainer')
}
var commentsDiv = jQuery('.commentContainer');

// Only do this work if that div isn't empty
if (commentsDiv.length) {

// Hide #comments div by default
jQuery(commentsDiv).hide();

// Append a link to show/hide
jQuery('<a/>')
.attr('class', 'toggle-comments')
.attr('href', '#')
.html('Notes')
.insertAfter(commentsDiv);

// Encase button in .toggle-comments-container div
jQuery('.toggle-comments').wrap(jQuery('<div/>', {
class: 'toggle-comments-container'
}))

// When show/hide is clicked
jQuery('.toggle-comments').on('click', function(e) {
e.preventDefault();


// Show/hide the div using jQuery's toggle()

var commentContainer = jQuery(this).parent('.toggle-comments-container').prev('.commentContainer');

jQuery(commentContainer).slideToggle('slow', function() {

// change the text of the anchor
var anchor = jQuery(commentContainer).siblings('.toggle-comments-container').children('.toggle-comments');
var anchorText = anchor.text() == 'Notes' ? 'Hide' : 'Notes';
jQuery(anchor).html(anchorText);

});
});

} // End of commentsDiv.length

}); // End of Show/Hide Comments
</script>

I use:

.html('<?php comments_number( '0 notes', '1 note', '% notes' ); ?>')

for name the "comments toggle link" with the count of comments for each single post. The problem is that all posts shows the same count: the comments presents in the first post. Someone can help me? Alberto

Getting Ghost Pages With Page Count Code

Similar Tutorials

View Content

Hi Everyone,

I have an ecommerce store that I have done some coding for, and each category has some coding to create pages to display items in that category. For some reason, I am getting a couple of "ghost" pages on the end of a couple categories.

For example, look at this page: http://www.autismcommunitystore.com/view.php?category=4

Pages 5 & 6 are blank - page 4 has the last of the items in the category. I have a table called prods_to_cats which connects the products and the categories (a many to many relationship).

I'm posting the code here - could someone just let me know if they spot something that looks like trouble?

Thank you in advance for your time!

Code: [Select]
<?
$category=$_REQUEST['category'];
$showcategory=$category;

include 'connect.php';

$thiscategory = mysql_query("SELECT * FROM category WHERE category_id=$showcategory", $dbh);
$thisrow = mysql_fetch_array($thiscategory);
$this_des=$thisrow["category_description"];
$this_text=$thisrow["category_text"];

$titlekey="Products listed in $this_des at Autism Community Store 877-422-5932";

// If current page number, use it
// if not, set one!

if(!isset($_GET['page'])){
$page = 1;
} else {
$page = $_GET['page'];
}

// Define the number of results per page
$max_results = 40;

// Figure out the limit for the query based
// on the current page number.
$from = (($page * $max_results) - $max_results);

echo '<div id="product">';
$result = mysql_query("SELECT DISTINCT product.id, product.* FROM prods_to_cats INNER JOIN product ON prods_to_cats.id=product.id WHERE prods_to_cats.category_id=$showcategory ORDER BY product.title ASC LIMIT $from, $max_results", $dbh);
$numresult = mysql_num_rows($result);
if($numresult==0)
{
echo "<p style='padding-left: 50px'>There are no products listed in this category.</p>\n";
}
else
{

$thiscategory = mysql_query("SELECT * FROM category WHERE category_id=$showcategory", $dbh);
$thisrow = mysql_fetch_array($thiscategory);
$this_des=$thisrow["category_description"];
echo "<table width='100%'><tr>";

echo "<div style='position:relative; left:150px;'><font size='2'>Return To: <strong><a href='http://www.autismcommunitystore.com'>Home </a></strong></font></div><br/>";

echo "<div style='position:relative ; width:100%' align='center'>";
echo "<br />";
echo "<img src='http://www.watchesandthings.com/autism/images/suppliesHeader.gif'>";
echo "</div>";
echo "<h2>";
echo "<div style='padding-right:20px ; position:relative ; width;100%; text-align:right;'>";
echo "<div style='position:relative ; width;80%; text-align:center; left:20%;'>";
echo $this_des;
echo "</div>";
echo "</div>";
echo "</h2>";
echo "<div style='position:relative ; padding-left:30px ; padding-right:30px ; '>";
echo "<p>";
echo "$this_text </p>";
echo "</div>";
echo "</tr>";

$count = 1;
$column = 1; //initialize column 1 or 2

//-----------------------code for drop down menu----------------------------------------
include 'browserChecker.php';

/*
echo $browser;
echo "<br/>";
echo $browser_version;
echo "<br/>";
$main_version=$browser_version[0];
echo $main_version;
*/

if ($browser=='IE' && $browser_version<7){
echo '<br />';
//make version 6 compatible select box
if ($category==1 || $category==24){
}else{
?>

<center>
<div id="hiddendiv" style="display:;">
<form method="get" enctype="multipart/form-data" action="http://www.autismcommunitystore.com/viewsubcategory.php">
<select id="myselectbox" name="subcategory" >
<?
$sql="SELECT * FROM subcategory ORDER BY sub_description ASC";
$result=mysql_query($sql, $dbh);

while($myrow=mysql_fetch_array($result))
{
if ($myrow['category_id']==$category){

$myrow['sub_description']

?>
<option name="subcategory" value="<? echo $myrow['sub_id'] ?>" ><? echo $myrow['sub_description'] ?> </option>
<?
}//close if for category check
}//close drop down while loop

?>
</select>
</center>
<div id="go_subcat">
<input type="submit" value="  GO  " style="background-color: #E4DFF3; color: #6F5079; border: 2px solid #6F5079">
</div>
</form>
</div>
<?
}//end check category

}else{
//make normal select box

if ($category==1 || $category==24){
}else{
?><div style="z-index:2"><br /><form method="get" enctype="multipart/form-data" action="http://www.autismcommunitystore.com/viewsubcategory.php">
<div align="center" style='z-index:5'>
<select name="subcategory" size="1" style="background-color: #ffffff; color: #6F5079; border: 2px solid #6F5079">
<?
$sql="SELECT * FROM subcategory ORDER BY sub_description ASC";
$result=mysql_query($sql, $dbh);

while($myrow=mysql_fetch_array($result))
{
if ($myrow['category_id']==$category){

?>
<option name="subcategory" value="<? echo $myrow['sub_id'] ?>" ><? echo $myrow['sub_description'] ?>  </option>
<?
}//close if for category check
}//close drop down while loop

?>
</select>
<input type="submit" value="  GO  " style="background-color: #E4DFF3; color: #6F5079; border: 2px solid #6F5079">
</div>
</form>
</div>

<?
}

}//end browser checker if

//-----------------------end code for drop down menu----------------------------------------

//reste variables
$result = mysql_query("SELECT DISTINCT product.id, product.* FROM prods_to_cats INNER JOIN product ON prods_to_cats.id=product.id WHERE prods_to_cats.category_id=$showcategory ORDER BY product.title ASC LIMIT $from, $max_results", $dbh);

echo "<TABLE cellspacing='20'>";
while($myrow = mysql_fetch_array($result))
{

extract($myrow);
$location=$image;
$price=$sale_price;
$item=$myrow["id"];
$stockstatus=$stat;
if($stat=='IN STOCK')
{
$stockstatus="";
}
else
{
$stockstatus="--Item Coming Soon--";
}
if($price>0)
{
$printout="<table border=0 height=70 width=250><tr><td width='100px' align='center' ><a href=http://www.autismcommunitystore.com/item/$item/><img src=http://www.watchesandthings.com/autism/files/thumbnails/$location border=0 alt=$product_id></a></td><td><a href=http://www.autismcommunitystore.com/item/$item/>$title</a><br><span class=prod-dollar>$$price</span><br>$stockstatus</td></tr></table>";
}
else
{
$printout="<table border=0 height=70 width=250><tr><td width='100px' align='center' ><a href=http://www.autismcommunitystore.com/item/$item/><img src=http://www.watchesandthings.com/autism/files/thumbnails/$location border=0 alt=$product_id></a></td><td><a href=http://www.autismcommunitystore.com/item/$item/>$title<br /><span class=prod-dollar>Click for Pricing</span></a><br>$stockstatus</td></tr></table>";
}
if ($column=="1")
{
echo "<tr><td>$printout</td>"; // first column
}
else {
echo "<td>$printout</td></tr>"; // 2nd column
}
// end of columns
$count += 1;
// this is a modulus operator it gets the remainder of the equation
$column = $count % 2;
} // end of while loop
echo "</table>";
;

// Figure out the total number of results in DB:
$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM prods_to_cats WHERE category_id=$showcategory"),0);
//$total_results = mysql_result(mysql_query("SELECT COUNT(*) as Num FROM product"),0);

// Figure out the total number of pages. Always round up using ceil()
$total_pages = ceil($total_results / $max_results);

echo "<p><center>Pages<br />";

// Build Previous Link
if($page > 1){
$prev = ($page - 1);
echo "<a href='http://www.watchesandthings.com/autism/view.php?category=$showcategory&page=$prev'><<Previous</a> ";
}

for($i = 1; $i <= $total_pages; $i++){
if(($page) == $i){
echo "$i ";
} else {
echo "<a href='http://www.watchesandthings.com/autism/view.php?category=$showcategory&page=$i'>$i</a> ";
}
}

// Build Next Link
if($page < $total_pages){
$next = ($page + 1);
echo "<a href='http://www.watchesandthings.com/autism/view.php?category=$showcategory&page=$next'>Next>></a>";
}

echo "</center>";

}//end of else>

echo "</table>";
echo "</div>";
?>

Any Comments?

Similar Tutorials

View Content

Hello!

I'm trying to dive into Dreamweaver's code so that I can better understand what the heck it's doing in order to modify it to my specific needs. My PHP book is great, but it just seems like Dreamweaver's code is much more complicated than how I'd write it based on what I've read about PHP (Disclaimer: been with PHP for a week). It would be incredibly helpful if someone could write comments for each of the lines in terms of what it's doing (the more specific the better). I appreciate that this is a bit of a tedious question to ask, but it would be really appreciated.

Thank you.

Code: [Select]
$editFormAction = $_SERVER['PHP_SELF'];
if (isset($_SERVER['QUERY_STRING'])) {
$editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
}

if ((isset($_POST["MM_insert"])) && ($_POST["MM_insert"] == "form2")) {
$insertSQL = sprintf("INSERT INTO users (first_name, last_name, user_type, email, school_id) VALUES (%s, %s, %s, %s, %s)",
GetSQLValueString($_POST['first_name'], "text"),
GetSQLValueString($_POST['last_name'], "text"),
GetSQLValueString($_POST['user_type'], "text"),
GetSQLValueString($_POST['email'], "text"),
GetSQLValueString($_POST['school_id'], "int"));

mysql_select_db($database_connalgebra, $connalgebra);
$Result1 = mysql_query($insertSQL, $connalgebra) or die(mysql_error());

// The code below gives the last autogenerated userid.
$id = mysql_insert_id();
$updateusername = "UPDATE users SET username = CONCAT(first_name, $id) WHERE user_id = $id";
$Result2 = mysql_query($updateusername, $connalgebra) or die(mysql_error());
//

$insertGoTo = "add_user.php";
if (isset($_SERVER['QUERY_STRING'])) {
$insertGoTo .= (strpos($insertGoTo, '?')) ? "&" : "?";
$insertGoTo .= $_SERVER['QUERY_STRING'];
}
header(sprintf("Location: %s", $insertGoTo));
}

mysql_select_db($database_connalgebra, $connalgebra);
$query_rsSchools = "SELECT school_id, school_state, school_city, school_name, school_country FROM schools ORDER BY school_name ASC";
$rsSchools = mysql_query($query_rsSchools, $connalgebra) or die(mysql_error());
$row_rsSchools = mysql_fetch_assoc($rsSchools);
$totalRows_rsSchools = mysql_num_rows($rsSchools);

Comments

Similar Tutorials

View Content

Hello im trying to make a comment feature by having a link under my pictures kommentar.php?link=1
Then use the link=1 to see what comments that should be taken from the database. The comments have a linkid
like this

Linkid: Text:
1 a comment on first picture
1 another comment on first picture
2 a comment on second picture
2 another comment on second picture

But i can't get my php to echo all the comments with the linkid of for example 1 without having to get them all separately.

This is my script:

<?php
ob_start();
$host="localhost";
$username="****";
$password="******";
$db_name="db";
$tbl_name="comment";

mysql_connect($host, $username, $password)or die("cannot connect");
mysql_select_db("$db_name")or die("cannot select DB");

$linkid=filter_input(INPUT_GET,'link');

$sql="SELECT * FROM $tbl_name WHERE linkid='$linkid'";
$result=mysql_query($sql);
$grejs=null;
while(mysql_fetch_row($result)){
$grejs.="$row[0]";
}
echo $grejs;
ob_end_flush();
?>

Question About Comments

Similar Tutorials

View Content

What does this code do/mean?

/*
* @the vars array
* @access private
*/

TomTees

Adding Comments

Similar Tutorials

View Content

Hi all,

I've got a news table as such;

`id` int(255) NOT NULL auto_increment,
`title` mediumtext NOT NULL,
`postedby` mediumtext NOT NULL,
`text` mediumtext NOT NULL,
`brief` mediumtext NOT NULL,
`timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP,
`image` varchar(255) NOT NULL default '',
PRIMARY KEY (`id`)

I was wondering in PHP how would i be able to add comments to the news?

i.e

Form: Name, IP (hidden), comments
I'll add the name, ip and comments to the database

But how do i go around adding that into php?

Comments And Security

Similar Tutorials

View Content

Is it true that PHP Comments are hidden from end users?

And is it dangerous to put extensive comments in your code (e.g. links to developer sites, article excerpts, etc)?

I am re-factoring my website, and have found some really helpful articles that I'd like to post in my code so I don't forget what I'm doing 6 months from now, but don't want to cause any issues. (I know this sounds wimpy, but I am a newbie?!)

Debbie

Comments Not Working

Similar Tutorials

View Content

ok here is my script , for some reason , it adds the comment and all it works great , but it wont add it to the notifications table in my database
Code: [Select]
<?php include("../includes.php");
$session = $logOptions_id;
if($session)
{
$to_id = $_POST['user_id'];
$post_id = $_POST['post_id'];
$comment = mysql_real_escape_string($_POST['comment']);
$date = mktime();
mysql_query("INSERT INTO comments SET user_id='$to_id', from_id='$session', post_id='$post_id', comment='$comment', date='$date'");
$id = mysql_insert_id();

$query = mysql_query("SELECT * FROM comments WHERE post_id='$post_id' AND from_id!='$session' AND state='0' GROUP BY from_id");
if(mysql_num_rows($query)>0)
{
$row1 = mysql_fetch_assoc(mysql_query("SELECT * FROM posts WHERE id='$post_id'"));
$post_from2 = $row1['from_id'];
mysql_query("INSERT INTO notifications SET user_id='$post_from2', from_id='$session', post_id='$id', action_type='4', date='$date'");

while($row = mysql_fetch_array($query))
{
$post_from = $row['from_id'];
if($post_from!=$post_from2)
{
mysql_query("INSERT INTO notifications SET user_id='$post_from', from_id='$session', post_id='$id', action_type='4', date='$date'");
}
}

}
else
{
$row1 = mysql_fetch_assoc(mysql_query("SELECT * FROM posts WHERE id='$post_id'"));
$post_from = $row1['from_id'];
mysql_query("INSERT INTO notifications SET user_id='$post_from', from_id='$session', post_id='$id', action_type='4', date='$date'");
}

$query = mysql_query("SELECT * FROM comments WHERE id='$id' AND state='0'");
comments($query);
}
?>

News With Comments

Similar Tutorials

View Content

Got this script he
http://www.codewalkers.com/c/a/Database-Articles/PHPMySQL-News-with-Comments/6/

Everything works, and I mean EVERYTHING. The problem is, when the form gets submitted, the database isn't being queried/updated/whatever. It worked at first, but after I started customizing/modifying it, it quit working.

Here's my modified script:
Code: [Select]
<?php
//**********************************//
//**********************************//
/*******user config variables********/
/* max number of news items to show */
//**********************************//
//**********************************//
$max_items = 5;

//***********************//
//***********************//
//***********************//
//make database connection//
//***********************//
//***********************//
//***********************//
$db = mysql_connect ('my hostname','my username','my password');
mysql_select_db ('my database name',$db);

//If not all of the news articles are being displayed...
function displayNews($all = 0) {

/* bring in two variables
* $db is our database connection
* $max_items is the maximum number
* of news items we want to display */
    global $db, $max_items;

/* query for news items */
    if ($all == 0) {

/* this query is for up to $max_items; only five news articles will be displayed */
        $query = "SELECT id,title,body," .
                 "DATE_FORMAT(date, '%m-%d-%Y') as date " .
                 "FROM news ORDER BY id DESC LIMIT $max_items";
    } else {

/* this query will get all news; $max_items will be false */
        $query = "SELECT id,title,body," .
                 "DATE_FORMAT(date, '%Y-%m-%d') as date " .
                 "FROM news ORDER BY id DESC";
    }

    $result = mysql_query ($query);
    while ($row = mysql_fetch_assoc ($result)) {

/* place table row data in
* easier to use variables.
* Here we also make sure no
* HTML tags, other than the
* ones we want are displayed */
$date = $row['date'];
        $title = htmlentities ($row['title']);
        $news = nl2br (strip_tags ($row['body'], '<a><b><i><u>'));
$url = $row['id'];

/* display the data (news) */
        echo "<table border=\"0\" width=\"100%\"><tr><td><strong><h2><a href=\"{$_SERVER['PHP_SELF']}" .
             "?action=show&id={$row['id']}\">$title</a></h2></strong> <em>posted on $date</em> | by <strong>DJ Smiley</strong></td></tr>\n";
        echo "<tr><td>";
echo stripslashes(substr($news, 0, 500));
echo "...<a href=\"{$_SERVER['PHP_SELF']}" .
             "?action=show&id={$row['id']}\">read more</a></td></tr>\n";

/* get number of comments from database */
        $comment_query = "SELECT count(*) FROM comments " .
                         "WHERE news_id={$row['id']}";
        $comment_result = mysql_query ($comment_query);
        $comment_row = mysql_fetch_row($comment_result);

/* display number of comments with link; add twitter, facebook, digg, and share widgets; and add email sharing widget */
echo "</table>\n<table width=\"100%\" border=\"0\">
<tr>
<td width=\"6%\"><a href=\"{$_SERVER['PHP_SELF']}" .
"?action=show&id={$row['id']}\"><img src=\"images/Icons/Comment/2.png\" width=\"20\" height=\"20\" class=\"fltlft2\"/></a>$comment_row[0]</td>
<td width=\"13%\">
<a href=\"http://www.freetellafriend.com/tell/\" onclick=\"window.open('http://www.freetellafriend.com/tell/?option=email&heading=Tell+A+Friend&bg=14&url=http%3A%2F%2Fhttp://www.djsmiley.net/index.php?action=show&id={$row['id']}', 'freetellafriend', 'scrollbars=1,menubar=0,width=435,height=500,resizable=1,toolbar=0,location=0,status=0,left='+(screen.width-435)/2+',top='+(screen.height-500)/3);return false;\"><img alt=\"Tell a Friend\" src=\"http://serv1.freetellafriend.com/s14.png\" border=\"0\" /></a>
</td>
<td width=\"81%\"><span class=\"st_twitter_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&id={$row['id']}\" displayText=\"Tweet\" st_title=\"{$row['title']}\"></span><span class=\"st_facebook_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&id={$row['id']}\" displayText=\"Share\" st_title=\"{$row['title']}\"></span><span class=\"st_email_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&id={$row['id']}\" displayText=\"Email\"></span><span class=\"st_sharethis_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&id={$row['id']}\" displayText=\"Share\"></span></td>
</tr>
</table><br>";

    }

/* if we aren't displaying all news,
* then give a link to do so */
    if ($all == 0) {
        echo "<br><div style=\"border-radius: 10px; border: solid 2px #E5E5E5; padding: 10px; margin: 5px; background: #F6F6F6;\"></p><a href=\"{$_SERVER['PHP_SELF']}" .
             "?action=all\">View All Articles</a></p></div>";
    }
}

//function for displaying only one item
function displayOneItem($id) {
    global $db;

/* query for item */
    $query = "SELECT * FROM news WHERE id=$id";
    $result = mysql_query ($query);
$row = mysql_fetch_assoc($result);

/* easier to read variables and
* striping out tags */
    $title = htmlentities ($row['title']);
    $news = nl2br (strip_tags ($row['body'], '<a><b><i><u>'));

/* if we get no results back, error out */
    if (mysql_num_rows ($result) == 0) {
        echo "This news article does not exist!\n";
        return;
    }

    echo "<TABLE border=\"0\" width=\"100%\">\n";


/* displays individual article user visits */
echo "<tr><td><strong><h2><a href=\"{$_SERVER['PHP_SELF']}" .
"?action=show&id={$row['id']}\">$title</a></h2></strong> <em>posted on $date</em> | by <strong>DJ Smiley</strong></td></tr>\n";
        echo "<tr><td>";
echo stripslashes($news);
echo "</td></tr>\n";
echo "</table>\n";
echo "<br>\n";
echo ("</table>\n<table width=\"100%\" border=\"0\">
  <tr>
    <td width=\"6%\"><a href=\"{$_SERVER['PHP_SELF']}" .
"?action=show&id={$row['id']}\"><img src=\"images/Icons/Comment/2.png\" width=\"20\" height=\"20\" class=\"fltlft2\"/></a>$comment_row[0]</td>
    <td width=\"13%\">
<a href=\"http://www.freetellafriend.com/tell/\" onclick=\"window.open('http://www.freetellafriend.com/tell/?option=email&heading=Tell+A+Friend&bg=14&url=http%3A%2F%2Fhttp://www.djsmiley.net/index.php?action=show&id={$row['id']}', 'freetellafriend', 'scrollbars=1,menubar=0,width=435,height=500,resizable=1,toolbar=0,location=0,status=0,left='+(screen.width-435)/2+',top='+(screen.height-500)/3);return false;\"><img alt=\"Tell a Friend\" src=\"http://serv1.freetellafriend.com/s14.png\" border=\"0\" /></a>
</td>
    <td width=\"81%\"><span class=\"st_twitter_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&id={$row['id']}\" displayText=\"Tweet\"></span><span class=\"st_facebook_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&id={$row['id']}\" displayText=\"Share\"></span><span class=\"st_email_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&id={$row['id']}\" displayText=\"Email\"></span><span class=\"st_sharethis_hcount\" st_url=\"http://www.djsmiley.net/index.php?action=show&id={$row['id']}\" displayText=\"Share\"></span></td>
  </tr>
</table>");

/* now show the comments */
    displayComments($id);
}

function displayComments($id) {

/* bring db connection variable into scope */
    global $db;

/* query for comments */
    $query = "SELECT * FROM comments WHERE news_id=$id";
    $result = mysql_query ($query);
echo "<h2>Comments</h2>";

/* display the all the comments */
    while ($row = mysql_fetch_assoc ($result)) {

//sets variables
$comment = strip_tags ($row['comment'], '<a><b&><i><u>');
        $comment = nl2br ($comment);
        $name = htmlentities ($row['name']);
$time = ($row['time']);

echo "<div style=\"border-radius: 10px; border: solid 2px #E5E5E5; padding: 10px; margin: 5px; background: #F6F6F6;\"><p><table border=\"0\" width=\"100%\"><tr><td><strong>$name</strong> says:</td></tr></table>
<table><tr><td><img src=\"images/Icons/People/Anonymous 2.png\" alt=\"\" width=\"50\" height=\"50\"/></td><td>$comment</td></tr></table><table><tr><td>added on $time</td></tr></table></p></div>";
    }

/* add a form where users can enter new comments */
    echo "<form action=\"{$_SERVER['PHP_SELF']}" .
"?action=addcomment&id=$id\" method=post>
<h2>Comment</h2><table width=\"37%\" border=\"0\">
  <tr>
<td width=\12%\">Name:</td>
<td width=\"88%\"><label>
  <input type=\"text\" name=\"name\" id=\"name\" class=\"commentBoxforms\">
</label></td>
  </tr>
  <tr>
<td>Comment:</td>
<td><label>
  <textarea name=\"comment\" id=\"comment\" cols=\"45\" rows=\"5\" class=\"commentField1\"></textarea>
</label></td>
  </tr>
  <tr>
<td> </td>
<td><label>
  <input type=\"submit\" name=\"submit\" id=\"submit\" value=\"Comment\" class=\"Button1\">
</label></td>
  </tr>
</table>
</form>\n";

}

function addComment($id) {
    global $db;

    /* insert the comment */
    $query = "INSERT INTO comments " .
           "VALUES('',$id,'{$_POST['name']}'," .
             "'{$_POST['comment']}')";
    mysql_query($query);

    echo "Your comment has been posted!<br>\n";
    echo "<a href=\"{$_SERVER['PHP_SELF']}" .
         "?action=show&id=$id\">Return To Previous Page</a>\n";
}

/* this is where the script decides what do do */
switch($_GET['action']) {

    case 'show':
        displayOneItem($_GET['id']);
        break;
    case 'all':
        displayNews(1);
        break;
    case 'addcomment':
        addComment($_GET['id']);
        break;
    default:
        displayNews();
}
?>
Can anyone tell me where this script is going wrong? I've literally tried EVERYTHING. I even went back to the original script and compared every single character to mine, but NO luck.

PLEASE HELP!

Vote On Comments

Similar Tutorials

View Content

Hello,

I have built a blog in php but. On each article in the blog people are able to comment.

I would now like to build a system where people can vote on the comment up/down with Ajax.

In my comments database I have a table that looks like this:

id / article_id / user_id / dateposted / comment / voteup / votedown

I would like it to look like this:

Any ideas how I can do this? Tutorials online?

Thanks a million

Xml Ignoring Comments

Similar Tutorials

View Content

Hi all,

I have another uestion. I am currently working with an XML document that has some comments in it that need to stay however it is messing up my parser that I am working on. How can I get around this issue and make the php parser ignore the comments? here is a snippet of the code I am working on.

php
Code: [Select]
//open XML file containing data for current slide

$currentslidefilepath = "slides/xml/";
$currentslidefilepath .= $slides[$currentslide];
$currentSlideXml = simplexml_load_file($currentslidefilepath);

XML
Quote



<Basic>
<another>some data</another>
</Basic>

Help With Comments On A Website

Similar Tutorials

View Content

Hey guys not sure if this is the right spot for this 100% but I hope it is.

I have a website that I'm making for a class project and I would like it to be a Movie Review type site. What I want to happen is that a person searches for the movie, and once if they find the movie it goes to another page saying if it was found or not. And if it was found information of the movie would come up. I made a comment section for people to be able to post what they thought about the movie. (It doesn't work yet but it should be up soon)

But anyway how would I make it so like say a person searches for "avatar" and the movie pops up with the information, that the review is for avatar and only avatar. Then next they search for Lord of the rings, and only lord of the rings reviews pop up?

And just to let ya know I'm not a super coder with this stuff and I am using dreamweaver cs5 to do a lot of the coding. Any and all help would be appreciated.

How To Get Nested Comments

Similar Tutorials

View Content

I'm wondering how I can output nested comments.

I have written a viewthread.php file that works nicely so far. From index.php it gets the IDOfThread and passes this to a $number then outputs all the comments assigned to the Thread ID

However I'd like to be able to respond to each comment to create nested comments

This is my viewthread.php so far

<!DOCTYPE html>

<html> 
<header> 
<link href="styles.css" rel="stylesheet" type="text/css" media="all">
<title>test Image Board</title>

 <div class="header">
  <a href="index.php" class="logo">test forum online</a>
  <div class="header-right">
    <a class="active" href="#home">Home</a>
    <a href="#news">News</a>
    <a href="#contact">Education</a>
    <a href="#about">Tech</a>
  </div>
</div> 
</header> 
<body> 

<!-- <a href="CreateThread.php"> <h1>Create Thread</h1> </a> --> 


<div class ='Thread-grid-container'>
<?php
include 'dbconnect.php';
$number = intval($_GET['id']) ; 
session_start();
$_SESSION['id'] = $number ;
$query = mysqli_query($conn, "SELECT * FROM Threads where id=$number")
   or die (mysqli_error($conn));
//Output Grid layout for a Thread post
while ($row = mysqli_fetch_array($query)) {
//output picture from upload folder
        $imageURL = 'upload/'.rawurlencode($row["filename"]);
  echo
  
   "  <div class ='Thread-grid-item'>
<div class='ThreadNumber'> Post {$row['id']}<br> </div> 

      	<div class='UserOnThread'>{$row['Users']} </div> 
      	<h2>{$row['Title']} </h2> 

      	<button type='button' class ='collapse'>Hide</button>
		<div class ='img-block'> 
		 <img src={$row['$imageURL']}$imageURL alt='' />		
		</div> 
	<div class='bodytextThread'> <p>{$row['ThreadBody']}</p> </div>

		
      </div> 


    \n";
}?>

<div class="comment-upload-box"> 
<form action="CommentUpload.php" method="post" enctype="multipart/form-data">
<table>
<tr>
<td></td>
</tr>
<tr>
<td>Comment: </td>
<td> <textarea name="CommentText" cols="100" rows="10" > Enter your posts... 
</textarea>
 </td>
<td></td>
</tr>
<tr>
<td></td>
<td><input type="submit" name='submit' value="Submit"/></td>
<td></td>
</tr>
</table> 
</form>

</div>
<div class='divTableForComments'>
<div class='divTableBody'>

<?php 
include 'dbconnect.php';
//Output Comments onto page

//Create a variable for the Comment boxes so when clicking reply a text area shows 
$ChildCommentBoxes = "<div class='child-comment-upload-box' style='margin-left: 48px'> 
<form action='ChildCommentUpload.php' method='post' enctype'multipart/form-data'>
<table>
<tr>
<td></td>
</tr>
<tr>
<td>Comment: </td>
<td> <textarea name='ChildCommentText' cols='100' rows='10' > Enter your posts... 
</textarea>
 </td>
<td></td>
</tr>
<tr>
<td></td>
<td><input type='submit' name='submit' value='Submit'/></td>
<td></td>
</tr>
</table> 
</form>";

$query = mysqli_query($conn, "SELECT * FROM Posts where IDOfThread=$number")
   or die (mysqli_error($conn));

while ($row = mysqli_fetch_array($query)) {
//May need this later to output pictures   
//     $imageURL = 'upload/'.rawurlencode($row["filename"]);
$CommentText = nl2br($row['CommentText']) ; 

$ParentComment = ""  ;
$replies = ""  ;
if (empty($row['ParentId'])) {

$ParentComment .=    "  <div class='divTableRow'>
	<div class='divTableCell'>{$row['User']} 
	<div class='pointsincommentbox'> {$row['Upvotes']}points</div>
	<div class='divTableComment'> 
		$CommentText <br>
	<div class='divCommentLinks'> 
		 <div class='upvotes'> ⬆</div> 
		<div class='upvotes'> ⬇</div> 
		<div> view comment </div> 
		<div>report </div> 
		<div>permalink</div> 
		<button type='button' class ='CommentChildButton'>reply</button>
		<div class ='OpenChildCommentBox'> 
		 $ChildCommentBoxes 	
		</div> 
	</div>

 </div>

</div>
</div> 
    \n";
}
    echo "$ParentComment "; 
}
?> 

<div class ="sidebar"> </div> 

</body> 
</html> 

<script>
var coll = document.getElementsByClassName("collapse");
var i;

for (i = 0; i < coll.length; i++) {
  coll[i].addEventListener("click", function() {
    this.classList.toggle("active");
    var content = this.nextElementSibling;
    if (content.style.display === "block") {
      content.style.display = "none";
    } else {
      content.style.display = "block";
    }
  });
}
</script>


<script>
var coll2 = document.getElementsByClassName("CommentChildButton");
var i;

for (i = 0; i < coll2.length; i++) {
  coll2[i].addEventListener("click", function() {
    this.classList.toggle("active");
    var content = this.nextElementSibling;
    if (content.style.display === "block	") {
      content.style.display = "none";
    } else {
      content.style.display = "block";
    }
  });
}
</script>

And this is what it looks like

I think I would probably change the margin of the responses to jut them in a bit and am thinking the best way would be to create a function that cycles through and where it finds a ParentId of a comment matching the Posts.id it would then put this beneath it?

My comments are stored in a table titled Posts and Posts looks like

MariaDB [test]> describe Posts ; 
+---------------+-----------------+------+-----+---------------------+-------------------------------+
| Field         | Type            | Null | Key | Default             | Extra                         |
+---------------+-----------------+------+-----+---------------------+-------------------------------+
| id            | int(6) unsigned | NO   | PRI | NULL                | auto_increment                |
| User          | varchar(30)     | NO   |     | NULL                |                               |
| PostTimeStamp | timestamp       | NO   |     | current_timestamp() | on update current_timestamp() |
| CommentText   | varchar(8000)   | YES  |     | NULL                |                               |
| IDOfThread    | int(11)         | YES  |     | NULL                |                               |
| Upvotes       | int(11)         | NO   |     | 0                   |                               |
| ParentId      | int(11)         | YES  |     | NULL                |                               |
+---------------+-----------------+------+-----+---------------------+-------------------------------+
7 rows in set (0.002 sec)

Question About Comments

Similar Tutorials

View Content

I have one small question about comments.

say you have a code like this

Code: [Select]
<?php

$lol = 1;
$rofl = 2;
$lmao = 3;
// Above are my variable's

echo 'this does not get executed because the apostrophy in the comment acts as the start';

?>

Now if I wrote this code the apostrophe in variable acts as a quote and does not end until it meets another to end it. Why does this do that? I thought that when you start a comment that whole line gets ignored.

Could this possible be happening because of my text editor( I use textpad )? If so could you recommend a good text editor, thanks.

Trying To Output Multiple Comments

Similar Tutorials

View Content

So I'm trying to create a comment system with the comment SQL table looking like this

describe Posts 
    -> ;
+---------------+-----------------+------+-----+---------------------+-------------------------------+
| Field         | Type            | Null | Key | Default             | Extra                         |
+---------------+-----------------+------+-----+---------------------+-------------------------------+
| id            | int(6) unsigned | NO   | PRI | NULL                | auto_increment                |
| User          | varchar(30)     | NO   |     | NULL                |                               |
| PostTimeStamp | timestamp       | NO   |     | current_timestamp() | on update current_timestamp() |
| CommentText   | varchar(8000)   | YES  |     | NULL                |                               |
| IDOfThread    | int(11)         | YES  |     | NULL                |                               |
| Upvotes       | int(11)         | NO   |     | 0                   |                               |
| ParentId      | int(11)         | YES  |     | NULL                |                               |
| level         | int(11)         | YES  |     | NULL                |

So I then pull from the SQL table like this - creating an array for each 'level' of the data and how I want the comment to be displayed

while ($row = mysqli_fetch_array($query)) {
    //May need this later to output pictures
    //     $imageURL = 'upload/'.rawurlencode($row["filename"]);
    $CommentText = nl2br($row['CommentText']);
	 $avatarFilePath = $row['avatar'];
	 $id = $row['IDOfThread'];
	 $PostID = $row['id'] ; 
	 $ParentId = $row['ParentId']; 
    convertYoutube($CommentText);
    //Work out Margin for comment replies 
	$Level = $row['level'] * 75; // Used to multiply the margin to create nested comments  
	echo $Level ; 
	 //$Level = 1 * 75 ;  
	 $margin = 	"<div class='divTableCell' style='margin-left: $Level" . "px ; '>"; //input the margin in child comments
	 //$margin = 	"<div class='divTableCell' style='margin-left: 75" . "px ; '>"; //input the margin in child comments
    
    

    $ParentComment = "";
//Get parent comments into an array 
    if (empty($row['ParentId'])) {
           $ParentComments[$PostID] = "  <div class='divTableRow'>
	<div class='divTableCell'>
		<div class ='UserAndAvatarCommentBox'>
<div > <img src=$avatarFilePath alt='' />	</div> 
	<div class='profileUsername'> {$row['User']} </div> 
</div>
		<div class='pointsincommentbox'> {$row['Upvotes']}points</div>

		<div class='divTableComment'> 
		 $CommentText <br>
		 <div> 
			<div class='divCommentLinks'> 
		 <button type='button'> ⬆</button> 
		<button type='button'> ⬇</button> 
		<div> $PostID </div> 
		<button type='button'> view comment </button> 
		<button type='button'>report </button> 
		<button type='button'>permalink</button> 
		<button type='button' class ='CommentChildButton'>reply</button>
		<div class ='OpenChildCommentBox'> 
		
				<form action='CommentUpload.php' method='post' enctype='multipart/form-data'>
				<table>
				<tr>
				<td></td>
				</tr>
				<input type='text' value=$PostID name='PostId' />
				<input type='text' value='1' name='level' />
				<tr>
				<td>Comment: </td>
				<td> <textarea name='CommentText' cols='100' rows='10' > Enter your posts... 
				</textarea>
				 </td>
				<td></td>
				</tr>
				<tr>
				<td></td>
				<td><input type='submit' name='submit' value='Submit'/></td>
				<td></td>
				</tr>
				</table> 
				</form>
		
		  	
		</div> 
		</div> 
	</div>

 </div>

</div>
</div> 
    \n";
    }
   //Get child comments into an array level 1
       if ($row['ParentId'] && $row['level'] == 1 ) {
           $replies[$ParentId] = "  <div class='divTableRow'>
		<div class='divTableCell' style='margin-left:75px'>
		<div class ='UserAndAvatarCommentBox'>
<div > <img src=$avatarFilePath alt='' />	</div> 
	<div class='profileUsername'> {$row['User']} </div> 
</div>
		<div class='pointsincommentbox'> {$row['Upvotes']}points</div>

		<div class='divTableComment'> 
		 $CommentText <br>
			<div class='divCommentLinks'> 
		 <button type='button'> ⬆</button> 
		<button type='button'> ⬇</button> 
		<div> $PostID </div> 
		<button type='button'> view comment </button> 
		<button type='button'>report </button> 
		<button type='button'>permalink</button> 
		<button type='button' class ='CommentChildButton'>reply</button>
		<div class ='OpenChildCommentBox'> 
		
				<form action='CommentUpload.php' method='post' enctype='multipart/form-data'>
				<table>
				<tr>
				<td></td>
				</tr>
				<input type='text' value=$PostID name='PostId' />
				<input type='text' value={$row['level']} name='level' />
				<tr>
				<td>Comment: </td>
				<td> <textarea name='CommentText' cols='100' rows='10' > Enter your posts... 
				</textarea>
				 </td>
				<td></td>
				</tr>
				<tr>
				<td></td>
				<td><input type='submit' name='submit' value='Submit'/></td>
				<td></td>
				</tr>
				</table> 
				</form>
		
		
		 	
		</div> 
	</div>

 </div>
</div>
</div>
</div> 
    \n";
    }
  
//Get child comments into an array level 2
       if ($row['ParentId'] && $row['level'] == 2 ) {
           $Level2[$ParentId] = " 
		$margin
			<div class ='UserAndAvatarCommentBox'>
<div > <img src=$avatarFilePath alt='' />	</div> 
	<div class='profileUsername'> {$row['User']} </div> 
</div>
		<div class='pointsincommentbox'> {$row['Upvotes']}points</div>

		<div class='divTableComment'> 
		 $CommentText <br>
			<div class='divCommentLinks'> 
		 <button type='button'> ⬆</button> 
		<button type='button'> ⬇</button> 
		<div> $PostID </div> 
		<button type='button'> view comment </button> 
		<button type='button'>report </button> 
		<button type='button'>permalink</button> 
		<button type='button' class ='CommentChildButton'>reply</button>
		<div class ='OpenChildCommentBox'> 
		
				<form action='ChildCommentUpload.php' method='post' enctype='multipart/form-data'>
				<table>
				<tr>
				<td></td>
				</tr>
				<input type='text' value=$PostID name='PostId' />
				<input type='text' value={$row['level']} name='Level' />
				<tr>
				<td>Comment: </td>
				<td> <textarea name='CommentText' cols='100' rows='10' > Enter your posts... 
				</textarea>
				 </td>
				<td></td>
				</tr>
				<tr>
				<td></td>
				<td><input type='submit' name='submit' value='Submit'/></td>
				<td></td>
				</tr>
				</table> 
				</form>
		
		
		 	
		</div> 
	</div>

 </div>
</div>
</div>
</div> 
    \n";
    }
    
  

    }

Then after the data has been put into arrays I then output it using this foreach statement

foreach ($ParentComments as $key => $reply)
{
 	echo $reply  ;

	foreach ($replies as $childKey => $childReply)
	{ 
	if ($key == $childKey)
	{ 
	echo $childReply ; 
		foreach ($Level2 as $Key2 => $Level2Reply)
		{ 
		if ($childKey == $Key2) 
			{
				echo $Level2Reply ; 
 			} 
		
		}
	}
	}
}

So the problem I'm having is if you have a top level comment like

TopLevelComment

Then respond to it you get

TopLevelComment

-Level1ReplyComment

However if you respond again to the top level comment it only shows the new comment like

TopLevelComment

-NewLevel1Comment

Why would it do this rather than add another comment beneath the top level comment?

How To Handle Comments Preview

Similar Tutorials

View Content

I have just completed a modest way for Users to post Comments on Articles my website.

However, the thought occurred to me today, that I haven't given Users the ability to Preview or Edit their comments after submittal.

What is the best way to store info on a Comments Form so you can re-display it for Preview/Editing?? (I'm not really sure how the workflow would work for this?!)

Do I capture the Comments Form Data and store it in a Session? Or in my Database? Or do something else?

Security is always a concern of mine too!!

Thanks,

Debbie

Displaying Multiple Comments

Similar Tutorials

View Content

Not really sure what forum this would be a good fit for, but basically, I use a combination of jquery and php to display comments. I was going fine displaying the last comment, but now I have to display all the comments. I tried using some code I use to write pull down boxes, but that didn't work. I'm sure it could be done using json arrays, but I don't know how to process the results using jquery. jquery code:

//gets comments for initial secret
   var quid = "quid=<?=$ans['quid']?>";
   $.post("inc/comments_system.php", quid, function(data) {
    if(data.number > 0) {
     $("#comm").html("<p><a href='#'>"+data.number+"</a></p>");
     $("#cbox").show();
     $("#cdisplay").show().html(data.comment);
     $("#quid").attr("value", data.quid);
    } else {
    $("#comm").html("<p><a href='#'>"+data.number+"</a></p>");
    $("#quid").attr("value", data.quid);
   }
  }, "json");

PHP code

$q = mysql_query("SELECT COUNT(oid) as num, comment, username, oid, createdon FROM comments WHERE oid = $_POST[quid] ORDER BY createdon") or die(mysql_error());
 
  if(mysql_num_rows($q) != 0) {
   while($ans = mysql_fetch_assoc($q)) {
    $username .= "<div style='width: 95%; margin: 0 auto'>".$ans['comment']."<br /><div style='font-style: italic; text-align: right;'> -$ans[username]@ ".date('m-d-y G:i.s', strtotime($ans['createdon']))."</div></div>";
    $num = $ans['num'];
   }
   $ret = array("number" => $num, "comment" => stripslashes($comment), "quid" => $_POST['quid']);
  } else {
   $ret = array("number" => 0, "quid" => $_POST['quid']);
  }
echo json_encode($ret);

I just need to know what to do to get this to work.

Where To Store Comments (preview)?

Similar Tutorials

View Content

I added the ability for Users to "preview" their Comments before submitting them.

I just realized that when they click "Preview" that their Comments appear above the Comments form box - similar to how PHPFreaks works - but that the Comments form box loses it's data since the page reload causes this to lose things...

<li>
<label for="comments">Comments:</label>
<textarea id="comments" name="comments" cols="50" rows="15"><?php if (isset($comments)){echo nl2br(htmlentities($comments, ENT_QUOTES));} ?></textarea>

<?php
if (!empty($errors['comments'])){
echo '<span class="error">' . $errors['comments'] . '</span>';
}
?>
</li>

What is the easiest way to maintain form persistence? (I really would like to avoid having to store things in my database during the preview.)

How does PHPFreaks do things?

I was going to use a SESSION, but since this is a Comments field that can take up to 65,535 characters, that probably won't work?!

Any ideas?

Debbie

Can I Get Some Comments On My Database Design?

Similar Tutorials

View Content

I have designed a database for my institute. Here I have attached my design for better understanding. I am expecting your reviews who are professional for the database design. Thank You. Attached Files Database Design for Institute Registration.jpg 61.29KB 0 downloads

Behavior For Comments Form?

Similar Tutorials

View Content

I am trying to create an HTML Comments Form where people can send feedback or ask for help.

The main goal is to reduce/eliminate spam since my e-mail will be hidden.

When a Customer fills out the Form and clicks "E-mail Comments", what behavior would you expect to happen next?

1.) Do I load the Comments Form again?

2.) Display a message?

3.) Redirect somewhere?

4.) Other?

Debbie