Comments on each page??

tearsofthesun · 08-19-2009, 09:45 AM

Hi, can someone point me in the right direction. i have searched all over the net and there isn't one single one that i am looking for.

I wanted to have a comment box on each of my pages so users can comment that page. i have tons of page in my website that contains urls that end with id=45 and etc.

ex: if user comment pages id=45

i don't want the comments on page id=45 to appear on id=46

thanks!

Tanax · 08-19-2009, 10:09 AM

In your table for the comments, use a row for pageId that stores the ID of the page the comment is associated with. Then on the page, you just fetch the comments with pageId = $_GET['id']. Remember to secure that for sql injections.

tearsofthesun · 08-19-2009, 10:48 AM

Here's my code for it, but i don't know where to place that ID_ code you gave me.

PHP Code:


			
<?php

//Connect to database

include ('connect1.php');

$queryget = mysql_query("SELECT* FROM comments");

while ($row = mysql_fetch_assoc($queryget))

{

//get row data and store in var's

$id = $row['id'];

$name = $row['name'];

$email = $row['email'];

$message = $row['message'];

$date = $row['date'];

$time = $row['time'];

 

 //show data to user

echo"<table><tr><td>

Posted by: <b>$name ($email) on $date</b>

</td></tr><tr>



<td>".strip_tags($message)."</td></tr></table>";

}



echo "<hr>";



if ($_POST['submit'])

{

$name = $_POST['name'];

$email = $_POST['email'];

$message = $_POST['message'];

$date = date ("m-d-Y");

$time = date ("H:i:s");



if($name&&$message)

{

$querypost = mysql_query ("INSERT INTO comments VALUES ('','$name','$email','$message','$date','$time')");

echo"Please wait..... <meta http-equiv='refresh' content='1;url=results3.php?id=$id'>";

}

else

echo "Please fill out all fields.";

}



echo "<form action='results3.php?id=$id' method='POST'><table width='100%'>

<tr><td width='5%' valign='top'>Name:</td>

<td><input type='text' name='name' maxlength='25'></td></tr>



<tr><td valign='top'>Email:</td><td><input type='text' name='name' maxlength='25'></td></tr>



<tr><td valign='top'>Message:</td><td>

<textarea cols='20' rows='2' name='message' maxlength='250'></textarea>

<p>

<input type='submit' name='submit' value='Post'>

</td>

</tr>

</table>

</form>";

?>

jasonberresford · 08-19-2009, 12:08 PM

Here's my quick edit:

Code:

<?php
//Connect to database
include ('connect1.php');
$pageid = $_GET['id'];
$queryget = mysql_query("SELECT* FROM comments WHERE pageid = '$pageid'");
while ($row = mysql_fetch_assoc($queryget))
{
//get row data and store in var's
$id = $row['id'];
$name = $row['name'];
$email = $row['email'];
$message = $row['message'];
$date = $row['date'];
$time = $row['time'];
 
 //show data to user
echo"<table><tr><td>
Posted by: <b>$name ($email) on $date</b>
</td></tr><tr>

<td>".strip_tags($message)."</td></tr></table>";
}

echo "<hr>";

if ($_POST['submit'])
{

$name = $_POST['name'];
$email = $_POST['email'];
$message = $_POST['message'];
$date = date ("m-d-Y");
$time = date ("H:i:s");

if($name&&$message)
{
$querypost = mysql_query ("INSERT INTO comments VALUES ('','$name','$email','$message','$date','$time','$pageid')");
echo"Please wait..... <meta http-equiv='refresh' content='1;url=results3.php?id=$id'>";
}
else
echo "Please fill out all fields.";
}

echo "<form action='results3.php?id=$id' method='POST'><table width='100%'>
<tr><td width='5%' valign='top'>Name:</td>
<td><input type='text' name='name' maxlength='25'></td></tr>

<tr><td valign='top'>Email:</td><td><input type='text' name='name' maxlength='25'></td></tr>

<tr><td valign='top'>Message:</td><td>
<textarea cols='20' rows='2' name='message' maxlength='250'></textarea>
<p>
<input type='submit' name='submit' value='Post'>
</td>
</tr>
</table>
</form>";
?>

Something like that .. Grab the id at the start, when you do an insert insert with the ID, and when you do the select for the page grab the ID .. nothing to it :)

tearsofthesun · 08-20-2009, 02:09 PM

