With the gradual popularization of the Internet, websites have become one of the main ways for people to obtain information, communicate, and entertain. As one of the common communication tools on the website, the message board has become an indispensable part of the website. In this article, we will introduce how to use PHP to create a modifiable message board.

1. Environment setup

To create a message board, you first need to set up the corresponding environment. Here, we will use XAMPP to set up a local server environment.

The steps are as follows:

1. Download and install the XAMPP software;
2. Start the Apache and MySQL services of XAMPP;
3. Open the browser and enter localhost , after selecting the language and authentication method on the page, enter the XAMPP management panel;
4. In the management panel, click phpMyAdmin to enter the database management page.

2. Create database and data table

Create a database and name it guestbook. Create a data table named messages under the database. The data table contains the following fields:

Field name type length description
id int 11 Message ID, primary key, auto-increment
username varchar 50 Username
email varchar 100 Email
message text Message content
post_time datetime Message time

3. Create message board page

In this step, we will create A message board page that allows users to fill in messages and displays existing messages.

1. Make the UI of the message board page

Add the following code in the html:

    
    



    
留言板

    

        

            
发布留言
            用户名：

            邮箱：

            留言：

            

            
        
    

    

        
最新留言
        
    

As you can see, the message board page contains two parts, one part is for posting messages form, and the other part is a list of existing messages.

2. Submit a message

After submitting the form on the message board page, the submitted data needs to be saved in the database.

Create a file named post_message.php in the root directory to process the data in the message submission form.

Add the following code in the file:

In this file, first connect to the database and obtain the form data. The data is then inserted into the messages data table.

3. Display messages

On the message board page, the latest messages need to be displayed. To do this, you can display the list of messages from the database in the second part of the message board page.

In html, modify the following code:

    
最新留言
    
            

            

                
用户名：
                
邮箱：
                
时间：
                
留言内容：
            
        

In this code, first query the messages data table in the database, and save the queried message data to $result. Subsequently, the message data is traversed through a while loop and displayed on the page.

4. Modify messages

In the message board, users can modify the submitted messages.

In the html code, modify the code to display the message as follows:

    
最新留言
    
            

            

                
用户名：
                
邮箱：
                
时间：
                
留言内容：
                修改
            
        

You can see that a hyperlink has been added for modifying the message.

In the edit_message.php file, add the following code:

    
    



    
修改留言

    

        

            
修改留言
            用户名：

            邮箱：

            留言：

            <?php echo $row['message']; ?>

            
            
        
    

In this code, first query the message information based on the ID, and display the queried message data in the form. The user can then modify the message on this page. Among them, the hidden field input is used to save the message ID so that the database can be updated based on the ID when the message is saved later.

In the save_message.php file, add the following code:

In this file, first connect to the database and obtain the message data and message ID in the form. Subsequently, the message data in the database is updated according to the ID.

5. Summary

Through the introduction of this article, I believe readers have learned how to use PHP to create a modifiable message board. In the actual development process, the message board can also be expanded with richer functions, such as replying to messages, displaying the number of messages, sorting by time, etc.

The above is the detailed content of Create a modifiable message board in php. For more information, please follow other related articles on the PHP Chinese website!