PHP implements user feedback and problem complaint functions in the knowledge question and answer website.

PHP implements user feedback and problem complaint functions in the Q&A website

With the rapid development of social networks and the Internet, the Q&A website plays an increasingly important role in our lives. On these sites, users can share their knowledge and experiences, solve other people's problems, and get help from others. However, during the process of user participation, they may encounter some problems or make comments on the functions of the website. At this time, in order to better serve users, we need to implement user feedback and problem complaint functions in the website.

This article will use the PHP programming language to implement a basic user feedback and problem complaint function. First, we need to create a database to store user opinions and complaint information. The following is a code example to create a database:

CREATE DATABASE feedback;
USE feedback;

CREATE TABLE feedback_info (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    type ENUM('Feedback', 'Complaint'),
    content TEXT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

In the above code, we created a database named "feedback" and placed it in it. A table named "feedback_info" is created to store user feedback and complaint information. Among them, the field "id" is an auto-increment primary key, "user_id" represents the user's ID, "type" is the feedback type, which can be "Feedback" (feedback) or "Complaint" (problem complaint), and "content" is used for storage User feedback or complaint content, "created_at" indicates the timestamp when the record was created.

Next, we need to add a feedback form to the front-end page of the website so that users can fill in feedback and complaints. The following is a simple sample code:

<form action="submit_feedback.php" method="POST">
    <label for="type">反馈类型：</label>
    <select name="type" id="type">
        <option value="Feedback">意见反馈</option>
        <option value="Complaint">问题投诉</option>
    </select><br>

    <label for="content">内容：</label>
    <textarea name="content" id="content" cols="30" rows="10"></textarea><br>

    <input type="submit" value="提交">
</form>

In the above code, we added a drop-down list box to the feedback form, the user can select the feedback type, and also added a multi-line text box, the user can fill in the specific feedback or complaint content. The back-end processing script "submit_feedback.php" for submitting data is specified through the "action" attribute of the form.

In the back-end PHP script "submit_feedback.php", we need to accept and process the data submitted by the user and store it in the database. The following is a simple code example:

<?php
// 连接数据库
$con = mysqli_connect("localhost", "root", "password", "feedback");

// 处理用户的反馈和投诉内容
$type = $_POST['type'];
$content = $_POST['content'];
$user_id = 1;  // 假设用户ID为1，可以根据实际情况修改

// 将用户的反馈和投诉内容插入到数据库中
$query = "INSERT INTO feedback_info (user_id, type, content) VALUES ('$user_id', '$type', '$content')";
mysqli_query($con, $query);

// 关闭数据库连接
mysqli_close($con);

// 返回到反馈页面或者其他页面
header("Location: feedback.php");
exit();
?>

In the above code, we first use the mysqli_connect() function to connect to the database and obtain the feedback type and content submitted by the user through $_POST[]. Then, insert the user's feedback and complaints into the "feedback_info" table, and finally use the mysqli_close() function to close the database connection. At the same time, we use the header() function to redirect the user to the feedback page or other pages.

After completing the implementation of the above code, users can submit their own feedback and problem complaints on the website. Through the implementation of the above code, we can collect user feedback and complaint information and store it in the database, thereby realizing user feedback and problem complaint functions. In addition, we can also expand functions, such as viewing or handling user feedback and complaints in the backend management page.

To sum up, the user feedback and problem complaint functions in the Q&A website are very important to enhance the user experience and improve the website. By using the PHP programming language, we can implement a simple user feedback and complaint function, and store user opinions and questions into the database, providing valuable reference for website improvement and optimization.

The above is the detailed content of PHP implements user feedback and problem complaint functions in the knowledge question and answer website.. For more information, please follow other related articles on the PHP Chinese website!