PHP mall development skills: implementing product evaluation and comment functions

PHP mall development skills: Implement product evaluation and comment functions

Introduction:
On the online shopping platform, the product evaluation and comment function is a very important part. It not only helps consumers understand the true condition of goods, but also provides valuable feedback to merchants to help improve products and services. This article will introduce how to use PHP to implement a simple product evaluation and review function, and provide code examples.

1. Create a database table
First, we need to create a database table to store evaluation and comment data. In MySQL, you can create a table named "comments" using the following statement:

CREATE TABLE comments (
id int(11) NOT NULL AUTO_INCREMENT,
product_id int(11) NOT NULL,
user_id int(11) NOT NULL,
rating int(11) NOT NULL,
comment text NOT NULL,
created_at timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

The table contains the following fields:

• id: the unique identifier of the evaluation/comment
• product_id: the unique identifier of the product Identifier, used to associate ratings/comments with products
• user_id: User's unique identifier, used to associate ratings/comments with users
• rating: The star rating of the rating, which can be 1- An integer between 5
• comment: The text content of the comment
• created_at: The creation time, use the default value as the current time

2. Add product evaluation and comments Function

1. Display product evaluations and comments
   First, we need to display existing evaluations and comments on the product details page. You can use the following PHP code to query the database, obtain the evaluation and review data of the specified product, and display it on the page in the form of a list:

// Connect to the database
$connection = mysqli_connect('localhost', 'username', 'password', 'database');
if (mysqli_connect_errno()){

echo "连接数据库失败：" . mysqli_connect_error();
exit();

}

// Query Product ratings and comments
$product_id = $_GET['product_id'];
$query = "SELECT * FROM comments WHERE product_id = $product_id";
$result = mysqli_query($connection, $query );

// Display ratings and comments
while ($row = mysqli_fetch_assoc($result)){

echo "<div>";
echo "评分：" . $row['rating'];
echo "评论：" . $row['comment'];
echo "</div>";

}

// Close the database connection
mysqli_close($connection);
?>

2. Add product ratings and comments
   In the product details page, we need to add a form so that users can enter ratings and comments. The following PHP code can be used to handle form submission and insert data into the database:

// Connect to the database
$connection = mysqli_connect('localhost', 'username', 'password', 'database');
if (mysqli_connect_errno()){

echo "连接数据库失败：" . mysqli_connect_error();
exit();

}

// Process form submission
if ($_SERVER[ "REQUEST_METHOD"] == "POST") {

$product_id = $_POST['product_id'];
$user_id = $_POST['user_id'];
$rating = $_POST['rating'];
$comment = $_POST['comment'];

// 插入评价和评论数据到数据库
$query = "INSERT INTO comments (product_id, user_id, rating, comment) VALUES ($product_id, $user_id, $rating, '$comment')";
$result = mysqli_query($connection, $query);

// 检查是否成功插入数据
if ($result){
    echo "评价和评论已成功提交！";
} else {
    echo "提交失败，请重试。";
}

}

// Close the database connection
mysqli_close($connection);
?>

三、Summary
Through the above steps, we successfully implemented the product evaluation and comment functions. Users can see existing ratings and comments on the product details page, and can add their own ratings and comments. This feature not only provides useful information to other users, but also helps merchants continuously improve their products and services. By using the comment function appropriately, merchants can improve user satisfaction and increase sales.

It should be noted that this article only provides a simple implementation and does not involve user authentication and other advanced functions. In actual development, the security and legality of data also need to be considered, and appropriate expansion and optimization should be carried out according to needs.

I hope this article can help with the product evaluation and comment functions in PHP mall development, making your mall website more complete and practical.

The above is the detailed content of PHP mall development skills: implementing product evaluation and comment functions. For more information, please follow other related articles on the PHP Chinese website!