Second-hand recycling website developed with PHP realizes instant online payment function

The second-hand recycling website developed by PHP realizes instant online payment function

With the enhancement of social awareness of environmental protection, the second-hand recycling industry has risen rapidly. In order to improve user experience and facilitate transactions, many second-hand recycling websites have introduced instant online payment functions. This article will introduce how to use PHP to develop a second-hand recycling website and implement instant online payment functions.

1. Environment preparation
Before starting, we need to prepare the following environment:

1. Server environment: Apache or Nginx, MySQL, PHP
2. Development tools : Text editor (such as Sublime Text, Visual Studio Code, etc.)
3. Payment interface: Alipay or WeChat payment, etc.

2. Database design
In second-hand recycling websites, We need to create the following database tables:

1. User table (user): stores the user's basic information, such as user ID, user name, password, etc.
2. Product table (product): stores second-hand product information released by users, such as product ID, name, price, etc.
3. Order table (order): stores the user's order information, such as order ID, user ID, product ID, payment status, etc.

3. User registration and login functions
User registration and login are the basic functions of the website. We can use PHP's Session or Token mechanism to implement user login status management. The following is a sample code for user registration and login:

session_start();

// User registration
function registerUser($username, $password) {

// 将用户名与密码存入数据库中的用户表
// ...

}

// User login
function loginUser($username, $password) {

// 验证用户名与密码是否正确
// ...

if ($loginSuccess) {
    $_SESSION['username'] = $username; // 将用户名存入Session中，表示已登录状态
    echo "登录成功";
} else {
    echo "用户名或密码错误";
}

}

// User registration Example with login
if ($_SERVER['REQUEST_METHOD'] === 'POST') { // The user submitted the form

$action = $_POST['action'];
$username = $_POST['username'];
$password = $_POST['password'];

if ($action === 'register') {
    registerUser($username, $password);
} elseif ($action === 'login') {
    loginUser($username, $password);
}

}
?>

four , Product publishing and display function
Users can publish their own second-hand product information on the website and display it for other users to browse. We can use PHP's form processing and database operations to achieve this function. The following is a sample code for product release and display:

// Database connection configuration
$host = 'localhost';
$username = 'root';
$password = 'password';
$dbname = 'test';

// Connect to the database
$conn = new mysqli($host, $username, $password, $dbname) ;
if ($conn->connect_error) {

die("连接失败: " . $conn->connect_error);

}

// Product publishing
function publishProduct($userId, $productName, $productPrice) {

global $conn;

// 将商品信息存入数据库中的商品表
$sql = "INSERT INTO product (user_id, name, price) VALUES ('$userId', '$productName', '$productPrice')";
if ($conn->query($sql) === TRUE) {
    echo "商品发布成功";
} else {
    echo "商品发布失败: " . $conn->error;
}

}

// Product display
function displayProducts() {

global $conn;

// 查询数据库中的商品表
$sql = "SELECT * FROM product";
$result = $conn->query($sql);

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

}

// Product release and display example
if ( $_SERVER['REQUEST_METHOD'] === 'POST') { // The user submitted the form

$action = $_POST['action'];

if ($action === 'publish') {
    $userId = ''; // 获取当前登录用户的ID
    $productName = $_POST['productName'];
    $productPrice = $_POST['productPrice'];
    publishProduct($userId, $productName, $productPrice);
}

}

// Display all products
displayProducts();

// Close the database connection
$conn->close();
?>

5. Payment function implementation
Finally, we need to integrate the instant online payment function Go to the second-hand recycling website. Taking Alipay as an example, we need to first register a developer account on the Alipay open platform and obtain the App ID and key. The following is a sample code for the payment function:

// Omit the code that saves the user's order information to the order table...

// Generate a payment link
function generatePaymentLink($orderNumber, $totalAmount) {

$alipayAppId = 'your_app_id';
$alipayPrivateKey = 'your_private_key';
$alipayPublicKey = 'your_public_key';

$url = 'https://openapi.alipay.com/gateway.do';
$method = 'alipay.trade.page.pay';
$notifyUrl = 'http://your_domain.com/notify.php'; // 支付回调通知地址

$params = [
    'app_id' => $alipayAppId,
    'method' => $method,
    'format' => 'JSON',
    'charset' => 'utf-8',
    'sign_type' => 'RSA2',
    'timestamp' => date('Y-m-d H:i:s'),
    'version' => '1.0',
    'notify_url' => $notifyUrl,
    'biz_content' => json_encode([
        'out_trade_no' => $orderNumber, // 订单号
        'product_code' => 'FAST_INSTANT_TRADE_PAY',
        'total_amount' => $totalAmount, // 订单金额
        'subject' => '商品名称', // 商品名称
    ])
];

ksort($params);
$paramsStr = '';
foreach ($params as $key => $val) {
    $paramsStr .= $key . '=' . $val . '&';
}
$paramsStr = rtrim($paramsStr, '&');
$sign = base64_encode(openssl_sign($paramsStr, openssl_pkey_get_private($alipayPrivateKey), OPENSSL_ALGO_SHA256));

$params['sign'] = urlencode($sign);

$link = $url . '?' . http_build_query($params);

return $link;

}

// Payment page
if ($_SERVER['REQUEST_METHOD'] === 'POST') { // The user submitted the form

$action = $_POST['action'];

if ($action === 'pay') {
    $orderNumber = ''; // 获取订单号
    $totalAmount = ''; // 获取订单金额
    $paymentLink = generatePaymentLink($orderNumber, $totalAmount);
  
    echo "订单支付链接：$paymentLink";
}

}
?>

At this point, we have completed the second-hand recycling website developed in PHP and implemented the instant online payment function. Users can register, log in, publish second-hand goods on the website, and pay for orders through Alipay. I believe that through this example, you can better understand and apply relevant knowledge in PHP development. Happy coding!

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