用于喜欢/不喜欢功能的PHP / SQL逻辑[关闭]

Question

I'm looking to code a [ like | dislike ] feature utilizing PHP/SQL in the best and most efficient way possible.

I currently have two tables: users & content

• How should I store a user's likes and dislikes?
• How should I store the number of likes a particular content item has?

I'm looking for the best logic possible so I'm not overloading my site with inefficient queries.

Answer 1

sample table

posts
----
id
content
user


users
----
id
username

user_likes
----
id
user
post_id