How to implement the friend adding function in php

How to implement the friend adding function in php: 1. Store the friend application in the application data table; 2. Query the application form; 3. Delete friends; 4. Create a group name field; 5. Query the parallel Just export the data table information.

The operating environment of this article: Windows 7 system, PHP version 7.1, DELL G3 computer

How to implement the friend adding function in php?

php implements the friend-adding function

Idea:

1. After the user sends a friend application, the application is stored in the application data table. The status is Unverified

2. When the user logs in, check whether there is a uid in the application form that is the same as the respondent id. If it is agreed, change the status and insert the data into the corresponding friend data table. Otherwise, Delete the data in the application data table

3. When one party deletes a friend, the deleted person’s friends are deleted from the deleted person

4. Create a group name field and set the value in the field. The user chooses, or lets the user customize

5. List the data table information when querying

Attachment: There are two mysql data tables

#以上步骤是对数据库的操作,你可以<a class = "inner-link decor-unline" href= "/search?word=实例化&fr=qb_search_exp&ie=gbk" target= "_blank" rel= "nofollow"  data-word= "2" >实例化</a>,
#好友表
<a  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</a>("CREATE TABLE `t_friend` (
   `id` int(11) NOT NULL auto_increment COMMENT  &#39;自增id&#39; ,
   `uid` int(11) NOT NULL COMMENT  &#39;用户id&#39; ,
   `fid` int(11) NOT NULL COMMENT  &#39;好友uid,用,分割,可以有多个&#39; ,
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
#申请表
CREATE TABLE `t_shenqing` (
   `id` int(11) NOT NULL auto_increment COMMENT  &#39;自增id&#39; ,
   `uid` int(11) NOT NULL COMMENT  &#39;被申请用户id userid&#39; ,
   `sid` int(11) NOT NULL COMMENT  &#39;好友申请人id&#39; ,
   `text` varchar(255) NOT NULL COMMENT  &#39;附言&#39; ,
   PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
");

Every time the user requests an operation , a query or update will be performed on the database.

Recommended learning: "PHP Video Tutorial"

The above is the detailed content of How to implement the friend adding function in php. For more information, please follow other related articles on the PHP Chinese website!