PHP implements message board function-PHP Tutorial-php.cn

PHP implements message board function

王林

Release： 2023-06-22 17:20:01

Original

4187 people have browsed it

With the popularity of the Internet, website message boards have become a must-have feature for many websites. There are many ways to implement message boards, one of the more common ones is to use PHP. This article will introduce how to use PHP to implement message board functions.

1. Front-end page design

Before implementing the message board, we need to design the front-end page first. A typical message board page usually contains the following parts:

1. Message input box: used to enter message content.
2. Message list: used to display existing messages.
3. Message submission button: used to submit messages.

Based on the above requirements, we can design a message board HTML page with the following code:

<!DOCTYPE html>
<html>
<head>
    <title>留言板</title>
</head>
<body>
    <h1>留言板</h1>
    
    <!-- 留言输入框 -->
    <form action="save_message.php" method="post">
        <label for="name">姓名：</label>
        <input type="text" id="name" name="name"><br>
        <label for="message">留言内容：</label>
        <textarea id="message" name="message" rows="5" cols="50"></textarea><br>
        <input type="submit" value="提交留言">
    </form>
    
    <hr>
    
    <!-- 留言列表 -->
    <h2>留言列表</h2>
    <?php
        // TODO: 展示留言列表
    ?>
</body>
</html>

Copy after login

Among them, the action attribute of the form points to a save_message. php file. This file will implement the functions of accepting submitted messages and displaying the message list.

2. Save the message

Next, we need to implement the logic of the save_message.php file to accept data from the message board HTML page and save them in the database. The specific steps are as follows:

1. Create a MySQL database

In the MySQL database, we need to create a database named guestbook, and a database named messages The table is used to save messages. The structure of the table is as follows:

CREATE TABLE `messages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Copy after login

2. Write PHP code

Next, let’s write the code for the save_message.php file. This file needs to complete the following tasks:

Receive the user name and message content from the form.
Save these data to the messages table in the MySQL database.
Display a prompt message indicating successful saving.

The code is as follows:

<?php
// 从表单中接收数据
$name = $_POST['name'];
$message = $_POST['message'];

// 连接数据库
$dsn = 'mysql:host=localhost;dbname=guestbook';
$username = 'root';
$password = '';
$db = new PDO($dsn, $username, $password);

// 插入留言
$sql = "INSERT INTO messages (name, message) VALUES (:name, :message)";
$stmt = $db->prepare($sql);
$stmt->bindParam(':name', $name);
$stmt->bindParam(':message', $message);
$stmt->execute();

// 输出提示信息
echo '留言保存成功！';

Copy after login

3. Display the message list

Now, we can save the data from the message board HTML page to the MySQL database . Next, we need to modify the HTML page to display the existing message content.

The modified HTML code is as follows:

<!DOCTYPE html>
<html>
<head>
    <title>留言板</title>
</head>
<body>
    <h1>留言板</h1>
    
    <!-- 留言输入框 -->
    <form action="save_message.php" method="post">
        <label for="name">姓名：</label>
        <input type="text" id="name" name="name"><br>
        <label for="message">留言内容：</label>
        <textarea id="message" name="message" rows="5" cols="50"></textarea><br>
        <input type="submit" value="提交留言">
    </form>
    
    <hr>
    
    <!-- 留言列表 -->
    <h2>留言列表</h2>
    <?php
        // 连接数据库
        $dsn = 'mysql:host=localhost;dbname=guestbook';
        $username = 'root';
        $password = '';
        $db = new PDO($dsn, $username, $password);

        // 查询留言
        $sql = "SELECT * FROM messages ORDER BY created_at DESC";
        $stmt = $db->query($sql);
        $messages = $stmt->fetchAll();

        // 展示留言
        foreach ($messages as $message) {
            echo "<p><strong>{$message['name']}：</strong>{$message['message']}</p>";
        }
    ?>
</body>
</html>

Copy after login

In this code, we first connect to the MySQL database, and then query all the messages in the messages table, and sort them according to time Sort. Finally, display all messages in a loop.

To sum up, it is not difficult to use PHP to implement the message board function, and the effect is great. I hope this article can be helpful to PHP beginners.

The above is the detailed content of PHP implements message board function. For more information, please follow other related articles on the PHP Chinese website!