Full code display of PHP development message board

List page:

<?php
session_start();
header("content-type:text/html;charset=utf-8");
//连接数据库
$link = mysqli_connect("localhost","root","root","message");
mysqli_set_charset($link,"utf8");
if (!$link) {
 die("连接失败: " . mysqli_connect_error());
}
//连接数据库
$SQL = "SELECT * FROM DETAILS";//设置查询指令
$result=mysqli_query($link,$sql);//执行查询
?>
<!DOCTYPE html>
<html lang="zh-CN">
<head>
    <meta  charset="utf-8" />
    <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
    <meta name="format-detection" content="telephone=no" />
    <title>留言板</title>
    <style>
 .top{
            width:410px
 }
        .fl{
            float:left
 }
        .klytd {width:100px;
 text-align:left
 }
    </style>
</head>
<body>
<div style="margin:0px auto;" class="top">
 <!--头部图片-->
 <div class="head">
        <img style="width:400px" src="https://img.php.cn/upload/course/000/000/007/5816db62346b9319.jpg">
    </div>
 <!--中间内容-->
 <div class="body">
        <div style="width:400px;" class="fl font">
            <div style="margin:0px auto;" class="keleyitable"><h2>留言列表</h2>
                <form method="post" action="list.php">
 <?php while($row=mysqli_fetch_assoc($result)):?>
 <table>
   <tr><td class="klytd">留言时间：</td><td class="hvttd"><?php echo $row['time'];?></td></tr>
     <p>
     <button type="button" value="回复">
     <a href="reply_list.php?id=<?php echo $row['id'];?>">回复</a>
     </button>
     </p>
    <tr><td class="klytd">留言人：</td><td class ="hvttd"><?php echo $row['name'];?></td></tr>
    <tr><td class="klytd">标题：</td><td class ="hvttd"><?php echo $row['title'];?></td></tr>
    <tr><td class="klytd">内容：</td><td class ="hvttd"><?php echo $row['content'];?></td></tr>
     <tr><td class="klytd">回复：</td><td class="hvttd"><?php echo $row['reply'];?></td></tr>
 </table>
  </form>
  <br/>
  <hr>
 <?php endwhile;?>
 </div>
       <div>
         <button type="button" value="发表留言"><a href="form.html">发表留言</a></button>
       </div>
 </div>
 <!--底部链接与内容-->
 <div>
        </div>
    </div>
</body>
</html>

Message page:

<?php
session_start();
header("content-type:text/html;charset=utf-8");
//连接数据库
$link = mysqli_connect("localhost","root","root","message");
mysqli_set_charset($link,"utf8");
if (!$link) {
   die("连接失败: " . mysqli_connect_error());
}
$name = isset($_POST['name'])?$_POST['name']:"";
$title = isset($_POST['title'])?$_POST['title']:"";
$content = isset($_POST['content'])?$_POST['content']:"";
$time = date("Y-m-d H:i:s");


$sql ="insert into details(name,title,content,time) values('$name','$title','$content','$time')";
$rel = mysqli_query($link,$sql);

if($rel){
   echo"留言成功"."<br/><br/>";
   echo"<a href='list.php'>跳转至留言列表页面</a>";
}else{
   echo"留言失败"."<br/><br/>";
   echo"<a href='form.html'>跳转至留言编辑页面</a>";
}
?>
<html>
<head>
   <meta charset="utf-8" />
   <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
   <meta name="format-detection" content="telephone=no" />
   <title>留言板</title>
   <style>
.w410{
           width:410px
}
       .mr_auto{
           margin:0 auto;
}
       .w400{
           width:400px
}
   </style>
</head>
<body>
<div  class="w410 mr_auto">
<!--头部图片-->
<div>
       <img src="https://img.php.cn/upload/course/000/000/007/5816db62346b9319.jpg">
   </div>
   <div style="padding-top: 30px;" class="mr_auto w400">
       <form method="post" name="form1" id="form1" action="message.php">
标题：<input type="text" name="title"><br/><br/>
内容：<textarea style="width:350px;height:200px;" name="content"></textarea><br/><br/>
作者：<input type="text" name="name"><br/><br/>
           <a href=""><input type="submit" style="margin-left:350px" value="提交"></a>
       </form>
   </div>
   </div>
