当前位置：首页 > PHP

php实现充值

2026-02-14 06:51:45PHP

PHP 实现充值功能

实现充值功能通常涉及用户账户余额更新、支付接口集成和交易记录存储。以下是关键步骤和代码示例：

数据库设计

创建必要的数据库表存储用户信息和交易记录：

php实现充值

CREATE TABLE users (
    id INT AUTO_INCREMENT PRIMARY KEY,
    username VARCHAR(50) NOT NULL,
    balance DECIMAL(10,2) DEFAULT 0.00
);

CREATE TABLE transactions (
    id INT AUTO_INCREMENT PRIMARY KEY,
    user_id INT,
    amount DECIMAL(10,2),
    payment_method VARCHAR(50),
    status VARCHAR(20) DEFAULT 'pending',
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP,
    FOREIGN KEY (user_id) REFERENCES users(id)
);

充值表单页面

创建HTML表单让用户输入充值金额和选择支付方式：

<form action="process_payment.php" method="post">
    <label for="amount">充值金额：</label>
    <input type="number" name="amount" min="1" step="0.01" required>

    <label for="payment_method">支付方式：</label>
    <select name="payment_method" required>
        <option value="alipay">支付宝</option>
        <option value="wechat">微信支付</option>
        <option value="bank">银行卡</option>
    </select>

    <button type="submit">确认充值</button>
</form>

处理充值请求

创建PHP脚本处理充值请求并更新数据库：

php实现充值

<?php
// 连接数据库
$db = new PDO('mysql:host=localhost;dbname=your_db', 'username', 'password');

// 获取表单数据
$user_id = $_SESSION['user_id'];
$amount = floatval($_POST['amount']);
$payment_method = $_POST['payment_method'];

// 开始事务
$db->beginTransaction();

try {
    // 记录交易
    $stmt = $db->prepare("INSERT INTO transactions (user_id, amount, payment_method) VALUES (?, ?, ?)");
    $stmt->execute([$user_id, $amount, $payment_method]);

    // 更新用户余额
    $stmt = $db->prepare("UPDATE users SET balance = balance + ? WHERE id = ?");
    $stmt->execute([$amount, $user_id]);

    // 提交事务
    $db->commit();

    // 跳转到成功页面
    header("Location: payment_success.php");
} catch (Exception $e) {
    // 回滚事务
    $db->rollBack();
    echo "充值失败: " . $e->getMessage();
}
?>

支付网关集成

集成第三方支付API（以支付宝为例）：

// 配置支付宝参数
$alipay_config = [
    'app_id' => 'your_app_id',
    'merchant_private_key' => 'your_private_key',
    'alipay_public_key' => 'alipay_public_key',
    'gateway_url' => 'https://openapi.alipay.com/gateway.do',
    'notify_url' => 'https://yoursite.com/payment_notify.php'
];

// 创建支付请求
require_once 'alipay-sdk/AopSdk.php';
$alipayRequest = new AlipayTradePagePayRequest();
$alipayRequest->setReturnUrl('https://yoursite.com/payment_return.php');
$alipayRequest->setNotifyUrl($alipay_config['notify_url']);
$alipayRequest->setBizContent(json_encode([
    'out_trade_no' => uniqid(),
    'total_amount' => $amount,
    'subject' => '账户充值',
    'product_code' => 'FAST_INSTANT_TRADE_PAY'
]));

// 发起支付
$aop = new AopClient();
$aop->gatewayUrl = $alipay_config['gateway_url'];
$aop->appId = $alipay_config['app_id'];
$aop->rsaPrivateKey = $alipay_config['merchant_private_key'];
$aop->alipayrsaPublicKey = $alipay_config['alipay_public_key'];
$aop->format = 'json';
$result = $aop->pageExecute($alipayRequest);

// 输出支付表单
echo $result;

支付结果通知

处理支付平台回调通知：

// 验证支付宝通知
$aop = new AopClient();
$aop->alipayrsaPublicKey = $alipay_config['alipay_public_key'];
$flag = $aop->rsaCheckV1($_POST, NULL, "RSA2");

if ($flag) {
    // 验证交易状态
    if ($_POST['trade_status'] == 'TRADE_SUCCESS') {
        $out_trade_no = $_POST['out_trade_no'];
        $trade_no = $_POST['trade_no'];
        $amount = $_POST['total_amount'];

        // 更新交易状态
        $stmt = $db->prepare("UPDATE transactions SET status = 'completed' WHERE id = ?");
        $stmt->execute([$out_trade_no]);

        echo "success";
    }
} else {
    // 验证失败
    echo "fail";
}