简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Backend Development > PHP Tutorial > body text

php兑现加好友功能

WBOY
Release： 2016-06-13 11:33:03
Original
1022 people have browsed it

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;
");


每一次用户请求操作,就会对数据库进行一次查询或更新,

1楼shooow前天 12:23
实现方法不错。
Related labels：
comment nbsp NOT null quot
source：php.cn
Previous article：[有关问题]微信公众平台开发模式的url如何填写 Next article：PHP 5.3.1 安装包 VC9 VC6 差别是什么
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Preserve font spacing for a line of text split into separate HTML elements I'm trying to recreate a common technique of splitting words into separate HTML elements s...
From 2023-09-10 18:37:01
0
1
301
How to make this automatically multiline How to make this automatically multiline I'm using HTML and CSS Here is my code (I modifie...
From 2023-08-18 00:10:50
0
1
329
Why is mine wrong in the console? if (time<8) { x="zao";}else{ x="good";}Which problem
From 2023-08-03 14:42:30
0
0
99
Is this the code for conn.php? 下面<?php     $name = $_POST['username'];    $pwd  = md5($_POST['password']);    $sql = &...
From 2023-06-08 18:46:23
0
1
143
After downloading COMPOSER and installing TP6, it always fails to install, as shown in the picture. What do you want? After downloading COMPOSER and installing TP6, it always fails to install, as shown in the...
From 2023-04-01 22:49:35
0
0
632
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！