</body>
</html>

Reply page:

<?php
session_start();
header("content-type:text/html;charset=utf-8");
//连接数据库
$link = mysqli_connect("localhost","root","root","message");
mysqli_set_charset($link,"utf8");
if (!$link) {
   die("连接失败: " . mysqli_connect_error());
}
$id = isset($_GET['id'])?$_GET['id']:"";
$reply = isset($_POST['reply'])?$_POST['reply']:"";

$sql ="update details set reply='$reply' where id=".$id;

$rel = mysqli_query($link,$sql);

if($rel){
   echo"回复成功"."<br/><br/>";
   echo"<a href='list.php'>跳转至留言列表页面</a>";
}else{
   echo"回复失败"."<br/><br/>";
   echo"<a href='reply.html'>跳转至回复编辑页面</a>";
}
?>
<!DOCTYPE html>
<html>
<head>
   <meta charset="UTF-8">
   <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no">
   <meta name="format-detection" content="telephone=no" />
   <title>回复页面</title>
   <style>
.w410{
           width: 410px;
}
       .fon_f{
           font-family: 微软雅黑;
}
       .pt{
           padding-top: 80px;
}

   </style>
</head>

<body>
<div style="margin: 0 auto;"  class="fon_f w410">
<div>
<h1 style= "text-align:center;">留言窗口</h1>
</div>
<div style="margin: 0 auto;" class="pt lh">
   <form name="form1" method="post" action="reply.php?id=<?php echo $_GET['id']?>">
回复:<textarea style="width: 380px;height: 200px;" name="reply"></textarea><br/><br/>
       <input type="submit" value="确认回复">
   </form>
</div>
</div>
</body>
</html>

Continuing Learning

new file

<?php session_start(); header("content-type:text/html;charset=utf-8"); //连接数据库 $link = mysqli_connect("localhost","root","root","message"); mysqli_set_charset($link,"utf8"); if (!$link) { die("连接失败: " . mysqli_connect_error()); } $id = isset($_GET['id'])?$_GET['id']:""; $reply = isset($_POST['reply'])?$_POST['reply']:""; $sql ="update details set reply='$reply' where id=".$id; $rel = mysqli_query($link,$sql); if($rel){ echo"回复成功"."<br/><br/>"; echo"<a href='list.php'>跳转至留言列表页面</a>"; }else{ echo"回复失败"."<br/><br/>"; echo"<a href='reply.html'>跳转至回复编辑页面</a>"; } ?> <!DOCTYPE html> <html lang="en"> <head> <meta charset="UTF-8"> <meta name="viewport" content="width=device-width, initial-scale=1.0, minimum-scale=1.0, maximum-scale=1.0, user-scalable=no"> <meta name="format-detection" content="telephone=no" /> <title>回复页面</title> <style> .w410{ width: 410px; } .fon_f{ font-family: 微软雅黑; } .pt{ padding-top: 80px; } </style> </head> <body> <div style="margin: 0 auto;" class="fon_f w410"> <div> <h1 style= "text-align:center;">留言窗口</h1> </div> <div style="margin: 0 auto;" class="pt lh"> <form name="form1" method="post" action="reply.php?id=<?php echo $_GET['id']?>"> 回复:<textarea style="width: 380px;height: 200px;" name="reply"></textarea><br/><br/> <input type="submit" value="确认回复"> </form> </div> </div> </body> </html>

submit Reset Code

Automatic operation

Full code display of PHP development message board

ElementaryImperial CMS enterprise imitation website tutorial

ElementaryNewbies with zero foundation in WordPress build personal blogs and corporate websites

ElementaryUltimate CMS zero-based website building instruction video

ElementaryFront-end project-Shangyou [HTML/CSS/JS technology comprehensive practice]

IntermediateVue3.0 from 0 to build a universal backend management system project practice

ElementaryZero-based front-end course [Vue advanced learning and practical application]

ElementaryWEB front-end tutorial [HTML5+CSS3+JS]

ElementaryQuick introduction to apipost

IntermediateVue3+TypeScript practical tutorial-enterprise-level project practice

ElementaryLet's briefly talk about starting a business in PHP

IntermediateVUE e-commerce project (front-end & back-end dual project actual combat)

ElementaryApipost practical application [api, interface, automated testing, mock]