建一个关联表.table friend_link host_id,friend_id, statushost_id为主人的ID, friend_id, 为对应host_id的朋友ID,status为状态(申请加入的朋友1,已经加入的朋友2,拒绝的朋友3,已经删除的朋友4)你的ID $host_id 1.您的朋友: select friend_id from friend_link where status = 2 and host_id = $host_id 2.邀请您的朋友 select host_id from friend_link where status = 1 and frinend_id = $host_id3.您邀请,但暂时未答复的朋友: select friend_id from friend_link where status = 1 and host_id = $host_id4.您邀请,但拒绝您的朋友: select host_id from friend_link where status = 3 and friend_id = $host_id5.您解除,但暂时未答复的朋友: select friend_id from friend_link where status = 4 and host_id = $host_id6.解除您,但您暂时未答复的朋友: select host_id from friend_link where status = 4 and friend_id = $host_id其实56根本就不存在答复不答复,人家解除你,或者你解除别人,不存在答复不答复的问题
不过要和逻辑!
1.您的朋友:
2.邀请您的朋友:
3.您邀请,但暂时未答复的朋友:
4.您邀请,但拒绝您的朋友:
5.您解除,但暂时未答复的朋友:
6.解除您,但您暂时未答复的朋友:
比较复杂!呵呵!
host_id,friend_id, statushost_id为主人的ID, friend_id, 为对应host_id的朋友ID,status为状态(申请加入的朋友1,已经加入的朋友2,拒绝的朋友3,已经删除的朋友4)你的ID $host_id
1.您的朋友: select friend_id from friend_link where status = 2 and host_id = $host_id
2.邀请您的朋友 select host_id from friend_link where status = 1 and frinend_id = $host_id3.您邀请,但暂时未答复的朋友: select friend_id from friend_link where status = 1 and host_id = $host_id4.您邀请,但拒绝您的朋友:
select host_id from friend_link where status = 3 and friend_id = $host_id5.您解除,但暂时未答复的朋友:
select friend_id from friend_link where status = 4 and host_id = $host_id6.解除您,但您暂时未答复的朋友:
select host_id from friend_link where status = 4 and friend_id = $host_id其实56根本就不存在答复不答复,人家解除你,或者你解除别人,不存在答复不答复的问题
那个。如果加上类似于朋友圈的那样的功能呢?
可以通过对方的好友来发展自己的好友。
是不是更复杂了呢?。。
怎么实现
复杂的就水到渠成了