Second-hand recycling website developed using PHP supports online price negotiation

Using PHP to develop a second-hand recycling website that supports online price negotiation

With people's increasing awareness of environmental protection and recognition of the value of second-hand items, the second-hand recycling market is gradually emerging. In order to meet users' needs for second-hand items, more and more second-hand recycling websites have emerged. This article will introduce a second-hand recycling website developed using PHP, and focus on how to support the function of online negotiation.

1. Establish a database

Before starting development, we need to establish a database to store the product information and user bargaining records of the website. The following is a simple database table structure example:

Product table (tb_goods)
Fields: product ID (id), product name (name), product price (price), etc.

Bargaining record table (tb_bargain)
Fields: Bargaining ID (id), product ID (goods_id), user ID (user_id), bargaining price (bargain_price), bargaining time (bargain_time), etc.

2. Website development

1. Functional requirements analysis

Before developing the website, we need to clarify the functional requirements of the website. This article mainly introduces the bargaining function of second-hand recycling websites, that is, users can negotiate the price of goods according to their own needs. Therefore, we need to implement the following functions:

• Product display: display all second-hand product information.
• Product details: After clicking on a product, the detailed information of the product will be displayed.
• User registration/login: Users need to register and log in to negotiate prices.
• Submit negotiation: Users can negotiate prices based on product information and submit the negotiation results to the seller.
• Historical negotiation records: Users can view their historical negotiation records.

2. Development process

(1) Connect to the database

First, connect to the database in the PHP code. Connections can be made using extensions such as mysqli or PDO.

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

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

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

(2) Product display

Create a product display page, obtain product information from the database and display:

<?php
$sql = "SELECT * FROM tb_goods";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "商品名称：" . $row["name"]. " - 价格: " . $row["price"]. "<br>";
    }
} else {
    echo "暂无商品信息";
}
?>

(3) Product details

Create a product details page and obtain product details from the database based on the product ID:

<?php
$goodsID = $_GET['goods_id'];
$sql = "SELECT * FROM tb_goods WHERE id = $goodsID";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    $row = $result->fetch_assoc();
    echo "商品名称：" . $row["name"]. "<br>";
    echo "价格：" . $row["price"]. "<br>";
} else {
    echo "商品不存在";
}
?>

(4) User registration/login

Create a user registration and login page, and add the user information Stored in database.

(5) Submit negotiation

Create a negotiation page where users can enter the negotiation amount and submit the result to the seller. After the negotiation is successful, the record is inserted into the negotiation record table.

<?php
$userID = $_SESSION['user_id'];
$goodsID = $_POST['goods_id'];
$bargainPrice = $_POST['bargain_price'];

$sql = "INSERT INTO tb_bargain (goods_id, user_id, bargain_price) VALUES ($goodsID, $userID, $bargainPrice)";

if ($conn->query($sql) === TRUE) {
    echo "议价成功";
} else {
    echo "议价失败: " . $conn->error;
}
?>

(6) Historical bargaining record

Create a historical bargaining record page, and obtain the user's historical bargaining record from the bargaining record table based on the user ID.

<?php
$userID = $_SESSION['user_id'];
$sql = "SELECT * FROM tb_bargain WHERE user_id = $userID";
$result = $conn->query($sql);

if ($result->num_rows > 0) {
    while($row = $result->fetch_assoc()) {
        echo "议价时间：" . $row["bargain_time"]. " - 价格: " . $row["bargain_price"]. "<br>";
    }
} else {
    echo "暂无议价记录";
}
?>

Second-hand recycling websites support online price negotiation, providing users with greater flexibility and selectivity. Through the above sample code, we can develop a fully functional second-hand recycling website based on PHP, allowing users to easily negotiate product prices and learn about relevant negotiation records. I hope this article is helpful in understanding how to develop the negotiation function of a second-hand recycling website.

The above is the detailed content of Second-hand recycling website developed using PHP supports online price negotiation. For more information, please follow other related articles on the PHP Chinese website!