Second-hand recycling website developed with PHP realizes user consumption record viewing function

The second-hand recycling website developed by PHP realizes the user consumption record viewing function

Introduction:
The second-hand recycling website is a very popular website type in recent years. It provides users with a convenient platform to buy and sell. Or recycle second-hand goods. For such a website, the viewing function of user consumption records is essential. This article will introduce how to use PHP to develop a user consumption record viewing function, and provide code samples for readers' reference.

1. Database design:
First, we need to design a database to store user consumption records. Suppose we have a table named "consumption_records" with the following table structure:

CREATE TABLE `consumption_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `item_id` int(11) NOT NULL,
  `amount` decimal(10,2) NOT NULL,
  `order_date` datetime NOT NULL,
  PRIMARY KEY (`id`)
);

In the above table, we have defined five fields: id, user_id, item_id, amount and order_date. Among them, id is the primary key, user_id represents the user's ID, item_id represents the product's ID, amount represents the consumption amount, and order_date represents the creation time of the order.

2. PHP code implementation:
Below, we will use PHP to implement the function of viewing user consumption records.

1. First, we need to connect to the database. You can use the following code to implement database connection:

<?php
$servername = "localhost";
$username = "username";
$password = "password";
$dbname = "database";

$conn = new mysqli($servername, $username, $password, $dbname);

if ($conn->connect_error) {
    die("Connection failed: " . $conn->connect_error);
}
?>

In the above code, you need to replace "username", "password" and "database" with the real database username, password and database name.

2. The function of viewing user consumption records is implemented as follows:

<?php
$user_id = $_GET['user_id']; // 获取用户ID

$sql = "SELECT * FROM consumption_records WHERE user_id = '$user_id' ORDER BY order_date DESC";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    echo "<table>";
    echo "<tr><th>ID</th><th>用户ID</th><th>商品ID</th><th>金额</th><th>创建时间</th></tr>";
    while($row = $result->fetch_assoc()) {
        echo "<tr>";
        echo "<td>" . $row["id"] . "</td>";
        echo "<td>" . $row["user_id"] . "</td>";
        echo "<td>" . $row["item_id"] . "</td>";
        echo "<td>" . $row["amount"] . "</td>";
        echo "<td>" . $row["order_date"] . "</td>";
        echo "</tr>";
    }
    echo "</table>";
} else {
    echo "没有找到相关记录";
}

$conn->close();
?>

In the above code, first obtain the user ID from the URL, and then obtain the user's consumption through SQL query Record and arrange in reverse order of creation time. Then, display the obtained data through a table.

3. Summary:
Through the above code examples, we have implemented a simple user consumption record viewing function. Users can view their consumption records by entering their ID and display them in table form. This is a very useful feature for second-hand recycling websites.

Of course, the above code is just a simple example. In actual development, appropriate modifications and optimizations need to be made according to specific needs. However, this example provides us with a basic framework and ideas to implement the user consumption record viewing function.

I hope this article can be helpful to developers who are developing second-hand recycling websites. For more details on this article, please refer to the PHP official documentation.

The above is the detailed content of Second-hand recycling website developed with PHP realizes user consumption record viewing function. For more information, please follow other related articles on the PHP Chinese website!