Second-hand recycling website developed by PHP to realize user account balance management

The second-hand recycling website developed by PHP realizes user account balance management

With the continuous development of the second-hand recycling market, more and more people are paying attention to environmental protection and resource recycling. In order to meet people's demand for second-hand goods, second-hand recycling websites came into being. On such a website, users can buy, sell, and exchange their second-hand items, but in order to ensure the safety and convenience of transactions, an important function is user account balance management.

As a scripting language widely used in website development, PHP is easy to learn and has strong compatibility. Below we will take the second-hand recycling website developed in PHP as an example to introduce how to implement user account balance management.

First, we need to create a database table to store user account information. Assume that the table we create is named "user" and contains the following fields: id, username, password, and balance. Among them, id is the primary key and is used to uniquely identify the user; username and password are used for user login respectively; balance is used to record the user's account balance.

Next, we need to write PHP code to implement the account balance management function. First, we need to connect to the database and define some database operation functions, such as connect(), disconnect(), query(), etc. The implementation of these functions can use PHP's own database extensions, such as mysqli.

<?php
$db_host = "localhost"; //数据库主机名
$db_user = "root"; //数据库用户名
$db_pass = "123456"; //数据库密码
$db_name = "test"; //数据库名称

//连接数据库
function connect() {
    global $db_host, $db_user, $db_pass, $db_name;
    $conn = mysqli_connect($db_host, $db_user, $db_pass, $db_name);
    if (!$conn) {
        die("数据库连接失败：" . mysqli_connect_error());
    }
    return $conn;
}

//关闭数据库连接
function disconnect($conn) {
    mysqli_close($conn);
}

//执行数据库查询语句
function query($conn, $sql) {
    $result = mysqli_query($conn, $sql);
    if (!$result) {
        die("数据库查询失败：" . mysqli_error($conn));
    }
    return $result;
}

?>

After completing the definition of database connection and operation functions, we can begin to implement the specific functions of account balance management. For example, users can recharge, check balance, deduct balance, etc.

<?php
//充值函数
function recharge($conn, $userId, $amount) {
    //查询原余额
    $sql = "SELECT balance FROM user WHERE id = $userId";
    $result = query($conn, $sql);
    $row = mysqli_fetch_assoc($result);
    $balance = $row['balance'];
    
    //更新余额
    $balance += $amount;
    $sql = "UPDATE user SET balance = $balance WHERE id = $userId";
    query($conn, $sql);
}

//查询余额函数
function getBalance($conn, $userId) {
    $sql = "SELECT balance FROM user WHERE id = $userId";
    $result = query($conn, $sql);
    $row = mysqli_fetch_assoc($result);
    return $row['balance'];
}

//扣除余额函数
function deductBalance($conn, $userId, $amount) {
    //查询原余额
    $sql = "SELECT balance FROM user WHERE id = $userId";
    $result = query($conn, $sql);
    $row = mysqli_fetch_assoc($result);
    $balance = $row['balance'];
    
    //检查余额是否足够
    if ($balance < $amount) {
        die("余额不足");
    }
    
    //更新余额
    $balance -= $amount;
    $sql = "UPDATE user SET balance = $balance WHERE id = $userId";
    query($conn, $sql);
}
?>

The above code example shows the implementation process of recharging, querying balance, and deducting balance. In specific website logic, we can call these functions according to specific needs.

In the front-end interface of the website, we can provide corresponding buttons or forms for recharging, checking balance, and deducting balance, so that users can operate conveniently. During back-end processing, we can call the above-mentioned PHP function to manage the account balance through the database.

Summary:
Through the above code examples, we show how to use PHP to develop the user account balance management function of a second-hand recycling website. Of course, this is only part of the functions. The actual second-hand recycling website also needs to include user registration, login, product publishing, product purchase and other functions. I hope this article will help you understand the second-hand recycling website developed by PHP and user account balance management.

The above is the detailed content of Second-hand recycling website developed by PHP to realize user account balance management. For more information, please follow other related articles on the PHP Chinese website!