How blog comments are maintained in database

Question

0.00/5 (No votes)

See more:

Hello Friends

I am developing one site where users can post thier comments. I wanted to know how to save these comments in database.

I was thinking to add one column dynamically into database table for each user entering comment using ALTER command and then to display the user comments, get the row from the database table and then display each column sequentially.

Is this a proper approach to achieve what I wanted to do?

Any guidence will be a great help to me.

Posted 3-Nov-10 4:05am

makwce

Add a Solution

2 solutions

Solution 2

Hi Nishant
Thanks for your reply but it didnt answer my question, how to save all the comments entered for any specific blog post.
The blog post contents are saved in the database table "blogs" with blogPostId as the primary key. But I am struggling to know how and where to save the comments entered by user for this specific blog post.

Any help on this will be appreciated.

Posted 3-Nov-10 19:04pm

makwce

Comments

tbprakash 4-Aug-17 9:02am

hi makwce,

I know it's so late but this may help visitors in the future. What Nishant meant when he said "create another table" is that you can maintain a separate table for comments with a column 'blogpost' which links to 'blogPostId' in your blogs table using foreign key.

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Nish Nishant · Accepted Answer · 2010-11-03T04:07:00

Solution 1

Why bother doing all that? Why not just have a Comments table with these columns: userId, blogPostId, date-time?

Posted 3-Nov-10 4:07am

Nish Nishant