PHP/mysql can I make a comment section to comment the record?

[yy885]

PHP/mysql can I make a comment section to comment the record?
So everytime the record loaded, on the comment section it will show the comment about this record.

My current idea is create a new table in mysql...so my question is how it should be? Can the ID(auto ID?) on this table link to the table for the records?

But one record can have many comments...so the comment will get its own unique id? if this is the case than I can just add/remove/delete the comments...but here it come another problem...will it be too risk? as I need to gave out the mysql login details to the page so visitors can be able to add records...

can someone please give me some suggestion?

Thank you for your time and sorry about the English.

[ScriptMan]

I am not real sure what you want to do.

Are you wanting more than one person to be able to add comments about a a 'something'? As an example say you an article and you want visitors to be able to post a comment about it?

Or are you wanting private comments that only you can see? To remind you of what the post is about?

[yy885]

Originally Posted by ScriptMan

As an example say you an article and you want visitors to be able to post a comment about it?

This is what I want, thanks for putting it into English

Ive the table for records and it have the id for each record.
I want to add a comment section so every visitor can leave their comment on it.

I am now trying to implement a new table to insert these comments. But how can I link them together? And how can I define that these comments will stay with that record?

e.g.
Visitor 1 wrote a comment on Record A.
Visitor 2 wrote a comment on Record A.
Visitor 3 wrote a comment on Record C.
Visitor 4 wrote a comment on Record B.
Visitor 5 wrote a comment on Record A.
Visitor 6 wrote a comment on Record B.


Comment section on Record A's page will show Visitor 1, Visitor 2 and Visitor 5 comments.
Comment section on Record B's page will show Visitor 4 and Visitor 6 comments.
Comment section on Record C's page will show Visitor 3 comment.

Thank you for your help.

[kontrol]

what you have to do is that you, in the php script that will insert the comments into the new table, create a column that will contain the id of the record the commenter is commenting on. it should not be unique and then in the form for the input, add a hidden field to hold the id of the record as its value. In this way, you will retrieve all comments on a record using IN your sql statement. example $select = "SELECT * FROM comments WHERE recordID IN ('$id')";

[ScriptMan]

What he said!

On the page where the initial posts appears you need to capture the post ID and use that to insert the comment into the new table along with the comment and any related information.

The table for the comments section may or may not contain all of the following:
comment ID, indexed, unique, auto increment
post ID, possible index
date
IP number of commenter
status (allows you to control visible or not)
comment (the text portion)
abuse reports ( a numeric value to determine visible or not IE: 0 or 1)
reported by (record the IP number of the person reporting abusive posts)

The table may contain other information. I just hit the more common basic items.

[yy885]

Will try to post the code here tomorrow to see what went wrong...

meanwhile a side question, if I finish the website, can you people have a look at it and give me some feedback to improve it? as this is the first time I use php+mysql to build a website.

If so, I should zip all the pages via 7-zip or just post all the codes?


thank you for your time.

[ScriptMan]

Anything you post in its entirety anywhere online may create some future security issues for you. It may never be a problem but it could be. Posting snippets or code where you have changed a few values that you fully understand is okay.

Why don't you start by telling us what problem you are experiencing.

[yy885]

Was busy in the past 2 weeks...anyway in these 2 weeks Ive figured out how to insert some more function that will work on my site. (e.g.img upload...searching...login...)

anyway, its time for me to come back into this feedback(comments) function.

Now, Ive another idea...

inside the user submit button, add this line
<input type="hidden" name="name" value="<?php echo $name ?>">

a new mysql table will include these fields

id(auto id), userid, email, comments and cmtName

cmtName is for inserting this $name above.
e.g. $cmtName = $_POST['name'];

So whenever these comments section load, it will have mysql query like

SELECT * FROM feedback WHERE cmtName = '$name'

and the php generate all comment which have the same $name...

Will the feedback work this way?

Thank you for your time.

[ScriptMan]

if $cmtName = $_POST['name']; is a a unique item in the DB it should. Do you not assign id numbers to the original post? One unique id number per name?

[yy885]

Just think of one thing...the cmtName can be edit...so its a no go and why I am so dump...I already assign the id(auto id) for this table...I should just use it...
.......................................

*facepalm* wasnt this is what you guys trying to tell me 2 weeks ago...anyway, its 3am now so I will try to this tomorrow

I used to be writing C+...but why I am so dump in php...

[yy885]

sorry for making another reply as I cannot edit the above post.

anyway, ive sorted this problem.

This query is working fine.
"SELECT * FROM comments WHERE recordID IN '$id'";

Thanks again for all of your help.