php实现加好友功能
思路:
1用户发送好友申请之后 把申请储存到申请数据表中,状态为 未验证
2 当用户登录时,查询申请表中是否有uid和被申请人id相同的,如果同意,更改状态,并把数据插入到对应的好友数据表否则,删除申请数据表中数据
3,当一方删除好友时,从被删除人中删除删除人的好友
4 创建分组名称字段,字段设定好值,让用户选择,或者让用户自定
5 当查询时候列出数据表信息
附:mysql数据表 共两个
#以上步骤是对数据库的操作,你可以<a><code class="php keyword">class="inner-link decor-unline"href="/search?word=实例化&fr=qb_search_exp&ie=gbk"target="_blank"rel="nofollow" data-word="2">实例化,#好友表<a><code class="php keyword">class="inner-link decor-unline"href="/search?word=mysql_query&fr=qb_search_exp&ie=gbk"target="_blank"rel="nofollow" data-word="0">mysql_query("CREATE TABLE `t_friend` ( `id` int(11) NOT NULL auto_increment COMMENT '自增id', `uid` int(11) NOT NULL COMMENT '用户id', `fid` int(11) NOT NULL COMMENT '好友uid,用,分割,可以有多个', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;#申请表CREATE TABLE `t_shenqing` ( `id` int(11) NOT NULL auto_increment COMMENT '自增id', `uid` int(11) NOT NULL COMMENT '被申请用户id userid', `sid` int(11) NOT NULL COMMENT '好友申请人id', `text` varchar(255) NOT NULL COMMENT '附言', PRIMARY KEY (`id`)) ENGINE=InnoDB DEFAULT CHARSET=utf8;"); |
每一次用户请求操作,就会对数据库进行一次查询或更新,
The difference between null and NULL in c language
Usage of null in java
What are character constants
Implementation method of vue online chat function
How to use php web page source code
How to use digital currency
Compare the similarities and differences between two columns of data in excel
vcruntime140.dll cannot be found and code execution cannot continue
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
