当前位置：首页 > news >正文

HTML+CSS+PHP实现网页留言板功能（需要创建数据库）

news 来源：原创 2024/9/29 9:32:43

话说前头，我这方面很菜滴。这是我网页作业的一部分。

1.body部分效果展示（不包括footer）

2、代码

2.1 leaving.php（看到的网页）

<!DOCTYPE html>  
<html lang="en">  
<head>  <meta charset="UTF-8">  <meta name="viewport" content="width=device-width, initial-scale=1.0">  <title>留言板</title>  <link rel="stylesheet" href="leaving_styles.css">  
</head>  
<body>  <header >  <h1>…………</h1>  </header> <div class="le"><h2>留言板</h2>  <div class="in"><form action="post_message.php" method="post">  <textarea name="message" rows="5"  placeholder="输入你的留言..."></textarea> <br><input class="in" type="submit" value="提交">  </form> </div><table> <tr><td><div id="message-container" >  <?php include 'display_messages.php'; ?>  </div></td></tr></table></div><footer>  <p>留言板 &copy; 2024 草海桐</p>  </footer>  
</body>  
</html>

2.2 leaving_styles.css

body {  font-family: Arial, sans-serif;  margin: 0;  padding: 0; justify-content: center;  align-items: center;  background-color: rgba(224, 255, 255, 1);
}  header {  width: 100%;height: 200px;background-image: url('.jpg');  background-size: cover; background-position: center; text-align: center;margin: auto;
} h1{}h2{display: flex;justify-content: center; padding: 0;margin: 0;
}/*.le{margin: 0; padding: 20px; text-align: center;align-items: center;background-color: rgba(224, 255, 255, 1);    
}*/
.le{width: auto;top: 200px;bottom: 0;left: 0;text-align: center;align-items: center;margin: 0;padding: 10px;background-size:cover;position: absolute;right: 0;
}   
.in{justify-content: center;
}
textarea{width: 65%;
}form{text-align: center;padding: 10px; align-items: center;
}
table{border-collapse: collapse; align-items: center;text-align: center;bottom: 0;
} 
tr{align-items: center;text-align: center;
}
td{text-align:center ;align-items: center;
}
#message-container{  text-align: center;align-items: center;max-height: 350px;overflow-y: auto; padding: 0;border: 2px solid black; background-color: rgba(255, 255, 255, 1);  
}@media screen and (max-width: 400px) {  #message-container{  align-items: center;text-align: center;max-height: 220px;width: auto;overflow-y: auto; padding: 0;border: 2px solid black; background-color: rgba(255, 255, 255, 1);  }
}footer {  background-color: #333;  color: #fff;  text-align: center;  position: fixed;  left: 0;  bottom: 0;  width: 100%;  
}

2.3 post_massage.php

<?php  
$servername = "localhost"; 
$username = "";//用户名
$password = "";//密码
$dbname = "";//数据库名称$conn = new mysqli($servername, $username, $password, $dbname);  if ($conn->connect_error) {  die("连接失败: " . $conn->connect_error);  
}  $message = $conn->real_escape_string($_POST['message']);  $sql = "INSERT INTO messages (content) VALUES ('$message')";  
if ($conn->query($sql) === TRUE) {  echo "留言成功添加！";  header("Location: leaving.php");exit();  
} else {  echo "Error: " . $sql . "<br>" . $conn->error;  
}  $conn->close();  
?>

2.4 display_massages.php

<?php  
$servername = "localhost";  
$username = "";//用户名  
$password = "";//密码
$dbname = "";//数据库名称$conn = new mysqli($servername, $username, $password, $dbname);  if ($conn->connect_error) {  die("连接失败: " . $conn->connect_error);  
}  $sql = "SELECT * FROM messages ORDER BY timestamp DESC";  
$result = $conn->query($sql);  if ($result->num_rows > 0) {  while ($row = $result->fetch_assoc()) {  echo "<p>提交时间：" . $row["timestamp"]  . "<br>". nl2br($row["content"])."<hr></p>";  }  
} else {  echo "目前还没有留言。";  
}  $conn->close();  
?>