如何在PHP中添加添加好友/解除好友功能? [英] How to make an add friend/defriend function in PHP?

问题描述

我创建了一个网站，人们可以在其中创建个人资料.但是我试图弄清楚如何开始创建添加朋友"按钮，以便用户可以拥有朋友.

I have created a site where people can create a profile. But I am trying to figure out how to start on making an add friend button so users can have friends.

在我的用户表中，我有user_id，first_name，last_name，email等.

In my user table, i have user_id, first_name, last_name, email, etc.

我应该以某种方式在朋友表中关联用户的user_id和朋友吗?

Should I somehow relate the user_id of the user and the friend in a friend table?

我是编程的新手，所以这些东西对我来说仍然是新的.谢谢！

I am a novice to programming, so these things are still new to me. Thanks!

推荐答案

好吧，让我们尝试保持简单. 本质上，您正在尝试找到一种将两个用户连接在一起的方法.

Well, let's try to keep this simple. You're trying, essentially, to find a way to connect two users together.

由于我试图使事情保持简单，并且绝对不暗示这是最好的方法，因此，我认为实现此目的的最简单方法是创建一个新表(users_friends)，其中包含以下字段:(user_id)和(friend_id).

Since I'm trying to keep things simple, and definitely not implying that this is the best way of doing it, I think the easiest way to go about doing this is to create a new table (users_friends) with the following fields: (user_id) and (friend_id).

好吧，假设我的user_id是5. 您的user_id为10.

Well, so let's say my user_id is 5. Your user_id is 10.

我想将您添加为我的朋友，因此，我将使用以下值向该新创建的表中添加一个条目: user_id = 5，friend_id = 10.

I want to add you as my friend, therefore I'd add an entry to that newly created table with the following values: user_id = 5, friend_id = 10.

因此，假设您想显示我所有的朋友，则可以运行以下查询:

So, let's say you want to display all of my friends, you could run a query such as:

SELECT * FROM `users` WHERE `user_id` IN ( SELECT `friend_id` FROM `users_friends` WHERE `user_id` = '5' );

果然，删除朋友很容易，您所要做的就是从新创建的表中删除条目...

Sure enough, removing a friend is easy, all you have to do is delete the entry from the newly created table ...

DELETE FROM `users_friends` WHERE `user_id` = '5' AND `friend_id` = '10';

po，你突然不再是我的朋友了；)

And poof, you're suddenly not my friend anymore ;)

是的，这些是基础. 在尝试一种可以为您带来更大灵活性的解决方案之前，我会先尝试该解决方案.

So yeah, these are the basics. I'd try this solution before moving on to a solution which will allow you more flexibility.

这篇关于如何在PHP中添加添加好友/解除好友功能?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！