二手回收网站利用PHP开发的多种付款方式选择

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "transactions";

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

if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

// 获取用户选择的支付方式
$paymentMethod = $_POST['payment_method'];

// 插入交易信息到数据库
$sql = "INSERT INTO transactions (user_id, item_id, payment_method, amount, status) VALUES ('1', '1', '$paymentMethod', '100', '待支付')";

if ($conn->query($sql) === true) {
    echo "交易成功";
} else {
    echo "交易失败：" . $conn->error;
}

$conn->close();
?>

<form action="payment.php" method="post">
  <input type="radio" name="payment_method" value="支付宝"> 支付宝
  <input type="radio" name="payment_method" value="微信支付"> 微信支付
  <input type="radio" name="payment_method" value="银行转账"> 银行转账
  <input type="submit" value="确认付款">
</form>

<?php
// 连接数据库
$servername = "localhost";
$username = "root";
$password = "123456";
$dbname = "transactions";

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

if ($conn->connect_error) {
    die("连接数据库失败: " . $conn->connect_error);
}

// 查询用户的交易记录
$sql = "SELECT * FROM transactions";

$result = $conn->query($sql);

if ($result->num_rows > 0) {
    // 输出数据
    while($row = $result->fetch_assoc()) {
        echo "交易ID：" . $row["id"]. " - 用户ID：" . $row["user_id"]. " - 支付方式：" . $row["payment_method"]. " - 交易金额：" . $row["amount"]. "<br>";
    }
} else {
    echo "没有交易记录。";
}

$conn->close();
?>