CODEWITHSUNDEEP
phpmysqlcodeigniter
user2081972
user2081972

Reputation:

How to assign comment id?

I am making comment system and now I want to insert comments to database and I am confusing that on what basis to assign specific comment_id. Suppose we have multiple dives of images with comment system.if someone comment on image then how can we assign a specific comment id on that specific image.and if other user comment on same image then how can he found that image comment_id so the comment save in right direction. we have many images and comment system for that image. My english is bad may be you understand what i want to say.

Upvotes: 1

Views: 117

Answers (1)

James
James

Reputation: 2033

You need to create a number of different tables in the database

table: comments

|comment_id | userID | name | comment | (for example)
  1         50     James  test 
  2         50     James  test 
  3         50     James  test

table: images

|image_id | link |
  1      example.com/images/image1.png
  2      example.com/images/image2.png
  3      example.com/images/image3.png

table: comments_on_images (to make the table's purpose clear)

|id | comment_id | image_id
  1        1          2
  2        2          2
  3        3          1

Using this method you can assosciate any number of comments to any images. You have to query the database using JOINS to get all the information you need.

Upvotes: 1

Related Questions