Home  >  Article  >  Backend Development  >  PHP example-php implements comment reply and delete function

PHP example-php implements comment reply and delete function

微波
微波Original
2017-06-28 13:13:083294browse

This article mainly introduces the comment reply in php in detail. Delete function has a certain reference value. Interested friends can refer to

Simple comment reply Delete function, the specific content is as follows

1. Database

Create two tables, one is the pinglun table; the other is the huifu table

The effect is as follows:

The code is as follows:

1. Main page main.php

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>无标题文档</title>
 
 
 
<h1>朋友圈</h1>
<p>内容:</p>
<p>今天很嗨</p>
<p><img src="../picture/timg.jpg" width="300" height="200"></p><br>
<form action="mainchuli.php" method="post">
 
<input type="text" hidden="hidden" value="zhangsan" name="zhangsan"> <!--因为没有权限,这里给了一个默认值-->
 
<textarea name="content"></textarea><input type="submit" value="评论"><!--评论显示的地方--><!--单击评论提交内容进处理页面-->
</form>
 
 
<!--?php
  require"DBDA.class.php"; //调用封装类注意修改数据库名
  $db = new DBDA();
  $sql ="select * from Pinglun";
  $arr = $db--->query($sql,1);
  foreach($arr as $v)
  {
    echo"
       <p style="color:blue">{$v[1]} {$v[3]}</p>
       <p style="color:blue">{$v[2]}</p>
       <form action="delchuli.php?id={$v[0]}" method="post"> //删除按钮
        <input type="submit" value="删除">
       </form>
       <form action="huifuchuli.php?id={$v[0]}" method="post"> //回复按钮
        <textarea name="Comment"></textarea><input type="submit" value="回复">
       </form>
       ";
       
      $dc = new DBDA(); 
      $sql1 ="select * from huifu where jieshouid ={$v[0]}"; //查询回复表中的id和传过去的id是不是一样的
          $arr1 = $dc->query($sql1,1);
      foreach($arr1 as $k)
      {
        echo "<p>{$k[2]} {$k[3]}</p>
           <p>{$k[4]}</p>
           ";
      }
         
  }
     
?>

2. Comment processing page pinglunchuli.php

<?php
$zhangsan = $_POST["zhangsan"];
$content = $_POST["content"];
$time = date("Y-m-d H:i:s");
 
require "DBDA.class.php";
$db = new DBDA();
$sql = "insert into Pinglun values(&#39;&#39;,&#39;{$zhangsan}&#39;,&#39;{$content}&#39;,&#39;{$time}&#39;)";
$db->query($sql);
header("location:main.php");

3. Reply processing page huifuchuli.php

<!--?php
$id = $_GET["id"]; //将点击回复的评论id传过来
$Comment = $_POST["Comment"]; //回复文本域中的内容
$me = "me"; //这里是给定义了一个人
$Times = date("Y-m-d H:i:s");
 
require "DBDA.class.php";
$db = new DBDA();
$sql = "insert into huifu values(&#39;&#39;,&#39;{$id}&#39;, &#39;{$me}&#39;,&#39;{$Times}&#39;,&#39;{$Comment}&#39;)";
$db--->query($sql);
header("location:main.php");

4. Delete processing page delchuli.php

<?php
$id = $_GET["id"];
require "DBDA.class.php";
$db = new DBDA();
$sql = "delete from Pinglun where id=&#39;{$id}&#39;";
if($db->query($sql))
{
 
  header("location:main.php");
}
else
{
  echo "删除失败!";
}

The above is the detailed content of PHP example-php implements comment reply and delete function. For more information, please follow other related articles on the PHP Chinese website!

Statement:
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