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:

    
  
留言板
  
 姓名： 
 留言内容： 
  
 
  
留言列表
   

Among them, theactionattribute of the form points to asave_message. phpfile. 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 thesave_message.phpfile 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 namedguestbook, and a database namedmessages Thetable 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;

2. Write PHP code

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

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

The code is as follows:

prepare($sql); $stmt->bindParam(':name', $name); $stmt->bindParam(':message', $message); $stmt->execute(); // 输出提示信息 echo '留言保存成功！';

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:

    
  
留言板
  
 姓名： 
 留言内容： 
  
 
  
留言列表
 query($sql); $messages = $stmt->fetchAll(); // 展示留言 foreach ($messages as $message) { echo "
{$message['name']}：{$message['message']}
"; } ?>  

In this code, we first connect to the MySQL database, and then query all the messages in themessagestable, 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!