Still not working :(

Here is an example:
http://www.starcraftx.com/results.ph...ame=gravedigga

I type in a comment for that user,

but the same comment i type in for that user show's up in every other page...

http://www.starcraftx.com/results.php?setname=DoS.E
http://www.starcraftx.com/results.php?setname=Im.Back

PHP Code:


			
<?php

//Connect to database

include ('connect1.php');

$id = $_GET['id'];

$queryget = mysql_query("SELECT * FROM comments");

while ($row = mysql_fetch_assoc($queryget))

{

//get row data and store in var's

$id = $row['id'];

$name = $row['name'];

$email = $row['email'];

$message = $row['message'];

$date = $row['date'];

$time = $row['time'];

 

 //show data to user

echo"

<table width='100%'><tr>



<td background='images/anynav3.gif'>".$name." <br> ".$message."</td></tr></table>";

}



if ($_POST['submit'])

{



$name = $_POST['name'];

$email = $_POST['email'];

$message = $_POST['message'];



if($name&&$message)

{

$querypost = mysql_query ("INSERT INTO comments VALUES ('','$name','$email','$message','$date','$time')");

echo"Please wait..... <meta http-equiv='refresh' content='1;url=results.php?setname=$setname'>";

}

else

echo "Please fill out all fields.";

}



echo "

<form action='results.php?setname=$setname' method='POST'><table width='100%'>



<input type='hidden' readonly='readonly' name='name' size='20' value='$_SESSION[user]'>



<textarea cols='20' rows='2' name='message' maxlength='250'>

</textarea>



<input type='submit' name='submit' value='Post'>

</td>

</tr>

</table>

</form>";

?>

jasonberresford · 08-20-2009, 02:13 PM

Yep your missing one thing:

$id = $_GET['id'];
$queryget = mysql_query("SELECT * FROM comments");

CHANGE TO:

$id = $_GET['id'];
$queryget = mysql_query("SELECT * FROM comments WHERE id = '$id'");

That will make sure it only selects that comments ...

Not every comment which loops through and just outputs the last on all pages.

jasonberresford · 08-20-2009, 02:21 PM

Yeah looks like your missing a few other things as well.

When you insert the comment you need to insert it with an ID of the page .. So that you can call them all later on.

Using Int is normally better then using Text or Varchar matching. (Faster)

The code I typed originally had some other changes .. (on the insert statement)

tearsofthesun · 08-20-2009, 02:46 PM

well, when i entered

PHP Code:


			
$id = $_GET['id'];

$queryget = mysql_query("SELECT * FROM comments WHERE id = '$id'");

the comments now doesn't display. but if i take out the

PHP Code:


			
id = '$id'

it does. kinda weird and i've been working on this since yesterday lol :(

jasonberresford · 08-20-2009, 02:59 PM

Well yes ... id needs to be passed in the url for it to work, and needs to be stored in the database when you create the comment.

Basically you need to tie everything together,

When the comment is added you need to insert an identifier of the page .. Normally I just us an ID # for speed..

Then when you select the page .. you select the comment records with that same ID number...

Seeing as you are already passing: setname=DoS.E

It might be easier to change things slightly, when adding the comment add in the setname as the unique identifier in the comments db .. then when you select ... select by setname ..

Clear as mud? :)

The main reason i'm trying to push to ID is because if the site gets larger and the DB for comments gets large you want to have an INT field not TEXT/VAR for the joinning.

tearsofthesun · 08-30-2009, 08:54 AM

Well i sort of got this script to work, alright here is the problem.

When i go to MY ADMIN PHP and manually insert some dummie data's it works. but when i go to a user's page and type in some comments, it doesn't display.

you can try it here,
http://www.starcraftx.com/results.php?id=103

anyone seem to know whats wrong??? thanks!

PHP Code:


			
<?php

//Connect to database

include ('connect.php');

$id = $_GET['id'];

$queryget = mysql_query("SELECT * FROM members WHERE id = '" . $id . "' ") or die (mysql_error());

$row = mysql_fetch_array($queryget);

{

//get row data and store in var's

$id = $row['id'];

$name = $row['name'];

$message = $row['message'];



//show data to user

echo"

<table><tr>



<td>".$message." <br> ".$setname."</td></tr></table>";

}



if ($_POST['submit'])

{

$name = $_POST['name'];

$message = $_POST['message'];



if($name&&$message)

{

$querypost = mysql_query ("INSERT INTO members VALUES ('','$name','$message')");

echo"Please wait..... <meta http-equiv='refresh' content='1;url=results.php?id=$id'>";

}

else

echo "Please fill out all fields.";

}



echo "

<form action='results.php?id=$id' method='POST'><table width='100%'>

<tr><td width='5%' valign='top'>Name:</td>

<td><input type='text' name='name' maxlength='25'></td></tr>



<tr><td valign='top'>Message:</td><td>

<textarea cols='20' rows='2' name='message' maxlength='250'></textarea>

<p>

<input type='submit' name='submit' value='Post'>

</td>

</tr>

</table>

</form>";

?>

TheOnly92 · 08-30-2009, 11:25 AM

Your insert query doesn't insert the id of the page together, that's why you can't link the specific comment to the page. Try something like

Code:

INSERT INTO members VALUES ($id, '$name', '$message')

I wouldn't do this if I were you, it's better to create a new column to specify which page the comment belongs to like page_id or something like that.