PHP imitates QQ space to realize its functional examples
零下一度
Release： 2023-03-10 12:24:01
Original
3975 people have browsed it
This article mainly introduces the functions of imitating QQ space or circle of friends to publish updates, comment on updates, reply to comments, delete updates or comments (middle), friends in need can refer to the following
in the previous article The essay has already presented how to publish updates, so now let’s take a look at the remaining comment updates, reply comments, delete updates and comment functions. These functions are a bit confusing~~~
1. The idea is as follows:
(1) After you post a post, someone will comment on this post. After commenting, you will also reply to the comment; (comments here must be A separate table, and a separate table for replies)
(2) Delete updates: all updates, comments, and replies will be deleted; delete comments: only the comment will be deleted
2. Before writing the code, I still want to talk about the process:
(1) Post updates---comments---reply---again Reply
(2) To refine the above process, I first wrote it on paper and then uploaded it. The code words cannot express it clearly (note that the implementation of the functions I want is not exactly the same Ha)
## Third, let’s explain the code in chunks first, and finally attach the main page code completely (Including the previous article)
In the previous article, we have implemented the posting of updates and pop-up comment boxes, so now go down: Look at qqfriends separately, qqdongtai, qqpinglun, qqhuifu table, this is the initial state:
## First log in as user Li Si. From the qqfriends table in the database, we know that Li Si’s friends are zhangsan, and zhaoliu. Then the friend dynamics displayed in his space are as follows:
Compared with the previous article, in this article, I display who logged in in Chinese:
<?php
session_start();
$uid = "";
if(empty($_SESSION["uid"]))
{
header("location:login.php");
exit;
}
$uid = $_SESSION["uid"];
require "../DB.class.php";
$db = new DB();
$sql = "select name from qqusers where uid='{$uid}'";
$name = $db->strquery($sql);
echo "欢迎："."<span class='qid' yh='{$uid}'>{$name}</span>";
?>
Copy after login
Step One: Comment
1. Comment on Zhang San’s updates. After clicking “OK”, it will be the second picture~
2. And write the content of the comment into the database
<p id="dqhf">
<!--取一次回复-->
<?php
$sql = "select * from qqhuifu where cid in (select cid from qqpinglun)";
$arr = $db->query($sql);
foreach($arr as $a)
{
$sql = "select * from qqpinglun where cid='{$a[1]}'";
$arr2 = $db->query($sql);
foreach($arr2 as $n)
{
//取评论动态的姓名
$sql = "select name from qqusers where uid='{$a[2]}'";
$name = $db->strquery($sql);
//若果是登录者评论则显示“我”
if($a[2]==$uid)
{
$name ="我";
}
//获取被回复评论的姓名
$sql = "select name from qqusers where uid=(select uid from qqpinglun where cid='{$a[1]}')";
$bpl = $db->strquery($sql);
echo "<p class='a'><span class='xm'>{$name}</span>回复<span class='xm'>{$bpl}</span>的评论:{$n[3]}<p>
<p class='b'>{$a[3]}</p>
<p class='c'>回复时间：{$a[4]}</p>
<p class='d'><button class='btn btn-primary hf' ids ='{$a[0]}'>回复
</button><span><a href='schf-cl.php?code={$a[0]}'>删除回复</a></span></p>";
}
}
?>
</p>
Copy after login
The reply content has been displayed:
Step 3: Delete
1. Delete updates: (including comments and replies)
scdt-cl.php
<?php
$code = $_GET["code"];
require "../DB.class.php";
$db = new DB();
$sql = "delete from qqdongtai where dtid='{$code}'";
$db->query($sql,0);
$sql2 = "delete from qqpinglun where dtid='{$code}'";
$db->query($sql2,0);
$sql3 = "delete from qqhuifu where cid=(select cid from qqpinglun where dtid='{$code}')";
$db->query($sql3,0);
header("location:main.php");
?>
Copy after login
2. Delete comment: (including reply)
scpl-cl.php
<?php
$code = $_GET["code"];
require "../DB.class.php";
$db = new DB();
$sql2 = "delete from qqpinglun where cid='{$code}'";
$db->query($sql2,0);
$sql3 = "delete from qqhuifu where cid='{$code}'";
$db->query($sql3,0);
header("location:main.php");
?>
Copy after login
Copy after login
3. Delete reply: (Only yourself)
schf-cl.php
<?php
$code = $_GET["code"];
require "../DB.class.php";
$db = new DB();
$sql2 = "delete from qqpinglun where cid='{$code}'";
$db->query($sql2,0);
$sql3 = "delete from qqhuifu where cid='{$code}'";
$db->query($sql3,0);
header("location:main.php");
?>
Copy after login
Copy after login
Regarding deletion, I won’t try it one by one~~~Just pay attention to the inclusion relationship
query($sql);
foreach($arr as $v)
{
$sql = "select * from qqdongtai where dtid='{$v[1]}'";
$arr2 = $db->query($sql);
foreach($arr2 as $m)
{
//取发动态的姓名
$sql = "select name from qqusers where uid='{$v[2]}'";
$name = $db->strquery($sql);
//若果是登录者评论则显示“我”
if($v[2]==$uid)
{
$name ="我";
}
//获取被评论者的姓名
$sql = "select name from qqusers where uid=(select uid from qqdongtai where dtid='{$v[1]}')";
$bpl = $db->strquery($sql);
echo "
Up to this point, dynamic publishing, dynamic comments, dynamic replies, and dynamic deletions have all been written, but There is a question that has not yet been resolved, which is the question of replies. Please look at the diagram below:
That is to say, part of the reply table is the reply comments, and the remaining part is the reply reply (a bit convoluted) If you want to see it, continue to pay attention (below) To be continued ~~~
Let’s first summarize the problems encountered:
(1) Why can’t the button output by ajax add a click event?
Because ajax is asynchronous ajax, it must be followed immediately.
(2) Why can’t I get the value of button------this
(3) When to use ajax in a php page? When to use php?
In this example, I use ajax to write data into the database; I use php to read content from the database. (In the previous article, the dynamics were read using ajax. In this article, both methods are available. Please see the entire code for details)
(4) Finally, clear logic is crucial, especially Associations between tables.
The above is the detailed content of PHP imitates QQ space to realize its functional examples. For more information, please follow other related articles on the PHP Chinese 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
## First log in as user Li Si. From the qqfriends table in the database, we know that Li Si’s friends are zhangsan, and zhaoliu. Then the friend dynamics displayed in his space are as follows: 
Compared with the previous article, in this article, I display who logged in in Chinese: 
2. And write the content of the comment into the database 
3. Read the comment content: 
3. Read the reply content: 
Step 3: Delete
![[Web front-end] Node.js quick start](https://img.php.cn/upload/course/000/000/067/662b5d34ba7c0227.png)
